On Apr 2, 2007, at 8:06 PM, Craig L Russell wrote:
Hi Dain,
I've seen this problem as well, with a different provider. The JPA
spec lead sez that "?1 IS NULL" is not a portable JPAQL query, even
though some providers can generate SQL that some databases can
execute properly.
OpenJPA is handling this for hsql just not derby. Is there some
plugin we can tweak to support this clause in derby?
It might not be an easy issue for OpenJPA to fix. How easy is it
for you to generate a different query?
Impossible. This query is defined in the CMP TCK.
-dain
