Does closing Connection automatically close statement and resultset?

java database database-connection prepared-statement
Srujan Kumar Gulla picture Srujan Kumar Gulla · Dec 24, 2012 · Viewed 23.8k times · Source

I know the safe pattern in Java is to close your ResultSet, Statement, and Connection in order in a finally block.

If you close connection and then try to close statement(doesnt throw exception). But if you try to call any method from statement an exception is thrown.

I was wondering does closing connection automatically close all the statement objects created out of that connection?

Update:
I am using DatabaseProductVersion: Oracle Database 11g Release 11.1.0.0.0
DriverName: Oracle JDBC driver
DriverVersion: 10.2.0.4.0

Answer

Evgeniy Dorofeev picture Evgeniy Dorofeev · Dec 24, 2012

Yes it does, Connection.close API says "Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released". The problem is that applications typically use database connection pools and these may simply return Connection to pool on Connection.close.

In any case, it's a good practice to always close ResultSet and Statement explicitly and not to rely on Connection.close.

Besides, it's not the best idea to work with JDBC directly. You can use Spring JDBC instead and forget about releasing resources problem.

Related questions

How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
Why do I need Transaction in Hibernate for read-only operations?

Why do I need Transaction in Hibernate for read-only operations? Does the following transaction put a lock in the DB? Example code to fetch from DB: Transaction tx = HibernateUtil.getCurrentSession().beginTransaction(); // why begin transaction? //readonly operation here tx.commit() // why …

Read More
JDBC Connection pooling using C3P0

Following is my helper class to get DB connection: I've used the C3P0 connection pooling as described here. public class DBConnection { private static DataSource dataSource; private static final String DRIVER_NAME; private static final String URL; private static final …

Read More