Statement, ResultSet

[Manuel Paco]

Do I have to close both Statement and ResultSet
or closing Statement will do?

[Sam Moran]

The reading that I have done on Sun's website shows only closing the connection:

 
Connection con = DriverManager.getConnection(url);
   Get data
con.close();

I hope this helps!

[Thomas Hubschman]

Manuel,
The API reads as follows:

java.sql
public interface ResultSet

public void close() throws SQLException

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
Note: A ResultSet object is automatically closed by the Statement object that generated it when that Statement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet object is also automatically closed when it is garbage collected.
Throws:
SQLException - if a database access error occurs
[ December 07, 2002: Message edited by: Thomas Hubschman ]