Hi, This is a bug, and was reported in https://issues.apache.org/jira/browse/OPENJPA-1845 OPENJPA-1845 . The result of that bug report is to exclude queries that include an IN expression from the cache with an informative message. This fix went into OpenJPA version 2.1, but not 2.0.
Recently, an improvement JIRA has been opened to enable these queries in the cache: https://issues.apache.org/jira/browse/OPENJPA-2001 OPENJPA-2001 . The SQL cache was extensively modified between OpenJPA versions 1.2 and 2.0 - which is probably why these queries worked on earlier releases. When I get a few cycles I'll look into porting OPENJPA-1845 back to 2.0. -mike -- View this message in context: http://openjpa.208410.n2.nabble.com/Incorrect-reparameterization-of-a-Cached-prepared-SQL-statement-with-IN-clause-with-a-different-numbs-tp6387137p6395804.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
