Re: JDBC locking on processResults

From: Kris Jurka <books(at)ejurka(dot)com>
To: Mike Heath <mheath(at)avaloninc(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC locking on processResults
Date: 2005-04-20 23:15:20
Message-ID: Pine.BSO.4.56.0504201811240.30758@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-04-20 23:15:34 Re: implementing asynchronous notifications
Previous Message Mike Heath 2005-04-20 22:53:10 JDBC locking on processResults