Re: Locking - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: Locking
Date
Msg-id 4F7D96C40200002500046BFF@gw.wicourts.gov
Whole thread Raw
In response to Re: Locking  (vinu <vinu.rm@gmail.com>)
List pgsql-jdbc
vinu <vinu.rm@gmail.com> wrote:

> I am having the same issue.

For the benefit of those who don't remember the post:

http://archives.postgresql.org/pgsql-jdbc/2008-04/msg00094.php

> Unless we close the connection or do a connection.commit(), the
> AccessShareLock is not getting released. ResultSet.close() and
> PreparedStatement.close() is not having any effect on this
> behavior. Is this the expected behavior ?

Yes.  Did you look at the existing reply?

http://archives.postgresql.org/pgsql-jdbc/2008-04/msg00095.php

-Kevin

pgsql-jdbc by date:

Previous
From: vinu
Date:
Subject: Re: Locking
Next
From: Muhammad Altaf
Date:
Subject: Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java