|
Re: Exception Description: DatabaseAccessor not connected. [message #759606 is a reply to message #759590] |
Tue, 29 November 2011 10:35 |
Ronny Messages: 7 Registered: October 2011 |
Junior Member |
|
|
I just changed max connection to 1, I got the error immediately. How do I use CursoredStream but avoid EclipseLink close the connection?
Thanks in advance
[EL Finer]: 2011-11-29 18:08:47.961--UnitOfWork(1039701893)--begin unit of work flush
[EL Finer]: 2011-11-29 18:08:47.961--UnitOfWork(1039701893)--end unit of work flush
[EL Finest]: 2011-11-29 18:08:47.962--UnitOfWork(1039701893)--Execute query ReadAllQuery(name="db_sett_open_dangling_cur" referenceClass=SysEventTT )
[EL Fine]: 2011-11-29 18:08:47.963--ClientSession(570824606)--Connection(17649447)--CALL db_sett_open_dangling_cur(?)
bind => [1 parameter bound]
[EL Finest]: 2011-11-29 18:08:47.981--ServerSession(1208495415)--Connection(17649447)--Connection released to connection pool [read].
[EL Config]: 2011-11-29 18:08:47.981--ServerSession(1208495415)--Connection(17649447)--disconnect
[EL Finest]: 2011-11-29 18:08:47.989--ServerSession(1208495415)--Connection(17649447)--Connection released to connection pool [read].
[EL Config]: 2011-11-29 18:08:47.989--ServerSession(1208495415)--Connection(17649447)--disconnect
[EL Warning]: 2011-11-29 18:08:47.989--UnitOfWork(1039701893)--Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10251][10308][4.3.111] java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
Error Code: -4471
Query: ReadAllQuery(name="db_sett_open_dangling_cur" referenceClass=SysEventTT )
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:475)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.disconnect(DatasourceAccessor.java:481)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.disconnect(DatabaseAccessor.java:485)
at org.eclipse.persistence.sessions.server.ConnectionPool.releaseConnection(ConnectionPool.java:344)
at org.eclipse.persistence.sessions.server.ServerSession.releaseReadConnection(ServerSession.java:831)
at org.eclipse.persistence.sessions.server.ClientSession.releaseReadConnection(ClientSession.java:782)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.releaseReadConnection(UnitOfWorkImpl.java:5634)
at org.eclipse.persistence.queries.Cursor.close(Cursor.java:124)
at org.eclipse.persistence.queries.CursoredStream.retrieveNextObject(CursoredStream.java:410)
at org.eclipse.persistence.queries.CursoredStream.setLimits(CursoredStream.java:462)
at org.eclipse.persistence.queries.CursoredStream.<init>(CursoredStream.java:58)
at org.eclipse.persistence.queries.CursoredStreamPolicy.execute(CursoredStreamPolicy.java:67)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:406)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1097)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:829)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1056)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:390)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1144)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2863)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1501)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1483)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1457)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:485)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:773)
[Updated on: Tue, 29 November 2011 10:36] Report message to a moderator
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04554 seconds