Deallocate resources

Close a Statement, PreparedStatement, and CallableStatement object by calling the appropriate close() method in your Java™ program when you have finished processing the results of an SQL statement. This closure immediately deallocates the resources that have been allocated to execute your SQL statement. Although the ResultSet.close() method closes the ResultSet object, it does not deallocate the resources allocated to the Statement, PreparedStatement, or CallableStatement objects.

It is good practice to call ResultSet.close() and Statement.close() methods when you have finished processing the results of an SQL statement, to indicate to Informix® JDBC Driver that you are done with the statement or result set. When you do so, your program releases all its resources on the database server. It is, however, not required to call ResultSet.close() and Statement.close() specifically, as long as you call to Connection.close(), which takes care of releasing these resources.