RE: Isolation level for Persistence broker queries

2005-01-03 Thread Vesely, Max [IT]
Thank you. 

What I was trying to do, actually, was to change default isolation level to 
lesser level of read-uncommitted for some of my selects. I replaced OJB SQL 
generator to append database engine (DB2) specific clause (WITH UR) in my SQL 
command to achieve that.

Max.



 -Original Message-
From:   CLARAMONTE Jean-Baptiste [mailto:[EMAIL PROTECTED] 
Sent:   Monday, January 03, 2005 4:38 AM
To: Vesely, Max [IT]; 'OJB Users List '
Subject:RE: Isolation level for Persistence broker queries

 Hello,

With the PersistenceBroker api you can't specify the isolation level. You
can use optimistic transaction to enhance the consistency of your data but
you should be very cautious if you use it with a cache because it can
introduce some strange behaviour on data highly exposed to concurrency
update !

-Message d'origine-
De: Vesely, Max [IT]
A: OJB Users List
Date: 31/12/2004 01:12
Objet: RE: Isolation level for Persistence broker queries

Thanks. I'll wait for the next week then.

Max.

 -Original Message-
From:   Thomas Dudziak [mailto:[EMAIL PROTECTED] 
Sent:   Thursday, December 30, 2004 7:04 PM
To: OJB Users List
Subject:Re: Isolation level for Persistence broker queries

Vesely, Max [IT] wrote:

>Is there a particular reason I don't get my questions answered? Just to
know it will save me some time in the future.
>  
>
Well, I would say it is because currently there are holidays, so you can

only reasonably expect answers next week the earliest, I'd say. And the 
people that every once in a while check their mail (like myself) are 
likely not able to answer your question. I for one don't know much about

the isolation level stuff so I can't help you there.

Tom


-
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]
*** We scanned this email for malicious content ***
*** IMPORTANT: Do not open attachments from unrecognized senders  ***
*** MailSystem ASTON ***



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Isolation level for Persistence broker queries

2005-01-03 Thread CLARAMONTE Jean-Baptiste
  Hello,

With the PersistenceBroker api you can't specify the isolation level. You
can use optimistic transaction to enhance the consistency of your data but
you should be very cautious if you use it with a cache because it can
introduce some strange behaviour on data highly exposed to concurrency
update !

-Message d'origine-
De: Vesely, Max [IT]
A: OJB Users List
Date: 31/12/2004 01:12
Objet: RE: Isolation level for Persistence broker queries

Thanks. I'll wait for the next week then.

Max.

 -Original Message-
From:   Thomas Dudziak [mailto:[EMAIL PROTECTED] 
Sent:   Thursday, December 30, 2004 7:04 PM
To: OJB Users List
Subject:Re: Isolation level for Persistence broker queries

Vesely, Max [IT] wrote:

>Is there a particular reason I don't get my questions answered? Just to
know it will save me some time in the future.
>  
>
Well, I would say it is because currently there are holidays, so you can

only reasonably expect answers next week the earliest, I'd say. And the 
people that every once in a while check their mail (like myself) are 
likely not able to answer your question. I for one don't know much about

the isolation level stuff so I can't help you there.

Tom


-
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]
*** We scanned this email for malicious content ***
*** IMPORTANT: Do not open attachments from unrecognized senders  ***
*** MailSystem ASTON ***

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]