Re: SET AUTOCOMMIT TO OFF

Kris Jurka wrote:

On Sun, 4 Jan 2004, Joseph Shraibman wrote:
 

After upgrading to 7.4.1, I keep getting this error:

ERROR:  SET AUTOCOMMIT TO OFF is no longer supported

isn't this supposed to be fixed in the 7.4.1 driver?   

Yes.  Are you sure you have a 7.4 series driver?

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org
 

Works ok here.

Postgresql: 7.4.0
driver: pg74jdbc3.jar build 210


Connection conn = null;
    try {
        conn = getConnection();
       
        boolean autoCommit = conn.getAutoCommit();
        conn.setAutoCommit(false);

        ... do stuff with database
       
         conn.commit();
         conn.setAutoCommit(autoCommit);
    } catch(SQLException e) {
         conn.rollback();
         e.printStackTrace();
    }