Obiously I do not need to synchronize the method… the synchronized block inside it should work just fine. Was just grasping at straws there.
I checked out dbcp and c3po (thanks for the pointers!) but none fits my app as each user needs to connect with his own credentials.
I’ll see if I can produce a test case and post it here…
From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Thursday, March 12, 2009 12:43 PM
To: Peter
Cc: Kris Jurka; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Totally weird behaviour in org.postgresql.Driver
Peter,
Couple things.... do you really need to synchronize twice in every method ???
Have you looked at dbcp or c3po instead of re-inventing the wheel ?
Can you supply us with a test case which does exhibit the bug ?