Recycle Type Property

It specifies the type of recycle that will be done when recycle is enabled (Recycle Pool Connections Property = True).

Values

By creation time The value (in minutes) entered in the “Recycled time” property will be considered. (client.cfg entry corresponds to RecycleRWType=1). This is the default value.
By idle time It is considered as soon as the connection is idle. (client.cfg entry corresponds to RecycleRWType=2)

Description

Supposing that:

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.

Scope

Acces technology set: JDBC
DBMSs: SQL Server, Oracle, iSeries Native, DB2 UDB, Informix, PostgreSQL, MySQL

See Also

Recycle Pool Connections Property
Recycle Type Property
Recycle Time (Minutes) Property