MQSeries.net :: View topic - JDBC adapter getting statement is closed error

mqseries123

Hi All,

We are using the JDBC adapter which connects to a remote DB2 database. The adapter performs both read and write operation on the database. We are phasing the following problem very frequently, when the adapter tries to retrieve the database entry :

com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type: Error] [MsgID: 37000] [Mesg: A SQL Exception COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000 occurred]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.java:1568)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOHandler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2179)
at com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor(CWConnectorBusObj.java:126)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConnectorAgent.java:1299)
at AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:584)
at AppSide_Connector.AppCalls.poll(AppCalls.java:192)
at AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObjectManager.java:717)
at AppSide_Connector.AppPolling.poll(AppPolling.java:310)

The adapter runs on the Windows 2000 server. Adapter framework version is 2.6.0.5. The JDBC adapter version is 2.8.0.
Can anyone help us ?