I have set the prepared statement ResultSet.HOLD_CURSORS_OVER_COMMIT and the same thing working on one instace of DB2 and not working on other instance of DB2. what could be the problem?
com.ibm.db2.jcc.b.nn: [jcc][t4][20122][11341][3.52.110] Error invalid lob object. See attached Throwable for details. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.b.ad.a(ad.java:676)
at com.ibm.db2.jcc.b.ad.a(ad.java:60)
at com.ibm.db2.jcc.b.ad.a(ad.java:112)
at com.ibm.db2.jcc.t4.jb.a(jb.java:1239)
at com.ibm.db2.jcc.t4.jb.a(jb.java:1178)
at com.ibm.db2.jcc.t4.jb.a(jb.java:1121)
at com.ibm.db2.jcc.t4.jb.b(jb.java:876)
at com.ibm.db2.jcc.t4.jb.a(jb.java:193)
at com.ibm.db2.jcc.t4.tb.a(tb.java:170)
at com.ibm.db2.jcc.b.sl.a(sl.java:2394)
at com.ibm.db2.jcc.b.sl.a(sl.java:3753)
at com.ibm.db2.jcc.b.sl.a(sl.java:3607)
at com.ibm.db2.jcc.b.sl.b(sl.java:3486)
at com.ibm.db2.jcc.b.sl.executeBatch(sl.java:1994)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. pmiExecuteBatch(WSJdbcPreparedStatement.java:957)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeB atch(WSJdbcStatement.java:702)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.executeBatch(CommonTenantConfig.java:13 32)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.processCopy(CommonTenantConfig.java:110 5)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.processCopy(CommonTenantConfig.java:854 )
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.preProcessCopy(CommonTenantConfig.java: 617)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.processTableCopy(CommonTenantConfig.jav a:601)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.processCopyXML(CommonTenantConfig.java: 525)
at com.fairisaac.edm.cc.tenantconfig.plugins.CommonTe nantConfig.copy(CommonTenantConfig.java:270)
at com.fairisaac.edm.cc.tenantconfig.TenantConfigCont roller.service(TenantConfigController.java:214)
at com.fairisaac.edm.cc.tenant.ejb.TenantServiceBean. onMessage(TenantServiceBean.java:79)
at com.ibm.ejs.container.MessageEndpointHandler.invok eMdbMethod(MessageEndpointHandler.java:1092)
at com.ibm.ejs.container.MessageEndpointHandler.invok e(MessageEndpointHandler.java:777)
at $Proxy146.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvoke rImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.jav a:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dis patch(SibRaDispatcher.java:887)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessL istener$SibRaWork.run(SibRaSingleProcessListener.j ava:527)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java: 399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1527)
Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][10120][11936][3.52.110] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
at com.ibm.db2.jcc.b.ad.a(ad.java:660)
at com.ibm.db2.jcc.b.ad.a(ad.java:60)
at com.ibm.db2.jcc.b.ad.a(ad.java:94)
at com.ibm.db2.jcc.b.ae.d(ae.java:67)
at com.ibm.db2.jcc.t4.jb.a(jb.java:1233)
... 29 more</throwable>