#32 exception when try to delete principal

closed
maxi
None
5
2006-05-26
2006-05-26
maxi
No

In the list of principals screen when we try to delete
a principal raise following exception
net.sf.jguard.authentication.AuthenticationException:
java.sql.SQLException: Before start of result set
at
net.sf.jguard.authentication.JdbcAuthenticationManager.deletePrincipal(JdbcAuthenticationManager.java:1143)
at
net.sf.jguardexample.struts.admin.actions.PrincipalDispatchAction.delete(PrincipalDispatchAction.java:229)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:332)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:315)
at
org.apache.struts.actions.ActionDispatcher.execute(ActionDispatcher.java:220)
at
net.sf.jguardexample.struts.actions.BaseAction.execute(BaseAction.java:56)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
net.sf.jguard.authentication.http.AccessFilter.authorize(AccessFilter.java:672)
at
net.sf.jguard.authentication.http.AccessFilter.doFilter(AccessFilter.java:438)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Before start of
result set
at
com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3624)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1762)
at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:1339)
at
net.sf.jguard.authentication.JdbcAuthenticationManager.deletePrincipal(JdbcAuthenticationManager.java:1117)

Cheers
Maxi

Discussion

  • maxi

    maxi - 2006-05-26

    Logged In: YES
    user_id=1477381

    was missing a call to
    rs.next()

     
  • maxi

    maxi - 2006-05-26
    • status: open --> closed
     

Log in to post a comment.