setAutoCommit(false)

From: Andy Jefferson <andy_jefferson(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: setAutoCommit(false)
Date: 2004-05-12 09:45:19
Message-ID: 20040512094519.11446.qmail@web50807.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm a developer on a JDO implementation and we support PostgreSQL as a
database. When obtaining a connection for the DB we do a
setAutoCommit(false). Nothing controversial there. I've used PostgreSQL
7.3.* with no problems and also 7.4.1-2 with no problems. I do however
have
a user saying that he is using latest PostgreSQL (postgresql 7.4.2 with
pg74.213.jdbc3 is what he told me) and our call to setAutoCommit(false)
apparently returns

java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer
supported

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:482)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:461)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Connection.java:957)
at
org.jpox.store.adapter.DatabaseAdapter.getConnection(DatabaseAdapter.java:702)

Is there any good reason why he is getting this ? If so, what are
client
applications supposed to do to not have things auto-committed ?

TIA

=====




____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-05-12 10:00:49 Re: JDBC and processing large numbers of rows
Previous Message Guido Fiala 2004-05-12 06:37:42 Re: JDBC and processing large numbers of rows