24/03/2009, 07:34
|
| | Fecha de Ingreso: febrero-2009
Mensajes: 8
Antigüedad: 15 años, 9 meses Puntos: 0 | |
Respuesta: Select sencilla Buenas!!
El problema está en: return rs.getLong("num_cuenta"); que no sé si en realidad se hace con el getLong o se usa otra funcion.
El fallo que me da es:
java.sql.SQLException: es.ccsc.exception.TitularException: java.sql.SQLException: Before start of result set
at es.ccsc.action.MovAction.execute(MovAction.java:45 )
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Caused by: es.ccsc.exception.TitularException: java.sql.SQLException: Before start of result set
at es.ccsc.impl.TitularDAOImpl.findNum_cuenta(Titular DAOImpl.java:378)
at es.ccsc.action.MovAction.execute(MovAction.java:43 )
... 20 more
Caused by: java.sql.SQLException: Before start of result set
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.jav a:700)
at com.mysql.jdbc.ResultSet.getNativeLong(ResultSet.j ava:7816)
at com.mysql.jdbc.ResultSet.getNativeLong(ResultSet.j ava:7811)
at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:27 09)
at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:27 24)
at org.apache.commons.dbcp.DelegatingResultSet.getLon g(DelegatingResultSet.java:240)
at es.ccsc.impl.TitularDAOImpl.findNum_cuenta(Titular DAOImpl.java:375)
... 21 more
Espero que me podais ayudar
Un Saludo |