Encounter "Closed Statement"

[Chong Yoke Ping <ch...@yahoo.com>]

Hi all, 

     I kept encountering this problem java.sql.SQLException: Closed Statement in our OJB program. The OJB version I am using is 0.9.7 and type is PersistenceBroker. 

     Did anybody encounter this similar problems? Can somebody please enlighten me why this would happen? I am not sure if the above information is enough for everyone to understand my problem. If not, please feel free to ask for more information. Attached is more detail of the exception. Thanks. 

Regards, 

Yoke Ping 

 

Closed Statement java.sql.SQLException: Closed Statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source) at org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQueryExtentAware(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollection(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollections(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getExtentDBObject(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Unknown Source) at org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getObjectByIdentity(Unknown Source) at org.apache.ojb.broker.accesslayer.IndirectionHandler.materializeSubject(Unknown Source) at org.apache.ojb.broker.accesslayer.IndirectionHandler.getRealSubject(Unknown Source) at org.apache.ojb.broker.accesslayer.IndirectionHandler.invoke(Unknown Source) at $Proxy13.getAlumN(Unknown Source) at jsp.APPS.dms.member.update_personal._jspService(update_personal.java:264) at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown Source) at com.netscape.server.servlet.servletrunner.ServletRunner.callJSP(Unknown Source) at com.netscape.server.servlet.platformhttp.PlatformHttpServletResponse.callJspCompiler(Unknown Source) at com.netscape.server.servlet.platformhttp.PlatformHttpServletResponse.callUri(Unknown Source) at com.netscape.server.servlet.platformhttp.PlatformHttpServletResponse.callUriRestrictOutput(Unknown Source) at com.netscape.server.servlet.platformhttp.PlatformRequestDispatcher.forward(Unknown Source) at com.acr.web.servlet.BaseServlet.forward(BaseServlet.java:114) at com.acr.web.servlet.member.indv.LoadIndividualMemberServlet.doPost(LoadIndividualMemberServlet.java:488) at com.acr.web.servlet.member.indv.LoadIndividualMemberServlet.doGet(LoadIndividualMemberServlet.java:494) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.netscape.server.servlet.servletrunner.ServletInfo.service(Unknown Source) at com.netscape.server.servlet.servletrunner.ServletRunner.execute(Unknown Source) at com.kivasoft.applogic.AppLogic.execute(Unknown Source) at com.kivasoft.applogic.AppLogic.execute(Unknown Source) at com.kivasoft.thread.ThreadBasic.run(Native Method) at java.lang.Thread.run(Thread.java:484) [org.apache.ojb.broker.accesslayer.IndirectionHandler] ERROR: Method invoking failed for method *getAlumN* on object null



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.