RE: Isolation level

Hi Armin,

thank you for  quick answer and sorry for my long delay.

We are using an older OJB version (1.0.1.x), so I thought I cannot use your
recommendation and wanted to perform a backport now.
I got the actual OJB now and examined it, but also couldn't find an
attribute in the jdbc-connection-descriptor (I checked the repository.dtd).

So I asume I have to implement the JDBC transaction level as attribute for
jdbc-connection-descriptor into OJB or do I miss something?

Could someone point me in the right direction for this implementation? I
assume I have to read the attribute and apply it in the function
PlatformDefaultImpl.initializeJdbcConnection.

Thanks in advance, CL

-----Original Message-----
From: Armin Waibel [mailto:[email protected]] 
Sent: Freitag, 25. Jänner 2008 03:03
To: OJB Users List
Subject: Re: Isolation level

Hi Christian,

Christian Lipp wrote:
> I am still looking for an solution for my lock level settings and 
> therefore I am digging through the OJB source.
> 
> What I am not sure at the moment is if the setting of the 
> isolation-level is generally ignored in OJB?
> <descriptor-repository version="1.0" isolation-level="read-comitted">
> 
> I couldn't find the place in the OJB code where the isolation level is 
> set to the DescriptorRepository and later to the connection.
> In my optionion the isolation-level in the XML file is ignored.
> 
> Could someone point me in the right direction?

Out of the box the isolation-level setting is only used by the ODMG-api
which use pessimistic locking by default.
http://db.apache.org/ojb/docu/guides/lockmanager.html#Pessimistic-Locking
The PB-api doesn't use pessimistic locking, thus it will ignore these
settings.

The database transaction levels are completely independent from the
isolation-level setting in OJB. So you can use different database
transaction levels (e.g. as property in the dbalias attribute in the
jdbc-connection-descriptor)

regards,
Armin

> 
> Thanks in advance,
> CL
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]