Skip to Main Content

Java Database Connectivity (JDBC)

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!

Returning large resultset problems

843859Jul 26 2007 — edited Jul 26 2007
I've got a problem returning a large resultset (approx 1.2-1.5 million rows), in that sometimes the query doesn't run to completion because either I'm pretty sure the client keels over, dies, you get the picture. I've used
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
	              java.sql.ResultSet.CONCUR_READ_ONLY);

stmt.setFetchSize(Integer.MIN_VALUE);	
to try and stream the resultset but I'm not sure if it is. If not, could anyone suggest how I perform such an operation, or else suggest a way to deal with such a large set of results.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2007
Added on Jul 26 2007
1 comment
134 views