|
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. |
|
|
|
|
|
|
|