Re: transaction isolation level

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." <jbhester(at)yahoo(dot)com> 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
>