Re: Transaction Isolation Level

Hello Kris,

I appreciate your immediate reply. Thanks.

I'm currently using the Driver version: PostgreSQL 7.3.1 JDBC3 jdbc driver
build 108

No, we don't invoke getTransactionIsolation() in our codes.
Is it the only way we can get this value = "TRANSACTION ISOLATION LEVEL :
READ_COMMITTED" ?

This problem is hard to reproduce. What can you suggest I do to determine
the cause of the problem?

Thank you so much for your time.

---
Grace

----- Original Message -----
From: "Kris Jurka" <books(at)ejurka(dot)com>
To: "Grace C. Unson" <gracec(at)ntsp(dot)nec(dot)co(dot)jp>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, March 25, 2004 6:55 AM
Subject: Re: [GENERAL] Transaction Isolation Level

>
>
> 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
>