Log in-Register  

Recycle Type Property

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


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.


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



Next →
Created: 22 June 2010 11:53 AM by dmarquez Last update: 3 October 2016 04:14 PMbyerosselli

Was this page helpful?What Is This?
Your feedback about this content is important. Let us know what you think.