3.15.7 Connection sweeper

Connection sweeper is a functionality that monitors the connection pool at regular intervals, and destroys the unused connections that are not used for a fixed period of time. If the time elapsed since the applicable connection was last used is equal to the specified time or more, the connection will be destroyed. This functionality can be used in cases when there is a gateway, such as a firewall, between Application Server and database server, and the connection is disconnected at a fixed time.

The connection sweeper functionality is disabled by default. Note that you specify the settings for the connection sweeper functionality as the resource adapter properties. For details on the resource adapter settings, see 3.15.13 Settings in the execution environment.

Note that when you use the connection sweeper functionality, specify settings so that the total value of ConnectionTimeout and SweeperInterval in the <property> tag of the HITACHI Connector Property file is less than the connection disconnecting time. Also, by setting a long ConnectionTimeout, you can extend the period for which a connection is stored.