PessoALL, Estou fazendo uma página jsp que lê alguns dados do banco de dados. Quando eu uso o método get para recuperar uma informação repetida me retorna um erro 'No data found'. Alguém sabe porque ? Segue um códi…

Recuperar dados no BD

<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*"%> <% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:TESTE", "", ""); Statement vStatement = con.createStatement(); String vsInstrucao = "SELECT ID_COMPROMISSO, COMPROMISSO FROM TB_COMPROMISSOS"; ResultSet rsResultSet = vStatement.executeQuery(vsInstrucao); while ( rsResultSet.next() ) { out.println("<br>Parametro 1: " + rsResultSet.getInt("ID_COMPROMISSO")); out.println("<br>Parametro 1: " + rsResultSet.getInt("ID_COMPROMISSO")); } } catch (Exception E) { out.println("<br><br> Erro: " + E.getMessage()); } %>

4 Respostas

matheusPJ 8 de jun. de 2005

posta pra gente a exception

clenioPJ 8 de jun. de 2005

Quando executo retorna o seguinte

Parametro 1&#58; 1 

Erro&#58; No data found

matheusPJ 8 de jun. de 2005

da um printStackTrace() no teu catch e posta a exception completa :yhum:

clenioPJ 9 de jun. de 2005

Segue a exception:

java.sql.SQLException&#58; No data found
        at sun.jdbc.odbc.JdbcOdbc.standardError&#40;JdbcOdbc.java&#58;7139&#41;
        at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger&#40;JdbcOdbc.java&#58;3812&#41;
        at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger&#40;JdbcOdbcResultSet.java&#58;5639&#41;
        at sun.jdbc.odbc.JdbcOdbcResultSet.getInt&#40;JdbcOdbcResultSet.java&#58;582&#41;
        at sun.jdbc.odbc.JdbcOdbcResultSet.getInt&#40;JdbcOdbcResultSet.java&#58;600&#41;
        at org.apache.jsp.testejdbc_jsp._jspService&#40;testejdbc_jsp.java&#58;56&#41;
        at org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;99&#41;
        at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
        at org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;325&#41;
        at org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;295&#41;
        at org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;245&#41;
        at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;252&#41;
        at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;173&#41;
        at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter&#40;MonitorFilter.java&#58;362&#41;
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;202&#41;
        at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;173&#41;
        at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;214&#41;
        at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;178&#41;
        at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;126&#41;
        at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;105&#41;
        at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;107&#41;
        at org.apache.catalina.connector.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;148&#41;
        at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;825&#41;
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;738&#41;
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket&#40;PoolTcpEndpoint.java&#58;526&#41;
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt&#40;LeaderFollowerWorkerThread.java&#58;80&#41;
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;684&#41;
        at java.lang.Thread.run&#40;Thread.java&#58;595&#41;

4 Respostas

Topicos relacionados