On Wed, 21 May 2008, Kris Jurka wrote:
> On Wed, 21 May 2008, Daniel Migowski wrote:
>
>> I came across a deadlock condition in the JDBC driver that rises when very
>> large queries, containing thousends of statements are send to the server
>> with statement.execute().
>
> We already consider this case for batch execution and break the batch into an
> internal size that we expect is safe from deadlock. It looks like we should
> be doing the same for these one query batches. I'm not sure how tough that
> will be, but I'll take a look.
I've committed a fix to CVS for this problem, and it should fix your case,
but will not fix all deadlocks as a move to NIO or threading would.
For more details, see:
http://archives.postgresql.org/pgsql-jdbc/2008-10/msg00034.php
Kris Jurka
