Closing ResultSet in Java 7

Question

The following site shows using the new "AutoClosable" features with JDBC: link. This site is showing how the Statement will be automatically closed, but the result set is not in the try() section where it would be auto-closed. So, my question is, do I NOT need to close ResultSets directly in Java 7? I have always used the pattern: close resultset, close statement, close connection.

https://docs.oracle.com/javase/tutorial/essential/exceptions/tryResourceClose.html — Kanagavelu Sugumar, May 11 '16 at 16:38

score 15 · Accepted Answer · edited Jul 12 '12 at 18:34

15

From the Javadoc of ResultSet:

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.

edited Jul 12 '12 at 18:34

Mark Rotteveel

100,966
191
140
197

answered Jul 12 '12 at 15:21

Durandal

19,919
4
36
70

thanks, I don't know how I missed that. – Rocky Pulley Jul 12 '12 at 15:28
1

BTW: ResultSets are also `AutoCloseable`, so there is nothing keeping you from using try-with-resources to close the resultset as soon as possible. – Mark Rotteveel Jul 12 '12 at 18:32

Closing ResultSet in Java 7

1 Answers1

Linked

Related