SqlException: Invalid cursor name when running EJB timer service
 Technote (troubleshooting)
 
Problem(Abstract)
When configured to use the Cloudscape NetworkServer, the scheduler and EJB™ timer service logs errors each time the scheduler daemon polls the database. However, both the scheduler and EJB timer service continue to function.
 
Cause
The DB2® universal driver, which is what the Cloudscape NetworkServer uses, does not support setting the cursorName to null.
This problem is fixed by eliminating the call in the first service pack of IBM® WebSphere® Application Server V6.0. This problem is also being fixed by DB2 under DB2 bug#62037.

The following is the exception that is logged:

WSJdbcConnect W   DSRA8650W: Error closing a JDBC child wrapper, com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@4d654d65
com.ibm.db2.jcc.b.SqlException: Invalid cursor name.
at com.ibm.db2.jcc.b.zc.setCursorName(zc.java:723)
at com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper.doStatementCleanup(CloudscapeDataStoreHelper.java:200)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.closeWrapper(WSJdbcPreparedStatement.java:323)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:126)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.closeChildWrappers(WSJdbcObject.java:162)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:125)
at com.ibm.ws.extensionhelper.db.impl.DatabaseHelperImpl.returnConnection(DatabaseHelperImpl.java:562)
at com.ibm.ws.scheduler.DBHelperImpl.returnConnection(DBHelperImpl.java:259)
at com.ibm.ws.scheduler.SchedulerDaemonImpl.poll(SchedulerDaemonImpl.java:722)
at com.ibm.ws.scheduler.SchedulerDaemonImpl.run(SchedulerDaemonImpl.java:449)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:620)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:216)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:152)
at java.lang.Thread.run(Thread.java:813)
 
 
Resolving the problem
This problem is fixed in WebSphere Application Server V5.1.1.2 , and in WebSphere Application Server V6.0.0.1 (for example, the first service pack of V6).
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > EJB Container
Operating system(s): Windows
Software version: 6.0
Software edition:
Reference #: 1190990
IBM Group: Software Group
Modified date: Dec 9, 2004