This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
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
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 72
posted private message
0
Quote

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
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: java.sql.SQLException: Connection handle has been closed and is unusable
 
Similar Threads
java.sql.SQLException: Closed Resultset: next
Cannot access entity bean deployed in different machine
Closed Statement
java.sql.SQLException: Connection handle has been closed and is unusable
Closing a statement you left open, please do your own housekeeping