JSP + Servlets + netbeans + access = não estou entendendo onde está o erro?

Pessoal gostaria de saber se alguem pode me ajudar pois não endendo esse error abaixo colocarei as telas e o erro

Arquivo1 ---- index.jsp ----

<%@page contentType=“text/html” pageEncoding=“UTF-8”%>

index lado cliente

Clique no botÃ£o para visualizar o cadastro de funcionários

Arquivo2 ---------servletcadastro.java – -------------

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.sql.*;

import javax.servlet.RequestDispatcher;

public class servletcadastro extends HttpServlet {

<a class="mention" href="/u/override">@Override</a>

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

try {

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Connection con = DriverManager.getConnection (“jdbc:odbc:driver={Microsoft Access Driver (<em>.mdb)};dbq=c:/cadempresa.mdb");

//String bd="jdbc:odbc:Driver={Microsoft Access Driver (</em>.mdb)};dbq=c:/cadempresa.mdb”;

//Connection con =DriverManager.getConnection(bd);
          //Statement ins=con.createStatement();
          Statement ins = con.createStatement();
          ResultSet rs = ins.executeQuery("SELECT * FROM funcionario");
          //ResultSet rs=ins.executeQuery("Select * from funcionario");
          request.setAttribute("consulta",rs);

          RequestDispatcher rd=request.getRequestDispatcher("listafuncionario.jsp");
                rd.forward(request,response);
                ins.close();
                con.close();
        } //fim do try


   catch (Exception e) {
       e.printStackTrace();
        }
}

}

arquivo3 - - – - – - listafuncionario.jsp---------

<%@page contentType=“text/html” %>
<%@page import=“java.sql.*”%>

<title>lado servidor </title>
</head>
<body>
    <table border="1" width="80%">
    Cadastro de funcionario
    <tr><td><b>nome </b></td>
    <td><b>sobrenome </b></td>
    <td><b>salario </b></td></tr>

    <%ResultSet rs=(ResultSet)request.getAttribute("consulta");
     while(rs.next()); {%>
     <tr><td>
         <%=rs.getString("nome")%></td><td>
         <%=rs.getString("sobrenome")%></td><td>
         <%=rs.getDouble("salario")%></td></tr>
             <%}%>
          </table>

</body>

Como dito estou usando: jdk-6u4-windows-i586-p, netbeans-6.5-ml-windows.

O erro que aparece é esse descrito abaixo:

No log do apache:12/08/2009 19:18:56 org.apache.catalina.core.ApplicationDispatcher invoke

SEVERE: Servlet.service() for servlet jsp threw exception

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Estado de cursor inválido

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)

at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)

at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5698)

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354)

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:411)

at org.apache.jsp.listafuncionario_jsp._jspService(listafuncionario_jsp.java:78)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.

No apcha parece isso.
INFO: Container org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/projetoPOO] has already been started
org.apache.jasper.JasperException: An exception occurred processing JSP page /listafuncionario.jsp at line 26

23:         <%ResultSet rs=(ResultSet)request.getAttribute(“consulta”);

24:          while(rs.next()); {%>

25:

26: <%=rs.getString(“nome”)%>
27: <%=rs.getString(“sobrenome”)%>
28: <%=rs.getDouble(“salario”)%>
29: <%}%>

Stacktrace:

at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

at servletcadastro.doGet(servletcadastro.java:32)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter

Grato por qualquer ajuda!!!

Clique no botÃ£o para visualizar o cadastro de funcionários

Topicos relacionados