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?

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:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!


Mime
View raw message