Re: Transaction Isolation Level - Mailing list pgsql-general

From Kris Jurka
Subject Re: Transaction Isolation Level
Date
Msg-id Pine.BSO.4.56.0403241712050.13875@leary.csoft.net
Whole thread Raw
In response to Transaction Isolation Level  ("Grace C. Unson" <gracec@ntsp.nec.co.jp>)
List pgsql-general

On Thu, 25 Mar 2004, Grace C. Unson wrote:

> Hello.
>
> How is it possible that ResultSetObjInstance in this statement
>
> ResultSetObjInstance = PreparedObjInstance.executeQuery()
>
> contains this column and value respectively:
>
> TRANSACTION ISOLATION LEVEL , READ_COMMITTED ?
>
> ---
> Note:
> During the query operation, lots of write operations are going
> simultaneously in the DB. If this is the reason of the "not-expected" value
> above, why is it returned and not thrown as exception?
>

This could be an indication of a thread safety problem in the driver.  Are
you using multiple threads on the same connection?  The only code (other
than your own) that could generate that ResultSet would be calling
Connection.getTransactionIsolation() do you have any of these calls in
your code?

What version of the driver are you using?

Kris Jurka

pgsql-general by date:

Previous
From: Guy Fraser
Date:
Subject: Re: PHP or JSP? That is the question.
Next
From: Alan Carbutt
Date:
Subject: Adding flexibilty to queries