problem with ( )

[Mathieu]

Hi !

I'm curently trying to use Simple JPA ( wich is very good, thanks to
the developpers :D )
I'm having trouble while using the ( )... Here is my request :

Query query = em.createQuery("select s from Session s where s.customer
= :customer and ( s.status = :status1 or s.status = :status2 )");

query.setParameter("customer", "1");
query.setParameter("status1", "open");
query.setParameter("status2", "uploading");

But at the execution, I get this erro :

Testcase: testGetRoot(unitTest.SessionTest): Caused an ERROR
parameter is null for: status2 )
javax.persistence.PersistenceException: parameter is null for:
status2 )
at
com.spaceprogram.simplejpa.query.QueryImpl.getParamValueAsStringForAmazonQuery(QueryImpl.java:
405)
at
com.spaceprogram.simplejpa.query.QueryImpl.appendCondition(QueryImpl.java:
388)
at
com.spaceprogram.simplejpa.query.QueryImpl.toAmazonQuery(QueryImpl.java:
270)
at
com.spaceprogram.simplejpa.query.QueryImpl.toAmazonQuery(QueryImpl.java:
270)
at
com.spaceprogram.simplejpa.query.QueryImpl.createAmazonQuery(QueryImpl.java:
173)
at
com.spaceprogram.simplejpa.query.QueryImpl.getResultList(QueryImpl.java:
104)
at sage.mybi.session.SessionTest.testGetRoot(SessionTest.java:
34)

I tried with or without space between characters and ( ) but still
failed...
Can anyone help me please ?

[Travis Reeder]

Are you positive "status2" is not null?  Is query.setParameter("status2", "uploading"); the exact code you are using?

--
You received this message because you are subscribed to the Google Groups "SimpleJPA" group.
To post to this group, send email to simp...@googlegroups.com.
To unsubscribe from this group, send email to simplejpa+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/simplejpa?hl=en.

[Mathieu]

Yeah, that's the real source code...
I don't understand why the error occured.

[Mathieu]

Yeah, that's the real source code...

No intermediate variable

On 27 avr, 17:15, Travis Reeder <tree...@gmail.com> wrote: