"Disable Auto Connection Cleanup" function is not available with a Version 5 Datasource
 Technote (FAQ)
 
Problem
"Disable Auto Connection Cleanup" specifies whether or not the connection pooling software automatically closes connections from this datasource at the end of a transaction.

The default is false, which indicates that when a transaction completes, WebSphere® Application Server closes the connection and returns it to the pool. Any use of the connection after the transaction has ended results in a StaleConnectionException because the connection is closed and has returned to the pool. This mechanism ensures that connections are not held indefinitely by the application.

If the value is set to true, the connection is not returned to the pool at the end of a transaction. In this case, the application must return the connection to the pool by calling close(). If the application does not close the connection, the pool can run out of connections for other applications to use.
 
 
Solution
With Version 5 Datasources, there is J2C compliant Shared Connections which will reuse the same connection within a global transaction when the get, use, commit, close order of operations is used. Shared Connections will be closed at the end of a transaction if unclosed by the application. This is similar to "Disable Auto Connection Cleanup" = false.

Unshared connections will not be closed at the end of a transaction. This is similar to "Disable Auto Connection Cleanup" = true.
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): AIX
Software version: 6.0
Software edition:
Reference #: 1207963
IBM Group: Software Group
Modified date: May 31, 2005