Hi,
We have Application running on
JBoss with Oracle DB, We use connection pool for DB connection from our APP. I am getting "Closed Statement" Exception atleast 5 to 6 times in the whole day. I am closing the ResultSet,Prepared Statement, Statement, And Connection properly. Please Help Me how to solve this kind of Issue.
Here is the Complete jboss trace:
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: java.sql.SQLException: Closed Statement
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3986)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1451)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updatePortOutConfirmationReject(Unknown Source)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutConfirmation(Unknown Source)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-23 17:12:33,250 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-09-23 17:12:33,251 ERROR [MPG_SIG] 8000|13320624|SQL Exception occurred in updatePortOutConfirmation mehtod
2011-09-23 17:12:33,251 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Closed Statement
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updatePortOutConfirmationReject(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutConfirmation(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-09-23 17:12:33,252 ERROR [OSSBSS_ADAPTER] 1060|13320624|OSSBSSDBException occurred for Txn Id 13320624 : - Closed Statement
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: com.hp.mnp.ossbss.exception.OSSBSSDBException: Closed Statement
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.dao.OSSBSSAdapterInsertRecordDAO.updatePortOutConfirmationReject(Unknown Source)
2011-09-23 17:12:33,252 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.process.InsertPortOutMessages.ProcessPortOutConfirmation(Unknown Source)
2011-09-23 17:12:33,254 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.processGenericMessage(Unknown Source)
2011-09-23 17:12:33,254 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.mnp.ossbss.webservice.ProcessOSSBSSMessage.executeMessage(Unknown Source)
2011-09-23 17:12:33,254 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.sig.npwsimpl.HpnpOssBssAdapterServiceSkeleton.processRequest(Unknown Source)
2011-09-23 17:12:33,254 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.modules.SIGWebServiceModule.invoke(SIGWebServiceModule.java:202)
2011-09-23 17:12:33,255 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.np.mwfm.NPWebServiceNode.nodeEntered(NPWebServiceNode.java:264)
2011-09-23 17:12:33,256 INFO [STDOUT] Sep 23, 2011 5:12:33 PM [Plug-in standard output]: Enter Submit()
2011-09-23 17:12:33,256 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker._step1(WFMEngineWorker.java:849)
2011-09-23 17:12:33,257 INFO [STDOUT] Sep 23, 2011 5:12:33 PM [Plug-in standard output]: Submit request sent
2011-09-23 17:12:33,257 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker.access$300(WFMEngineWorker.java:107)
2011-09-23 17:12:33,257 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.WFMEngineWorker$8.run(WFMEngineWorker.java:1388)
2011-09-23 17:12:33,257 ERROR [STDERR] Sep 23, 2011 5:12:33 PM [Plug-in standard error]: at com.hp.ov.activator.mwfm.engine.EngineWorkerThread.run(EngineWorkerThread.java:90)
2011-09-23 17:12:33,257 DEBUG [MPG_SIG] 1060|1060|ProcessOSSBSSMessage : exit executeMessage method
Part of the Code where Exception is thrown :