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 BaseTransaction.getThreadTransaction().addConnection(..) to customize the connection.
Andrus [1] http://cayenne.apache.org/docs/4.0/cayenne-guide/persistent-objects-objectcontext.html#transactions > On Apr 13, 2016, at 3:28 PM, Malcolm Edgar <malcolm.ed...@gmail.com> wrote: > > 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
