Is it mandatory to close JDBC connections?

At the end of your JDBC program, it is required explicitly to close all the connections to the database to end each database session. However, if you forget, Java's garbage collector will close the connection when it cleans up stale objects.

Relying on the garbage collection, especially in database programming, is a very poor programming practice. You should make a habit of always closing the connection with the close() method associated with connection object.

To ensure that a connection is closed, you could provide a 'finally' block in your code. A finally block always executes, regardless of an exception occurs or not.

To close a JDBC connection, you should call close() method as:

conn.close();

Krantik Chavan

Published on 20-Mar-2019 11:00:30

• Related Questions & Answers
• Is it mandatory to register the driver while working with JDBC?
• Is it mandatory to link my Aadhaar with bank account and mobile?
• Is it mandatory to override the default methods of an interface in Java?
• Is it mandatory to mark a functional interface with @FunctionalInterface annotation in Java?
• How to close the ResultSet cursor automatically, after commit in JDBC?
• How to close a Android notification after the user is clicking on it?
• Where we should close a connection in JDBC and MySQL?
• Is it mandatory to use T for type-parameter, while defining Generics classes/methods in Java?
• Mandatory and optional Participation
• What is JDBC?
• What is JDBC Blob data type? how to store and read data from it?
• What is JDBC Clob data type? how to store and read data from it?
• Pseudo mandatory parameters in JavaScript
• Restricting MySQL Connections to Secure Transport
• Why is Aadhaar mandatory in schools for entry-level admissions?