Hello
We are getting SQLException like java.sql.SQLException: Connection handle has been closed and is unusable. We have Oracle 10g and using oracle_jdbc.jar and
jboss 4.2.2 version.
I have attached complete stack trace,
Java code where the exception is thrown and my ds file
2011-11-21 13:04:54,839 INFO [OSSBSS_ADAPTER] 8000|17680582|GenPortInAck : OSSBSSAdapterInsertPortInMessageDAO : The update DB status : 1
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: java.sql.SQLException: Connection handle has been closed and is unusable
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertPortInMessageDAO.updateGenPortInAck(OSSBSSAdapterInsertPortInMessageDAO.java:219)
2011-11-21 13:04:54,839 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortInAck(InsertPortInMessages.java:248)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(ProcessOSSBSSMessage.java:229)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(HpnpOssBssAdapterServiceSkeleton.java:143)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-11-21 13:04:54,840 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-11-21 13:04:54,840 ERROR [OSSBSS_ADAPTER] 8000|17680582|GenPortInAck : OSSBSSAdapterInsertPortInMessageDAO : SQL Exception occurred in updateGenPortInAck mehtod
2011-11-21 13:04:54,840 WARN [org.jboss.resource.adapter.jdbc.WrappedConnection] Closing a statement you left open, please do your own housekeeping
2011-11-21 13:04:54,841 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Unregistered handle that was not registered! org.jboss.resource.adapter.jdbc.WrappedConnection@5df9c75f for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@64f1161d
2011-11-21 13:04:54,843 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertPortInMessageDAO.updateGenPortInAck(OSSBSSAdapterInsertPortInMessageDAO.java:321)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortInAck(InsertPortInMessages.java:248)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(ProcessOSSBSSMessage.java:313)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(ProcessOSSBSSMessage.java:229)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(HpnpOssBssAdapterServiceSkeleton.java:143)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-11-21 13:04:54,844 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-11-21 13:04:54,844 ERROR [OSSBSS_ADAPTER] 1060|17680582|GenPortInAck : InsertPortInMessages : OSSBSSDBException occurred for Txn Id 17680582 : - Connection handle has been closed and is unusable
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertPortInMessageDAO.updateGenPortInAck(OSSBSSAdapterInsertPortInMessageDAO.java:321)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortInMessages.ProcessPortInAck(InsertPortInMessages.java:248)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(ProcessOSSBSSMessage.java:313)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(ProcessOSSBSSMessage.java:229)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(HpnpOssBssAdapterServiceSkeleton.java:143)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-11-21 13:04:54,845 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-11-21 13:04:54,846 ERROR [STDERR] Nov 21, 2011 1:04:54 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-11-21 13:04:54,846 DEBUG [OSSBSS_ADAPTER] 1060|1060|ProcessOSSBSSMessage : exit executeMessage method
Method Where Exception is thrown :
ds file :
Any guidance on fixing this would really help .
thanks & Regards,
Jaya