Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group