Discussion :

[aloha]

Bonjour,

Je développe des EJB3 session stateless sous weblogic 10.
Lorsque j'execute la query:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
select model from ProductList model where (UPPER(model.productListName) LIKE UPPER('list'))

J'obtiens une erreur:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
 
<6 nov. 2007 09 h 50 CET> <Info> <EJB> <BEA-010051> <EJB Exception occurred during invocation from home: weblogic.ejb.container.internal.StatelessEJBHomeImpl@859f0a threw exception: <4|false|0.9.7> org.apache.openjpa.persistence.ArgumentException: An error occurred while parsing the query filter 'select model from ProductList model where model.productListName IS NOT NULL AND (UPPER(model.productListName) LIKE UPPER('list'))'. Error message: <4|false|0.9.7> org.apache.openjpa.kernel.jpql.ParseException: Encountered "UPPER ( model . productListName ) LIKE UPPER" at character 82, but expected: ["(", ")", "+", "-", ".", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "UPDATE", "UPPER", "WHERE", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
<4|false|0.9.7> org.apache.openjpa.persistence.ArgumentException: An error occurred while parsing the query filter 'select model from ProductList model where model.productListName IS NOT NULL AND (UPPER(model.productListName) LIKE UPPER('list'))'. Error message: <4|false|0.9.7> org.apache.openjpa.kernel.jpql.ParseException: Encountered "UPPER ( model . productListName ) LIKE UPPER" at character 82, but expected: ["(", ")", "+", "-", ".", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "UPDATE", "UPPER", "WHERE", <BOOLEAN_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL>].
	at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1656)
	at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:1636)
	at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:44)

Sans le UPPER je n'ai pas d'erreur.Quelqu'un a-t-il déjà testé cette fonction?

[djo.mos]

Bonjour.
Je crois que c'est le second upper combiné avec le LIKE qui cause le problème: J'arrive à reproduire cette erreur avec TopLink, et ça marche à merveille si je vire le second UPPER ou le LIKE.
Bref, LIKE n'accèpte pas que son paramètre soit une fonction.

Bonne chance.

[Benouze]

Peut-être :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

LIKE UPPER("list")

??

[aloha]

La solution est d'utliser la fonction "UPPER" JPQL pour la première partie de mon LIKE

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
select model from ProductList model where UPPER(model.productListName) LIKE ...

et d'utiliser la fonction .toUpperCase() de java pour la seconde partie du LIKE

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
.... LIKE 'LIST'

Merci pour votre aide.