Forums Register Login

JDBC result set question

+Pie Number of slices to send: Send
I Executed a query and it has 10000 records. After processing for 9990 records, i closed my connection object and i got an exception immediately
can not access the ResultSet object anymore.

Is there any JDBC API still using which i can retrieve all the records 10000 records though the connection is closed at 9990.

Thanks,
Raj
+Pie Number of slices to send: Send
Raj,
I'm confused. Why are you closing the connection if you aren't done with the data? You could use a cached result set, but it seems better to just get the rest of the data before closing the connection.
+Pie Number of slices to send: Send
Hello Raj

Yes you have an option; if you closed the connection also. I know that by using the rowset it is possible
It would give a normal human mental abilities to rival mine. To think it is just a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 827 times.
Similar Threads
Error while indexing a post: java.sql.SQLException: The statement is closed.
Best way to insert 10000 rows in JDBC
Cascading object close() statements
is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?
Question about ejbActivate and ejbPassivate
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:59:16.