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