anonymousLog in-Register  
Groups

Recycle Type Property

Same page but  with a 'rename safe' link (used for external links)

Scope

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

Purpose

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)
By idle time: it is considered as soon as the connection is idle. (client.cfg entry corresponds to RecycleRWType=2)

Default = By creation time

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.

See Also

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

 




 
Created: 22 June 2010 11:53 AM by dmarquez Last update: 11 March 2014 01:06 AM by lsilveira