Обсуждение: transaction isolation level

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)
 at com.evermind._in.setTransactionIsolation(Unknown
Source)
 at com.evermind._in.setTransactionIsolation(Unknown
Source)
 at com.evermind._in.setTransactionIsolation(Unknown
Source)

Here is an example of the code that does this:

Connection con = null;
       try
       {
           DataSource ds = (DataSource)
ctx.lookup("jdbc/EncounterEJBDS");
    con = ds.getConnection();

con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
.
.
.

Anybody experienced this or have a fix?




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

"josh hes." <jbhester@yahoo.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

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@yahoo.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
>