Re: SET AUTOCOMMIT TO OFF - Mailing list pgsql-jdbc

From Marcos Truchado
Subject Re: SET AUTOCOMMIT TO OFF
Date
Msg-id 3FF83751.5060605@telefonica.net
Whole thread Raw
In response to Re: SET AUTOCOMMIT TO OFF  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
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();
    }

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: SET AUTOCOMMIT TO OFF
Next
From: "Andrew Dunstan"
Date:
Subject: Re: [HACKERS] PL/Java issues