Periodic probe job to keep connections non-idle and probe for dead ones.
This is primarily useful for MySQL, which closes connections after a
period of inactivity.
This should be run using a scheduler participant. For example, to
probe the "mysql" Datasource once a minute:
<scheduler>
<task classname="com.uwyn.rife.database.DbProbeExecutor"
frequency="* * * * *">
<option name="datasource">mysql</option>
<option name="query">select 1</option>
</task>
</scheduler>
There are two optional parameters.
datasource
- The name of the Datasource to probe. If not specified, the
default is "datasource".
query |