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