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
msg07699/pgp00000.pgp
Description: PGP signature