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();
}