[TOMEE-1625] provide a way to recreate a datasource pool - Flushable feature - automatically on SQLException - aka ResetOnError

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 7.0.0-M1
• Assignee: Romain Manni-Bucau
• Reporter: Romain Manni-Bucau
• Created: 09/Aug/15 18:47
• Updated: 10/Dec/15 12:08
• Resolved: 09/Aug/15 18:53

Description

<Resource id="..." type="DataSource">
ResetOnError = true
ResetOnErrorMethods = *
</Resource>

Defaults are:

• ResetOnError = false
• ResetOnErrorMethods = getConnection,getXAConnection

Advanced Configuration:

• ResetOnErrorMethods supports wildcard but not regex (ie * means all methods and that is it).
• ResetOnError can take a boolean (on/off behavior) as value or a string. In this last case behavior is the following: if "retry(N)" with N a number it retried N times before throwing an exception, if "N" with N a number it is as if it is "rerty(N)", if a fully qualified name of org.apache.openejb.resource.jdbc.ResettableDataSourceHandler$RetryStrategy it is instantiated passing as constructor parameter a Runnable (task flushing the delegate datasource) and the value itself (which can contain some inline config). If not any of these cases it fails.