Re: ParseException in EJBQL statement with upper function

2010-01-21 Thread Andreas Hartmann
Am 20.01.10 19:57, schrieb Andrey Razumovsky: Looks like a bug, could you please report it? Done: https://issues.apache.org/jira/browse/CAY-1370 In the meanwhile, this can be used: SELECT count(t) FROM User t WHERE (upper(t.email) LIKE '%andreas.hartm...@gmail.com%') OR (upper(t.email) LIKE

Re: ParseException in EJBQL statement with upper function

2010-01-20 Thread Andrey Razumovsky
Looks like a bug, could you please report it? In the meanwhile, this can be used: SELECT count(t) FROM User t WHERE (upper(t.email) LIKE '%andreas.hartm...@gmail.com%') OR (upper(t.email) LIKE '%no...@macbay.de%') 2010/1/20 Andreas Hartmann > Hi everyone, > > I'm taking my first steps with EJB

ParseException in EJBQL statement with upper function

2010-01-20 Thread Andreas Hartmann
Hi everyone, I'm taking my first steps with EJBQL. Can someone spot the error in the following statement? SELECT count(t) FROM User t WHERE (upper(t.email) LIKE upper('%andreas.hartm...@gmail.com%')) OR (upper(t.email) LIKE upper('%no...@macbay.de%')) The exception is: Caused by: org.apache.