Based on this:
http://java.sun.com/javase/6/docs/api/java/sql/Connection.html#commit%28%29
Connection.commit() and Connetion.rollback() in the PostgreSQL JDBC
driver don't throw exceptions when they should. This was posted as
bug 5127 on the bugs list when it broke a user's connection pooling.
Are there any arguments that the PostgreSQL driver should not throw
and exception as stated on that javadoc page?:
- if a database access error occurs,
- this method is called while participating in a distributed
transaction,
- if this method is called on a closed connection or
- this Connection object is in auto-commit mode
I could take a shot at a patch if nobody disagrees with making this
change.
-Kevin