Re: JDBC locking on processResults - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC locking on processResults
Date
Msg-id Pine.BSO.4.56.0504201811240.30758@leary.csoft.net
Whole thread Raw
In response to JDBC locking on processResults  (Mike Heath <mheath@avaloninc.com>)
List pgsql-jdbc

On Wed, 20 Apr 2005, Mike Heath wrote:

> I'm using Postgresql 8.0.2 on SuSE Linux Professional 9.2.  I'm using
> Java version 1.5.0_02.  I'm using The 8.0.311 build of the JDBC driver.
>
> However, when I trace down to
> org.postgresql.core.V3.QueryExecutorImpl.processResults(ResutlHandler,
> int) (line 1122) it makes a call to pgStream.ReceiveChar() and just
> locks.  It appears as though it's waiting for something from the server
> and the server isn't sending it.  I don't see any errors in the server
> logs.

It is indeed waiting for a server response and I have no reason to believe
this is a problem with either the server or the driver.  It is likely
waiting to acquire some kind of lock, you did mention there is lot of
other things going on.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Mike Heath
Date:
Subject: JDBC locking on processResults
Next
From: Oliver Jowett
Date:
Subject: Re: implementing asynchronous notifications