[Erro]JSTL + Derby = Não conecta

0 respostas
K

Boa Dia a todos !

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

<%-- 
    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>
        &lt;form action="gravaCliente.jsp" method="post" /&gt;
        &lt;label&gt;Código&lt;/label&gt;<br>
        &lt;input type="text" name="edtCodigo" size="10"&gt;<br>
        &lt;label&gt;Nome :&lt;/label&gt;   
        &lt;input type="text" name="edtNome" size="60"&gt;<br>
        &lt;label&gt;CpF:&lt;/label&gt;<br>
        &lt;input type="text" name="edtcpf" size="10"&gt;<br>
        &lt;label&gt;RG:&lt;/label&gt;<br>
        &lt;input type="text" name="edtRG" size="15"&gt;<br>
        &lt;label&gt;Estado:&lt;/label&gt;
        &lt;sql:query var="qryEstados" dataSource="${ds}"&gt;
             select * from  ESTADOS
             ORDER BY NOME
         &lt;/sql:query&gt;
         
         &lt;select name="cmbEstados"&gt;
             &lt;c:forEach var="Estado" items="${qryEstados.row}"&gt;
                 &lt;option value="PA"&gt; ${Estado.nome} &lt;/option&gt;
                 
             &lt;/c:forEach&gt;
                       
         &lt;/select&gt;<br>
         
        &lt;label&gt;TELEFONE::&lt;/label&gt;<br>
        &lt;input type="text" name="edtTelefone" size="15"&gt;<br>
        &lt;label&gt;Email:&lt;/label&gt;<br>
        &lt;input type="text" name="edtEmail" size="15"&gt;<br>
        <hr>   
        
        &lt;input accesskey="o" type="submit" name="BTok" value="ok" &gt;
         &lt;input accesskey="c" type="submit" name="BTCancelar" value="Limpar" &gt;   
    &lt;/body&gt;
&lt;/html&gt;

Meu INdex:

&lt;%-- 
    Document   : index
    Created on : 30/06/2008, 16:30:57
    Author     : patrick
--%&gt;

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

&lt;html&gt;
    &lt;head&gt;
        &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;
        &lt;title&gt;JSTL Derby&lt;/title&gt;
    &lt;/head&gt;
    &lt;body&gt;
        &lt;c:catch var="ex"&gt;
            &lt;sql:transaction dataSource="${ds}"&gt;
                  &lt;sql:update var="gravaCli"&gt;
                      INSERT INTO CLIENTES 
                      (CODIGO,NOME,CPF,RG,TELEFONE,EMAIL,ESTADO)
                      VALUES (?,?,?,?,?,?,?)
                      
                      &lt;sql:param value="${param['edtCodigo']}"/&gt;
                      &lt;sql:param value="${param['edtNome']}"/&gt;
                      &lt;sql:param value="${param['edtCPF']}"/&gt;
                      &lt;sql:param value="${param['edtRG']}" /&gt;
                      &lt;sql:param value="${param['edtTelefone']}"/&gt;
                      &lt;sql:param value="${param['edtEmail']}"/&gt;
                      &lt;sql:param value="${param['cmbEstados']}"/&gt;
                                 
                    &lt;/sql:update&gt;
     
             &lt;/sql:transaction&gt;
         
         &lt;/c:catch&gt;
         &lt;h1&gt;
             &lt;c:out value="${ex}" default="Gravação executada com sucesso!"/&gt;
         &lt;/h1&gt;
         
         <hr>
             &lt;input type="button" value="Voltar" name="btVoltar" 
               onclick=  " history.back();" 
    &gt;&lt;/body&gt;
&lt;/html&gt;

Aguardo respostas

Muito Obrigado

Criado 4 de julho de 2008
Respostas 0
Participantes 1