Re: conflict txns in serialization isolation

From: Kris Jurka <books(at)ejurka(dot)com>
To: Yi LIN <ylin30(at)cs(dot)mcgill(dot)ca>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: conflict txns in serialization isolation
Date: 2004-07-26 17:11:50
Message-ID: Pine.BSO.4.56.0407261209510.7379@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 26 Jul 2004, Yi LIN wrote:

> db = DriverManager.getConnection(url, username, password);
> db.setAutoCommit(false);
> db.setTransactionIsolation(java.sql.Connection.TRANSACTION_SERIALIZABLE);
>

I think you want to set the transaction isolation before starting the
transaction by turning off autocommit. Later versions of the driver make
this work correctly or throw an error on this situation, but I recall you
were using an old version. So try reordering the last two lines.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-26 17:13:52 Re: questions
Previous Message Kris Jurka 2004-07-26 17:09:09 Re: Charset problem on WHERE clause