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!
posted 15 years ago
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.