0000997: receive exhausted result set errors when loading cmr data in amber

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000997

[Resin]

major

always

03-17-06 09:55

04-05-06 09:15

Reporter

nquery

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.0.19

Product Version

3.0.18

Product Build

Summary

0000997: receive exhausted result set errors when loading cmr data in amber

Description

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???

Steps To Reproduce

Additional Information

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)

Attached Files

Relationships

There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
03-17-06 09:55	nquery	New Issue
04-05-06 09:15	ferg	Assigned To	=> ferg
04-05-06 09:15	ferg	Status	new => closed
04-05-06 09:15	ferg	Resolution	open => fixed
04-05-06 09:15	ferg	Fixed in Version	=> 3.0.19

Mantis 1.0.0rc3[^]

27 total queries executed.
25 unique queries executed.