Skip site navigation (1) Skip section navigation (2)

Re: Locking

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "vinu" <vinu(dot)rm(at)gmail(dot)com>,<pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Locking
Date: 2012-04-05 17:57:40
Message-ID: 4F7D96C40200002500046BFF@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-jdbc
vinu <vinu(dot)rm(at)gmail(dot)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

In response to

pgsql-jdbc by date

Next:From: BCHDate: 2012-04-06 08:05:54
Subject: JDBC DatabaseMetaData problem
Previous:From: cognizantDate: 2012-04-05 14:58:40
Subject: Issues with IN-OUT parameters for Array of Objects in EDB using Java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group