My guess would be that you are getting the connection with autocommit
(false);
Either way try
conn = getConn...
conn.setAutoCommit(false);
conn.changeTransactionLevel
On 29-Aug-06, at 9:15 AM, Tom Lane wrote:
"josh hes." <[EMAIL PROTECTED]> writes:
We recently updated our postgres to 8.1.4, since then
I’ve been getting the following error:
[Aug 28, 2006 5:43:16 AM ERROR]
org.postgresql.util.PSQLException: Cannot change
transaction isolation level in the middle of a
transaction.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(
AbstractJdbc2Connection.java:729)
Updated to 8.1.4 from what?
You'll probably have better luck asking on the pgsql-jdbc list (and
mentioning which jdbc driver versions are involved). This looks to me
like it's associated with a change in driver behavior not backend
behavior.
regards, tom lane
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
