Connection Lifetime and pooling

bradk · Post by **bradk** » Fri 23 Feb 2007 17:41

I'm trying to understand what this means from the docs:

"Connection Lifetime - When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0. "

If the default value is 0, that implies a connection is destroyed every time its returned to the pool. Or, is 0 a special value that means the connection never expires ?

Another pooling question: if I set the max pool size to a smaller value (say 10), will attempts to make more than 10 connections fail, or just not use the pool ?

Alexey · Post by **Alexey** » Mon 26 Feb 2007 08:44

If the default value is 0, that implies a connection is destroyed every time its returned to the pool. Or, is 0 a special value that means the connection never expires ?

It is a special value that means the connection never expires.

if I set the max pool size to a smaller value (say 10), will attempts to make more than 10 connections fail, or just not use the pool ?

The attempt will fail.