openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig L Russell <Craig.Russ...@Sun.COM>
Subject Re: Bad Derby query
Date Tue, 03 Apr 2007 04:11:23 GMT

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?


> 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
408 276-5638
P.S. A good JDO? O, Gasp!

View raw message