You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Georgi Naplatanov (JIRA)" <ji...@apache.org> on 2009/02/11 15:18:59 UTC
[jira] Created: (OPENJPA-920) LIKE does not accept expression as
second parameter
LIKE does not accept expression as second parameter
---------------------------------------------------
Key: OPENJPA-920
URL: https://issues.apache.org/jira/browse/OPENJPA-920
Project: OpenJPA
Issue Type: Bug
Affects Versions: 1.2.0
Environment: JDK 1.6
Reporter: Georgi Naplatanov
I have simple data object :
@Id
String Id ;
@Basic
@Column(name="my_value", nullable=false, length=36)
String value ;
OpenJPA give my the following exception when execute the query:
Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
at Tester.simpleJpql(Tester.java:87)
at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Milosz Tylenda (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12673608#action_12673608 ]
Milosz Tylenda commented on OPENJPA-920:
----------------------------------------
Georgi, I believe that this is more of an enhancement request than a bug. The JPA 1 & 2 specs say:
string_expression [NOT] LIKE pattern_value [ESCAPE escape_character]
The pattern_value is a string literal or a string-valued input parameter [...]
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Georgi Naplatanov (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Georgi Naplatanov resolved OPENJPA-920.
---------------------------------------
Resolution: Invalid
It's not according specification. For this type of queries can be used LOCATE function.
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Julien Kronegg (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698760#action_12698760 ]
Julien Kronegg commented on OPENJPA-920:
----------------------------------------
Reference to JPA specifications:
- JPA 1: http://cds-esd.sun.com/ESD24/JSCDL/ejb/3.0-fr/ejb-3_0-fr-spec-persistence.pdf (pages 92-93)
- JPA 2: http://cds-esd.sun.com/ESD7/JSCDL/persistence/3.0-pfd/persistence-3_0-pfd-spec.pdf (pages 138-139)
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Milosz Tylenda (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12673687#action_12673687 ]
Milosz Tylenda commented on OPENJPA-920:
----------------------------------------
You can make this bug invalid or, if you think this lacking functionality is important, you can change the issue type from Bug to Wish, for example.
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Georgi Naplatanov (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12673673#action_12673673 ]
Georgi Naplatanov commented on OPENJPA-920:
-------------------------------------------
Hello, Milosz.
In case pattern_value do not accepts string_expression values I should make this bug invalid, right ?
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-920) LIKE does not accept expression as
second parameter
Posted by "Georgi Naplatanov (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Georgi Naplatanov updated OPENJPA-920:
--------------------------------------
Description:
I have simple data object :
@Id
String Id ;
@Basic
@Column(name="my_value", nullable=false, length=36)
String value ;
OpenJPA give my the following exception when execute the query:
SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
at Tester.simpleJpql(Tester.java:87)
at Tester.main(Tester.java:180)
was:
I have simple data object :
@Id
String Id ;
@Basic
@Column(name="my_value", nullable=false, length=36)
String value ;
OpenJPA give my the following exception when execute the query:
Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
at Tester.simpleJpql(Tester.java:87)
at Tester.main(Tester.java:180)
> LIKE does not accept expression as second parameter
> ---------------------------------------------------
>
> Key: OPENJPA-920
> URL: https://issues.apache.org/jira/browse/OPENJPA-920
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.0
> Environment: JDK 1.6
> Reporter: Georgi Naplatanov
>
> I have simple data object :
> @Id
> String Id ;
>
> @Basic
> @Column(name="my_value", nullable=false, length=36)
> String value ;
> OpenJPA give my the following exception when execute the query:
> SELECT t from MySimpleObject t WHERE ?1 like concat(t.value,'%')
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "? 1 like concat" at character 38, but expected: ["(", "*", "+", "-", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "BETWEEN", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "EXISTS", "IS", "LIKE", "MEMBER", "NOT", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
> at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)
> at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9378)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1947)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1925)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1791)
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1753)
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1556)
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1740)
> at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1727)
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:48)
> at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:149)
> at org.apache.openjpa.datacache.QueryCacheStoreQuery.newCompilation(QueryCacheStoreQuery.java:241)
> at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657)
> at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:639)
> at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:605)
> at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:667)
> at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
> at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
> at Tester.simpleJpql(Tester.java:87)
> at Tester.main(Tester.java:180)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.