Mantis - Resin
Viewing Issue Advanced Details
997 major always 03-17-06 09:55 04-05-06 09:15
nquery  
ferg  
normal  
closed 3.0.18  
fixed  
none    
none 3.0.19  
0000997: receive exhausted result set errors when loading cmr data in amber
this error occurs consistently in resin 3.0.x, but does not occur in resin 2. it might be related to the connection bug that i am submitting at the same time - eg. if the connection was closed by mistake then this might generate this error???
com.caucho.amber.AmberRuntimeException: java.sql.SQLException: Exhausted Resultset
        at com.caucho.amber.collection.CollectionImpl.fill(CollectionImpl.java:168)
        at com.caucho.amber.collection.CollectionImpl.size(CollectionImpl.java:109)
        at java.util.ArrayList.<init>(ArrayList.java:133)
        at _ejb.companies.CompanyBean__EJB$Local.getMemberships(CompanyBean__EJB.java:1773)
        at com.quotemedia.quotetools.helper.CompaniesAccessObject.getCompanyProfile(CompaniesAccessObject.java:111)
        at com.quotemedia.quotetools.control.GetCompanyQuotesAction.execute(GetCompanyQuotesAction.java:60)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:115)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
        at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
        at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:115)
        at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
        at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:481)
        at com.caucho.server.webapp.RequestDispatcherImpl.include(RequestDispatcherImpl.java:346)
        at com.quotemedia.quotetools.control.RedirectXMLServlet.doPost(RedirectXMLServlet.java:106)
        at com.quotemedia.quotetools.control.RedirectXMLServlet.doGet(RedirectXMLServlet.java:54)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:115)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
        at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
        at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:218)
        at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
        at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
        at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
        at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
        at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
        at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
        at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Exhausted Resultset
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
        at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:347)
        at _ejb.indexgroups.IndexGroupBean__Amber.__caucho_home_find(IndexGroupBean__Amber.java:686)
        at com.caucho.amber.entity.AmberEntityHome.findItem(AmberEntityHome.java:228)
        at com.caucho.amber.query.LoadEntityExpr.findItem(LoadEntityExpr.java:215)
        at com.caucho.amber.query.LoadEntityExpr.getCacheObject(LoadEntityExpr.java:204)
        at com.caucho.amber.query.ResultSetImpl.fillCacheChunk(ResultSetImpl.java:178)
        at com.caucho.amber.query.UserQuery.executeQuery(UserQuery.java:327)
        at com.caucho.amber.query.UserQuery.list(UserQuery.java:461)
        at com.caucho.amber.collection.CollectionImpl.fill(CollectionImpl.java:166)

There are no notes attached to this issue.