File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Can we close the connection After getting the resultset..
Joined: Nov 06, 2003
Feb 10, 2005 11:52:00
My Question seems to be silly but I would like to know the answer.
Can we close the connection after getting the resultset if we have 1000's records.
If we close the connection what will be impact?
author & internet detective
Joined: May 26, 2003
Feb 10, 2005 17:48:00
No. You need to get the results before you close the connection. You can copy them to another data structure and do the processing afterwards though.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Can we close the connection After getting the resultset..
Does ResultSet close when connection closes?
whats the use of closing ResultSet ?
consuquences of not closing ResultSet?
ResultSet after DB closed
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015