Subject Re: [Firebird-Java] Re: NPE in setTransactionIsolation(READ_UNCOMMITED)
Author Nickolay Samofatov
Hello Roman,

Thursday, December 05, 2002, 6:21:51 PM, you wrote:

>> There is a NPE when using setTransactionIsolation
>> (Connection.TRANSACTION_READ_UNCOMMITED).
>>
>> It seems TRANSACTION_READ_UNCOMMITED is lost in FBTpbMapper
>> constructor and isc_tpb_mapping.properties

> Hmm... it should throw an SQLException. I think we do not support
> read uncommitted. Is there any TPB combination that can provide "read
> uncommitted" semantics?

No. It can be easily added to the server, but now it is not supported
and there are no plans to support it.
But this mode can be used in conjunction with user-defined TPB
mapping to quickly switch betweed locking modes.

BTW, why driver sets does autocommit itself instead of setting
appropriate TPB flag ? It would make it work much faster.
Do any bugs in the engine prevent this ? They can be fixed.

> Roman

--
Best regards,
Nickolay Samofatov mailto:skidder@...