RE: Isolation level for Persistence broker queries
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
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
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]
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]
RE: Isolation level for Persistence broker queries
Is there a particular reason I don't get my questions answered? Just to know it will save me some time in the future. Thanks. -Original Message- From: Vesely, Max [IT] Sent: Wednesday, December 29, 2004 5:48 PM To: ojb-user@db.apache.org Subject: Isolation level for Persistence broker queries Hello, Is there any way to specify isolation level for OJB query executed using Persistence Broker API? I can see that there's isolation-level attribute available for class-descriptor but documentation says it's only used in ODMG implementation. Any help would be greatly appreciated. Max. - 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]
Isolation level for Persistence broker queries
Hello, Is there any way to specify isolation level for OJB query executed using Persistence Broker API? I can see that there's isolation-level attribute available for class-descriptor but documentation says it's only used in ODMG implementation. Any help would be greatly appreciated. Max. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
