JDBC result set from an Oracle PL/SQL stored procedure
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Lalitha_Rani
Posted On:   Friday, September 17, 2010 11:15 AM

Could you please let us know the difference between oracleClose() and oracleCloseQuery() in sqlj.runtime.ExecutionContext.OracleContext. Since we upgraded jdbc driver jar to ojdbc5.jar with the oracleClose() in the finally block we get the below exception when using resultset.next()and not with oracleCloseQuery(). Is it safe to use oracleCloseQuery(). The database is Oracle 11g and WAS 6.1.X.X. Here is the error message : java.sql.SQLException: Closed Statement: next at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)    More>>

Could you please let us know the difference between oracleClose() and oracleCloseQuery() in sqlj.runtime.ExecutionContext.OracleContext. Since we upgraded jdbc driver jar to ojdbc5.jar with the oracleClose() in the finally block we get the below exception when using resultset.next()and not with oracleCloseQuery(). Is it safe to use oracleCloseQuery(). The database is Oracle 11g and WAS 6.1.X.X. Here is the error message :



java.sql.SQLException: Closed Statement: next

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)

at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:205)

at com.westgroup.pubsvc.rms.models.ResultSetSRC.getNextResult(ResultSetSRC.java:112)

   <<Less
About | Sitemap | Contact