I am having the same issue. 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 ?