This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Cascading object close() statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cascading object close() statements" Watch "Cascading object close() statements" New topic
Author

Cascading object close() statements

Andrew Sweeney
Greenhorn

Joined: Jan 11, 2002
Posts: 26
HEllo all,
I'm interested in knowing the order in which JDBC objects are cascaded when closed. My understanding is that when a Connection object is closed, the underlying Statement objects and ResultSet objects are also closed. Is this always the case? Thanks!
Mahesh Mamani
Ranch Hand

Joined: Jun 25, 2001
Posts: 110
Hi,
When we close a Statement object, the associated ResultSet object is closed automatically. The Connection object will have to be closed explicitly. Here's an extract from the Java API :
"A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results."
Hope it helps.

Mahesh
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Cascading object close() statements
 
Similar Threads
Open Connection Objects
Question regarding Hibernate Lazy Loading
How to not open a named regular window if it already exisits
ResultSet question
How to know if any of the CMP fileds are modified ?