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