openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Georgi Naplatanov (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-573) JPQL: The combination LIKE ESCAPE does not accept parameters
Date Thu, 17 Apr 2008 15:33:21 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12590063#action_12590063
] 

Georgi Naplatanov commented on OPENJPA-573:
-------------------------------------------

Thank you, Catalina. 

This patch works for me.
In case i want to set parameter for ESCAPE function what i should to change in JPQL.jjt ?
I suppose that something should be changed in the following lines:

void escape_character() #ESCAPECHARACTER :
{ Token t; }
{
	t = <STRING_LITERAL> { jjtThis.setToken (t); }
}

?

Thank you very much.

> JPQL: The combination LIKE ESCAPE does not accept parameters
> ------------------------------------------------------------
>
>                 Key: OPENJPA-573
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-573
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.0.2, 1.1.0
>         Environment: SUN JDK 1.6.0.6 (AMD64) for Linux
>            Reporter: Georgi Naplatanov
>
> If i use constants like this :
> SELECT object FROM MyObject object WHERE object.path LIKE '%|_%' ESCAPE '|'
> all is ok, but if I want to use parameters - exception is thrown.
> Example:
> @Entity
> @Table(name="simple_object")
> public class MySimpleObject {
> 	@Id
> 	String Id ;
> 	
> 	@Basic
> 	@Column(name="value", nullable=false, length=36)
> 	String value  ;
> .....................
> .......................
> EntityManager em = emf.createEntityManager() ;
> Query q = em.createQuery("SELECT x FROM MySimpleObject x WHERE x.value LIKE ?1 ESCAPE
'|'") ;
> q.setParameter(1, "%|_%") ;
> List<MySimpleObject> res = q.getResultList() ;
> Exception in thread "main" <openjpa-1.1.0-SNAPSHOT-r422266:648359 nonfatal user error>
org.apache.openjpa.persistence.ArgumentException: Encountered "ESCAPE" at character 54, but
expected: ["AND", "GROUP", "HAVING", "OR", "ORDER", <EOF>].
> 	at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9499)
> 	at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:9376)
> 	at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:75)
> 	at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1733)
> 	at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1720)
> 	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:239)
> 	at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:656)
> 	at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:638)
> 	at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:604)
> 	at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:666)
> 	at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1486)
> 	at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
> 	at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:227)
> 	at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:277)
> 	at Tester.testEscape(Tester.java:75)
> 	at Tester.main(Tester.java:93)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message