Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes java.sql.SQLException: Connection handle has been closed and is unusable Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Connection handle has been closed and is unusable" Watch "java.sql.SQLException: Connection handle has been closed and is unusable" New topic
Author

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

jaya kemmannu
Ranch Hand

Joined: Sep 23, 2011
Posts: 85

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 is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: Connection handle has been closed and is unusable