You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andreas Hartmann (JIRA)" <ji...@apache.org> on 2010/01/21 12:01:54 UTC
[jira] Created: (CAY-1370) EJBQL: ParseException with upper() /
lower() functions
EJBQL: ParseException with upper() / lower() functions
------------------------------------------------------
Key: CAY-1370
URL: https://issues.apache.org/jira/browse/CAY-1370
Project: Cayenne
Issue Type: Bug
Components: Core Library
Affects Versions: 3.1M1
Environment: Mac OS X 10.5.8, Java 1.6
Reporter: Andreas Hartmann
Statement: select p from Painting p where upper(p.name) like upper('foo')
Exception:
org.apache.cayenne.ejbql.EJBQLException: [v.3.1-SNAPSHOT ${project.build.date} ${project.build.time}] Error parsing EJB QL statement
at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:24)
at org.apache.cayenne.ejbql.EJBQLExpressionTest.testUpper(EJBQLExpressionTest.java:36)
Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " "UPPER" "upper "" at line 1, column 32.
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.where_clause(EJBQL.java:1585)
at org.apache.cayenne.ejbql.parser.EJBQL.select_statement(EJBQL.java:69)
at org.apache.cayenne.ejbql.parser.EJBQL.parseQuery(EJBQL.java:41)
at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:21)
... 26 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (CAY-1370) EJBQL: ParseException with upper() /
lower() functions
Posted by "Andreas Hartmann (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803265#action_12803265 ]
Andreas Hartmann commented on CAY-1370:
---------------------------------------
Great, thanks a lot!
> EJBQL: ParseException with upper() / lower() functions
> ------------------------------------------------------
>
> Key: CAY-1370
> URL: https://issues.apache.org/jira/browse/CAY-1370
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 3.1M1
> Environment: Mac OS X 10.5.8, Java 1.6
> Reporter: Andreas Hartmann
> Attachments: CAY-1370-Test.patch
>
>
> Statement: select p from Painting p where upper(p.name) like upper('foo')
> Exception:
> org.apache.cayenne.ejbql.EJBQLException: [v.3.1-SNAPSHOT ${project.build.date} ${project.build.time}] Error parsing EJB QL statement
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:24)
> at org.apache.cayenne.ejbql.EJBQLExpressionTest.testUpper(EJBQLExpressionTest.java:36)
> Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " "UPPER" "upper "" at line 1, column 32.
> 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.where_clause(EJBQL.java:1585)
> at org.apache.cayenne.ejbql.parser.EJBQL.select_statement(EJBQL.java:69)
> at org.apache.cayenne.ejbql.parser.EJBQL.parseQuery(EJBQL.java:41)
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:21)
> ... 26 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (CAY-1370) EJBQL: ParseException with upper() /
lower() functions
Posted by "Andreas Hartmann (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andreas Hartmann updated CAY-1370:
----------------------------------
Attachment: CAY-1370-Test.patch
Failing test case.
Patch base:
http://svn.apache.org/repos/asf/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished
> EJBQL: ParseException with upper() / lower() functions
> ------------------------------------------------------
>
> Key: CAY-1370
> URL: https://issues.apache.org/jira/browse/CAY-1370
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 3.1M1
> Environment: Mac OS X 10.5.8, Java 1.6
> Reporter: Andreas Hartmann
> Attachments: CAY-1370-Test.patch
>
>
> Statement: select p from Painting p where upper(p.name) like upper('foo')
> Exception:
> org.apache.cayenne.ejbql.EJBQLException: [v.3.1-SNAPSHOT ${project.build.date} ${project.build.time}] Error parsing EJB QL statement
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:24)
> at org.apache.cayenne.ejbql.EJBQLExpressionTest.testUpper(EJBQLExpressionTest.java:36)
> Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " "UPPER" "upper "" at line 1, column 32.
> 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.where_clause(EJBQL.java:1585)
> at org.apache.cayenne.ejbql.parser.EJBQL.select_statement(EJBQL.java:69)
> at org.apache.cayenne.ejbql.parser.EJBQL.parseQuery(EJBQL.java:41)
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:21)
> ... 26 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (CAY-1370) EJBQL: ParseException with upper() /
lower() functions
Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Razumovsky closed CAY-1370.
----------------------------------
Resolution: Duplicate
Thanks for reporting, but just fixed it on the trunk in CAY-1369 :)
Will be in upcoming RC2
> EJBQL: ParseException with upper() / lower() functions
> ------------------------------------------------------
>
> Key: CAY-1370
> URL: https://issues.apache.org/jira/browse/CAY-1370
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 3.1M1
> Environment: Mac OS X 10.5.8, Java 1.6
> Reporter: Andreas Hartmann
> Attachments: CAY-1370-Test.patch
>
>
> Statement: select p from Painting p where upper(p.name) like upper('foo')
> Exception:
> org.apache.cayenne.ejbql.EJBQLException: [v.3.1-SNAPSHOT ${project.build.date} ${project.build.time}] Error parsing EJB QL statement
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:24)
> at org.apache.cayenne.ejbql.EJBQLExpressionTest.testUpper(EJBQLExpressionTest.java:36)
> Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " "UPPER" "upper "" at line 1, column 32.
> 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.where_clause(EJBQL.java:1585)
> at org.apache.cayenne.ejbql.parser.EJBQL.select_statement(EJBQL.java:69)
> at org.apache.cayenne.ejbql.parser.EJBQL.parseQuery(EJBQL.java:41)
> at org.apache.cayenne.ejbql.parser.EJBQL$EJBQLDefaultParser.parse(EJBQL.java:21)
> ... 26 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.