Red Hat Bugzilla – Bug 133631
SET AUTOCOMMIT TO OFF is no longer supported
Last modified: 2013-07-02 23:02:26 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7)
Description of problem:
SET AUTOCOMMIT TO OFF is no longer supported. This functionality works
fine with postgresql-7.3.4-3.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.Install any java app that uses SET AUTOCOMMIT TO OFF
2.Run process that tries to SET AUTOCOMMIT TO OFF
Actual Results: java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF
is no longer
Expected Results: No error
Appears the postgres guys may have resolved this, but you guys would
have better access than I :-)
You may also want to the separate postgresql components to bugzilla.
This is not a bug; it's a deliberate upstream change.
If you have a JDBC driver that is using SET AUTOCOMMIT, you need to
update to a 7.4-compatible driver. If you have an application that is
using SET AUTOCOMMIT, it's broken in itself, because only the driver
should be messing with that.