Re: SET AUTOCOMMIT TO OFF

Joseph Shraibman wrote:

> After upgrading to 7.4.1, I keep getting this error:
>
> ERROR:  SET AUTOCOMMIT TO OFF is no longer supported
>
> ... when I do:
>
>   db = DriverManager.getConnection(url, usr, pwd);
>   db.setAutoCommit(false);
>
> isn't this supposed to be fixed in the 7.4.1 driver?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
So what is the correct way to do:

Connection conn = null; //I must init conn to some value, if not the
compiler told me that conn could be not initialiced

try {
    conn = getConnection();
    conn.setAutoCommit(false);
    Statement stat = conn.createStatement();

    stat.executeUpdate(command1);
    stat.executeUpdate(command2);
    ...

    conn.commit();
} catch(SQLException e) {
    conn.rollback();
    e.printStackTrace();
}