1 Reply Latest reply: Aug 23, 2012 11:19 AM by Bernhard Anzeletti RSS

Connection handle has been closed and is unusable

ujwallshetty Newbie

Hello,

 

  In my code i am facing problem with Connection when trying insert/update database. I have pasted the jboss server logs. Any help would be appreciated in resolvving this issue. Please let me know if more info is req. on this issue.

 

2011-06-16 23:40:11,493 INFO  [MPG_SIG] 8000|7240413|OSSBSSInsertRecordDAO::Query=SELECT STATUS_CHANGE from LOOP_MPG_OSSBSSGW_PORT_ORDERS WHERE MSISDN='9819868688' AND NP_TXN_ID='7240413'

2011-06-16 23:40:11,493 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]: java.sql.SQLException: Connection handle has been closed and is unusable

2011-06-16 23:40:11,493 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)

2011-06-16 23:40:11,493 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)

2011-06-16 23:40:11,493 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at org.jboss.resource.adapter.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:570)

2011-06-16 23:40:11,493 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:167)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updateRecord(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortCompleteNotification(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.modules.LNPDBWebServiceModule.invoke(LNPDBWebServiceModule.java:184)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:312)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:830)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1349)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)

2011-06-16 23:40:11,494 ERROR [MPG_SIG] 8000|7240413|SQL Exception occurred in updateRecord mehtod

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updateRecord(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortCompleteNotification(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)

2011-06-16 23:40:11,494 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.modules.LNPDBWebServiceModule.invoke(LNPDBWebServiceModule.java:184)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:312)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:830)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1349)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)

2011-06-16 23:40:11,495 ERROR [MPG_SIG] 1060|7240413|OSSBSSDBException occurred for Txn Id 7240413 : - Connection handle has been closed and is unusable

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updateRecord(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortCompleteNotification(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.modules.LNPDBWebServiceModule.invoke(LNPDBWebServiceModule.java:184)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:312)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:830)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1349)

2011-06-16 23:40:11,495 ERROR [STDERR] Jun 16, 2011 11:40:11 PM [Plug-in standard error]:       at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)

 

 

Thanks & Regards,

Uwall