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
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.
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-2014