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
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 |