Clean pooled connections

You can alter connections from their original, default properties by setting database properties, such as AUTOCOMMIT and TRANSACTION ISOLATION. When a connection is closed, these properties revert to their default values. However, a pooled connection does not automatically revert to default properties when it is returned to the pool.

In Informix® JDBC Driver, you can call the scrubConnection() method to:
  • Reset the database properties and connection level properties to the default values.
  • Close open cursors and transactions.
  • Retain all statements.

This now enables the application server to cache the statements, and it can be used across applications and sessions to provide better performance for end-user applications.

The signature of the scrubConnection() method is:
public void scrubConnection() throws SQLException
The following example demonstrates how to call scrubConnection():
try
  {
  IfmxConnection conn = (IfmxConnection)myConn;
  conn.scrubConnection();
  }
catch (SQLException e)
  {
  e.printStackTrace();
  }
The following method verifies whether a call to scrubConnection() has released all statements:
public boolean scrubConnectionReleasesAllStatements()