[C2] database connection pooling

[Christian Joelly <ch...@knapp.com>]

Hello ppl!

i have a question regarding database connection pools:

i use a lvs ha server for serving static web content from apache and
also for mysql db servers. the lvs maintains persistant connections with
a timeout, eg. i can define a "persistance timeout" of 300sec for a
connection managed by lvs (linux virtual server) to the mysql server.

now, when i setup a database connection pool for cocoon2, the db
connections the pool creates "expires" and where dropped on the lvs
after 300sec. so, if cocoon wants to use one connection from the pool,
the lvs has destroyed the connection to the mysql database server and
the cocoon application "hangs".

is there a possibility to setup a database connection pool which
"monitors" his connections and drops lost connections and create new
ones? 

i hope i was able to describe my problem *correct* ;-)

Chris

-- 
KNAPP Logistics Automation  http://www.knapp.com
Ing. Christian Jölly        Tel/FAX: (++43) 316 / 495 1926 / 495 394
Günter-Knapp-Straße 5-7     A-8075 Hart bei Graz