Closing Connection object once I got my required ResultSet

Question

Would there be any effect if I close my Connection object once I got my ResultSet?

Connection con= DriverManager.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(query);
con.close();

Further to this I use my rs object and I feel there will not be any impact on it. Because ResultSet and Statement are in connection with each other.

Answer 1

You can't access the resultset soon after you close the connection to the database. Because, when you use resultset.next() method, it will send a request to the database in order to fetch the next record; but physically the connection has been closed. So, an Exception will be thrown by your statement resultset.next().

Answer 2

Once the Connection is closed other resources (Statements or ResultSets) must not be used.