I'm running into a problem where a CriteriaQuery with a single notEqual predicate is returning all entities, ie not filtering by the predicate.
Looked at the query in the debugger, and it seemed fine. Translated it to std sql and ran it in my database, and got what I expected. So I set shared-cache-mode to NONE in my persistence.xml to check the openjpa.SQL log entry and/or the database logs to see what was going on, and the CriteriaQuery began filtering as I originally expected. Set persistence.xml shared-cache-mode back to DISABLE_SELECTIVE, and the CriteriaQuery is again NOT filtering. I'm Using OpenJPA 2.0.1, and I've got ant building the metaModel via -Aopenjpa.metamodel=true. Same results whether my properties has openjpa.jdbc.QuerySQLCache set to true or false. Anybody else hit this before, or even better not hit this? Thanks, Jim -- View this message in context: http://openjpa.208410.n2.nabble.com/CriteriaQuery-with-shared-cache-mode-Enabled-Not-Working-tp6298760p6298760.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
