<![CDATA[Últimas mensagens do tópico "[Erro]JSTL + Derby = Não conecta"]]> http://www.portaljava.com/forum/posts/list/34.page JForum - http://www.jforum.net [Erro]JSTL + Derby = Não conecta
Estou tentando fazer um exemplo pratico de uma tela de cadastro usando JSP JStl porem o meu fica dando datasource is null (mesmo se eu inserir dados no meu banco deixa a mesma mensagem) javax.servlet.jsp.JspException: 'dataSource' is null

segue abaixo os meus fonts
[code]
<%--
Document : gravaCliente
Created on : 01/07/2008, 10:28:23
Author : patrick
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<html>
<head>
<sql:setDataSource var="ds"
driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby://localhost:1527/Derby"
user="dbuser"
password="dbsenha"
scope="session"

/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Teste JSTL</title>
</head>
<body>
<h1>Exemplo JSTL Tela Cadastro</h1>
<hr>
<form action="gravaCliente.jsp" method="post" />
<label>Código</label><br>
<input type="text" name="edtCodigo" size="10"><br>
<label>Nome :</label>
<input type="text" name="edtNome" size="60"><br>
<label>CpF:</label><br>
<input type="text" name="edtcpf" size="10"><br>
<label>RG:</label><br>
<input type="text" name="edtRG" size="15"><br>
<label>Estado:</label>
<sql:query var="qryEstados" dataSource="${ds}">
select * from ESTADOS
ORDER BY NOME
</sql:query>

<select name="cmbEstados">
<c:forEach var="Estado" items="${qryEstados.row}">
<option value="PA"> ${Estado.nome} </option>

</c:forEach>

</select><br>

<label>TELEFONE::</label><br>
<input type="text" name="edtTelefone" size="15"><br>
<label>Email:</label><br>
<input type="text" name="edtEmail" size="15"><br>
<hr>

<input accesskey="o" type="submit" name="BTok" value="ok" >
<input accesskey="c" type="submit" name="BTCancelar" value="Limpar" >
</body>
</html>
[/code]

Meu INdex:
[code]
<%--
Document : index
Created on : 30/06/2008, 16:30:57
Author : patrick
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSTL Derby</title>
</head>
<body>
<c:catch var="ex">
<sql:transaction dataSource="${ds}">
<sql:update var="gravaCli">
INSERT INTO CLIENTES
(CODIGO,NOME,CPF,RG,TELEFONE,EMAIL,ESTADO)
VALUES (?,?,?,?,?,?,?)

<sql:param value="${param['edtCodigo']}"/>
<sql:param value="${param['edtNome']}"/>
<sql:param value="${param['edtCPF']}"/>
<sql:param value="${param['edtRG']}" />
<sql:param value="${param['edtTelefone']}"/>
<sql:param value="${param['edtEmail']}"/>
<sql:param value="${param['cmbEstados']}"/>

</sql:update>

</sql:transaction>

</c:catch>
<h1>
<c:out value="${ex}" default="Gravação executada com sucesso!"/>
</h1>

<hr>
<input type="button" value="Voltar" name="btVoltar"
onclick= " history.back();"
></body>
</html>
[/code]

Aguardo respostas

Muito Obrigado


]]> http://www.portaljava.com/forum/posts/preList/44613/164314.page http://www.portaljava.com/forum/posts/preList/44613/164314.page GMT