Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Result Set is getting close in 12 Min

772846May 13 2010 — edited May 14 2010

Hi,

I am facing one issue here with the JDBC.

I am doing a query to the oracle db , where I have more the 80K records in our one of table. Once I recieved the data in resultset. I am iterating them in batch of length 1024 from the result set. But I am able to do only 5 Iteration and result set getting connection closed SQLException in 12 Min. Here is the stack trace.
--------------------------------------------------------------------------------------------------------------------
Caused by: java.sql.SQLException: Closed Connection: next
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:181)-
--------------------------------------------------------------------------------------------------------------------

I have seen that result set has all the records.

Can you please help me here is that any time can mentioned in resultSet.

Thanks,
Mukesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2010

Added on May 13 2010

#general-database-discussions

4 comments

1,002 views