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

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