On Apr 2, 2007, at 8:39 PM, Dain Sundstrom wrote:
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.
Do you mean that OpenJPA generates different SQL for hsql? Or that
hsql can execute the SQL that Derby cannot?
Craig
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
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!
