Connection pool problem

From: Stéphane RIFF <stephane(dot)riff(at)cerene(dot)fr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Connection pool problem
Date: 2005-03-01 07:56:49
Message-ID: 42242041.8030604@cerene.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I've create a connection pool with dbcp end another with
Jdbc3PoolingDatasource,
it seems to work well but :
My pool is a eight connections pool, the problem is when i get some
database exception (for example
"constraint violation", "duplicate key on unique index"...) the
connection didn't released to the pool.
After eight exception my application wait for a connection from the pool
which nerver give one because
of the PSQLException thrown.

Does somebody know about this??

Hope it's understandable
Thanks

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.2 - Release Date: 28/02/2005

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Guillaume Cottenceau 2005-03-01 09:05:22 Re: impossible to update rows specifying columns with NULL value?
Previous Message Francisco Figueiredo Jr. 2005-03-01 02:11:05 Re: [JDBC] Where are we on stored procedures?