Re: Query Isolation - Dirty Reads

2016-04-14 Thread Malcolm Edgar
Thank you much appreciated. regards Malcolm On Thu, Apr 14, 2016 at 4:42 PM, Andrus Adamchik wrote: > Hi Malcolm, > > Yeah, going to the connection level is probably the way to solve this. You > will need to wrap your commit / select code in a manual transaction, which > is fairly easy in 4.0 [

Re: Query Isolation - Dirty Reads

2016-04-13 Thread Andrus Adamchik
Hi Malcolm, Yeah, going to the connection level is probably the way to solve this. You will need to wrap your commit / select code in a manual transaction, which is fairly easy in 4.0 [1] (hmm... there's a typo in the docs. No "perform" method is shown). Inside your code you can use BaseTransa

Query Isolation - Dirty Reads

2016-04-13 Thread Malcolm Edgar
Hi Guys, Any recommendations on the best way to perform dirty reads with Cayenne. Should we resolve the connection object and change transaction isolation level, perform the dirty query and then revert back to serializable ? regards Malcolm Edgar