[Focus]

I am getting this message when I try to send a message on a site. Does anyone know what it is and how I fix it?500 Servlet Exception

java.sql.SQLException: Illegal operation on empty result set
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3619)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1763)
at _parcelfeedback__jsp._jspService(/parcelfeedback.jsp:292)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)

Resin 2.1.14 (built Thu Jul 1 18:39:55 PDT 2004)

[Advertisements]

Hi Focus,

My best guess is that the app does an sql querry on a data base that returns zero results. Then the app tries to access something in the results without checking to see if there were actually any valid results. The fix would be to check the results after the querry to see if anything was actually returned before trying to operate on them.

Hope that helps,
Ricci

[ricci]

Hi Focus,

My best guess is that the app does an sql querry on a data base that returns zero results. Then the app tries to access something in the results without checking to see if there were actually any valid results. The fix would be to check the results after the querry to see if anything was actually returned before trying to operate on them.

Hope that helps,
Ricci