1 Reply Latest reply on Aug 23, 2012 11:19 AM by banzeletti

    Connection handle has been closed and is unusable

    ujwallshetty

      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

        • 1. Re: Connection handle has been closed and is unusable
          banzeletti

          A quick "guess into the blue": Are you using MySQL? There used to be a jdbc-Connector for MySQL that was famous for this kind of behaviour; It could (hopefully) be circumvented by passing reconnect=true as a connection parameter. But this is just a possible "quickfix", there could be many other reasons for this...