Jim, A CriteriaQuery or a JPQL string both are internally converted to an internal query expression tree -- which gets executed. So I am slightly baffled by your observation and its dependency on data cache settings. Here are few suggestions 1. Once the CriteriaQuery is formed, call toString() to get a stringfied form. This should be the equivalent JPQL. Now execute the JPQL and see if you see any difference in result. 2. See if the CriteriaQuery and JPQL are creating different target SQL or not. 3. Switch of DataCache and see if that makes any difference.
----- Pinaki -- View this message in context: http://openjpa.208410.n2.nabble.com/CriteriaQuery-with-shared-cache-mode-Enabled-Not-Working-tp6298760p6298779.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
