A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
JDBC result set question
Joined: Jan 25, 2006
Dec 10, 2007 16:42:00
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
API still using which i can retrieve all the records 10000 records though the connection is closed at 9990.
author & internet detective
Joined: May 26, 2003
Dec 10, 2007 19:21:00
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.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Dec 12, 2007
Dec 13, 2007 01:15:00
Yes you have an option; if you closed the connection also. I know that by using the rowset it is possible
Have a Good Day........<br />Sajj Bala Subrahmanyam
I agree. Here's the link:
subject: JDBC result set question
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015