Acces technology set: JDBC
DBMSs: SQL Server, Oracle, iSeries Native, DB2 UDB, Informix, PostgreSQL, MySQL
It specifies the type of recycle that will be done when recycle is enabled (Recycle Pool Connections Property = True).
By creation time: the value (in minutes) entered in the “Recycled time” property will be considered. (client.cfg entry corresponds to RecycleRWType=1)
By idle time: it is considered as soon as the connection is idle. (client.cfg entry corresponds to RecycleRWType=2)
Default = By creation time
Recycle Time (Minutes) = Y
The objective is that when a new connection is required, it looks for one connection in the pool that is free to be used. If such connection has been created since X time or been idle for X time, where X >= Y, depending on the property value, this connection is recycled (destroyed) and a new one that doesn’t have those characteristics is sought until finding one or, if there is none, a new one is created.
Recycle Pool Connections Property
Recycle Type Property
Recycle Time (Minutes) Property