Result set already closed exception if I execute commit on the AMImpl class
727812Mar 17 2010 — edited Mar 17 2010Hi,
I have created one view object and dragged the view object to the .jspx page. I have to update one of the attribtues (status) of the view object and commit the data before displaying the page.
I have created one method in backing bean and called the method in the backing bean's constructor. This method calls one method on the application module and performs the query and updates the attribute.
If I do not execute getDBTransaction().commit() the form is loading with out any problems. But I have to commit the data to the database. If I execute the commit operation, I am getting the following exception.
The root cause of the exception is: "Caused By: java.sql.SQLException: Result set already closed". Can you please suggest.
Thanks,
Prasad
<Mar 17, 2010 12:39:06 PM EDT> <Error> <HTTP> <BEA-101020> <[ServletContext@12508271[app:MedServiceWorkspace module:MPMENU path:/MPMENU spec-version:2.5]] Servlet failed with Exception
oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 1 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2327)
at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:3618)
at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:2108)
at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:5174)
at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:5023)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLException: Result set already closed
at weblogic.jdbc.wrapper.ResultSet.checkResultSet(ResultSet.java:110)
at weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(ResultSet.java:65)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getString(Unknown Source)
at oracle.jbo.common.StringTypeSQLNativeImpl.getDataFromResultSet(JboTypeMapEntries.java:480)
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2318)
Truncated. see log file for complete stacktrace
Edited by: userpch1234 on Mar 17, 2010 9:47 AM