• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Closed Statement

 
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 :



 
Yeah, but how did the squirrel get in there? Was it because of the tiny ad?
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic