cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Hartmann <andr...@apache.org>
Subject ParseException in EJBQL statement with upper function
Date Wed, 20 Jan 2010 17:29:01 GMT
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.hartmann@gmail.com%')) OR
(upper(t.email) LIKE upper('%nobby@macbay.de%'))


The exception is:

Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " 
"UPPER" "upper "" at line 1, column 36.
Was expecting one of:
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...
     "(" ...

         at 
org.apache.cayenne.ejbql.parser.EJBQL.generateParseException(EJBQL.java:9419)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.jj_consume_token(EJBQL.java:9298)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_primary(EJBQL.java:1933)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_factor(EJBQL.java:1911)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_term(EJBQL.java:1776)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_expression(EJBQL.java:1738)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_primary(EJBQL.java:1928)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_factor(EJBQL.java:1911)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_term(EJBQL.java:1776)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.conditional_expression(EJBQL.java:1738)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.where_clause(EJBQL.java:1585)
         at 
org.apache.cayenne.ejbql.parser.EJBQL.select_statement(EJBQL.java:69)



Thanks a lot in advance!

Best regards,
Andreas



-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01


Mime
View raw message