Holdability

Holdability is configured on the database connection. For J2SE applications, enabled (true) is the default. Disabled (false) is the default for WebSphere® Application Server J2EE applications.

When holdability is true for the database connection:

• The result set is still available after a transaction commit
• The result set has to be explicitly closed

When holdability is false for the database connection:

• The result set is not available after a transaction commit
• The transaction must be manually committed when the result set is no longer needed. Committing the transaction automatically closes the result set.