[eclipselink-users] Cannot pass null parameter

[bht@xxxxxxxxxxxxx]

Hi Tom,

In principle, I don't want to suggest any constraints on what SQL
EclipseLink should produce. The examples at 

http://en.wikipedia.org/wiki/Java_Persistence_Query_Language#Examples

contain a compact JPQL as follows

SELECT a FROM Author a WHERE :lastName IS NULL OR LOWER(a.lastName) =
:lastName

which I have used successfully with OpenJPA in other projects.

This type of query is very useful especially when expanded for
querying a large number of fields with only a sub-set of user-supplied
values, without having to generate the query in code which is a lot of
work and risky, or even more work but less risky when using the
criteria API.

In

https://bugs.eclipse.org/bugs/show_bug.cgi?id=362414

I plugged in OpenJPA with the following persistence.xml modifications:

<property name="openjpa.Log" value="SQL=TRACE"/>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(SchemaAction=&apos;add,deleteTableContents&apos;,ForeignKeys=true)"/>

and 
-javaagent:openjpa-all-2.1.1.jar

Their solution might not be EclipseLink's final solution, so
EclipseLink might in the end do something more intelligent - as long
as it works, that would be fine with me.

The testcase is somewhat special because it queries related Region not
basic CustomerOrder so I should have added a basic case, too.

Kind Regards,

Bernard





On Mon, 31 Oct 2011 08:27:52 -0400, you wrote:

>Hi Bernard,
>
>   The exception you are getting is a SQLException.  That comes from your 
>database, not EclipseLink.  What SQL are you expecting us to produce?
>
>-Tom
>
>On 29/10/2011 10:51 PM, bht@xxxxxxxxxxxxx wrote:
>> Hi,
>>
>> Please help me find a workaround for
>>
>> Cannot pass null in Parameter as Identification variable or Primitive
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=362414
>>
>> I am really perplexed because this seems to be quite basic. I made a
>> cross check - it works in OpenJPA.
>>
>> Thanks,
>>
>> Bernard
>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>_______________________________________________
>eclipselink-users mailing list
>eclipselink-users@xxxxxxxxxxx
>https://dev.eclipse.org/mailman/listinfo/eclipselink-users