I have the following query:
SELECT a.alias FROM AliasBean AS a WHERE (a.alias IS NULL AND ?1 IS
NULL) OR a.alias = ?1
Which works great when run against HSQLDB. When I switch the
database to Derby I get the following exception:
0|false|0.9.6-incubating
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.
It might not be an easy issue for OpenJPA to fix. How easy is it
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
Dain-
Also, I'm using 0.9.6 so is this a known problem?
I have a very hazy recollection of this being something that was
fixed recently, but a quick search through JIRA doesn't reveal anything.
Could you try it out against the latest 0.9.7-incubating-SNAPSHOT and
let us know if still