A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
Is there any
API still using which i can retrieve all the records 10000 records though the connection is closed at 9990.
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.
How To Ask Questions The Smart Way
Blogging on Certs:
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
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: JDBC result set question
Error while indexing a post: java.sql.SQLException: The statement is closed.
is there a limit on the number of records returned by queryForList method of SqlMapClientTemplate?
Cascading object close() statements
Question about ejbActivate and ejbPassivate
Best way to insert 10000 rows in JDBC
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014