File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Soft Skills this week in the Jobs Discussion forum!
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
 
jQuery in Action, 2nd edition
 
subject: java.sql.SQLException: Connection handle has been closed and is unusable