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

["Romain Manni-Bucau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TOMEE-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Romain Manni-Bucau resolved TOMEE-1625.
---------------------------------------
    Resolution: Fixed

> provide a way to recreate a datasource pool - Flushable feature - automatically on SQLException - aka ResetOnError
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: TOMEE-1625
>                 URL: https://issues.apache.org/jira/browse/TOMEE-1625
>             Project: TomEE
>          Issue Type: New Feature
>            Reporter: Romain Manni-Bucau
>            Assignee: Romain Manni-Bucau
>             Fix For: 7.0.0-M1
>
>
> {code}
> <Resource id="..." type="DataSource">
> ResetOnError = true
> ResetOnErrorMethods = *
> </Resource>
> {code}
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)