Forums Register Login

java.sql.SQLException: Connection handle has been closed and is unusable

+Pie Number of slices to send: Send

Hi,

I am facing Connection handle has been closed and is unusable Exception in java application. We are using oracle connection pool to connect to the database. Please anyone help where is the problem. Below is the jboss log trace :

2011-09-28 10:49:12,729 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: java.sql.SQLException: Connection handle has been closed and is unusable
2011-09-28 10:49:12,729 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
2011-09-28 10:49:12,729 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:570)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:182)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.insertRecord(Unknown Source)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutRequest(Unknown Source)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-28 10:49:12,730 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-09-28 10:49:12,730 ERROR [OSSBSS_ADAPTER] 8000|13974671|SQL Exception occurred in insertRecord mehtod

2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.insertRecord(Unknown Source)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutRequest(Unknown Source)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-09-28 10:49:12,731 ERROR [OSSBSS_ADAPTER] 1060|13974671|OSSBSSDBException occurred for Txn Id 13974671 : - Connection handle has been closed and is unusable
2011-09-28 10:49:12,731 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Connection handle has been closed and is unusable

2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.insertRecord(Unknown Source)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutRequest(Unknown Source)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-28 10:49:12,732 ERROR [STDERR] Sep 28, 2011 10:49:12 AM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)

Thanks & Regards,
Jay
It's a tiny ad only because the water is so cold.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 3795 times.
Similar Threads
java.sql.SQLException: Closed Resultset: next
Closed Statement
Cannot access entity bean deployed in different machine
java.sql.SQLException: Connection handle has been closed and is unusable
Closing a statement you left open, please do your own housekeeping
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 06:31:21.