• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
jaya kemmannu
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic