Erro em query JPQL - unexpected end of query

9 de julho de 2010 10 respostas

cris.t 9 de julho de 2010

Olá,

Estou tentando fazer a seguinte query JPQL:

String jpql = "SELECT u FROM Users u WHERE u.username=?;";
		Query query = getEntityManager().createQuery(jpql);
		query.setParameter(1, username);

Estou tendo a seguinte exception:

line 1:40 mismatched character ';' expecting set '1'..'9'
org.springframework.dao.InvalidDataAccessApiUsageException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT u FROM Users u WHERE u.username=?;], line 0, column -1: unexpected end of query.
Internal Exception: NoViableAltException(-1!=[797:1: comparisonExpressionRightOperand returns [Object node] : (n= arithmeticExpression | n= nonArithmeticScalarExpression | n= anyOrAllExpression );]); nested exception is java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT u FROM Users u WHERE u.username=?;], line 0, column -1: unexpected end of query.
Internal Exception: NoViableAltException(-1!=[797:1: comparisonExpressionRightOperand returns [Object node] : (n= arithmeticExpression | n= nonArithmeticScalarExpression | n= anyOrAllExpression );])

...

Caused by: java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT u FROM Users u WHERE u.username=?;], line 0, column -1: unexpected end of query.
Internal Exception: NoViableAltException(-1!=[797:1: comparisonExpressionRightOperand returns [Object node] : (n= arithmeticExpression | n= nonArithmeticScalarExpression | n= anyOrAllExpression );])

...

Caused by: Exception [EclipseLink-8028] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [SELECT u FROM Users u WHERE u.username=?;], line 0, column -1: unexpected end of query.
Internal Exception: NoViableAltException(-1!=[797:1: comparisonExpressionRightOperand returns [Object node] : (n= arithmeticExpression | n= nonArithmeticScalarExpression | n= anyOrAllExpression );])

Alguém poderi ajudar?

10 Respostas

tnaires 9 de jul. de 2010

Já tentou tirar o ponto-e-vírgula do final da consulta?

cris.t 9 de jul. de 2010

Já sim , só coloquei o ponto e virgula pra ver se mudava alguma coisa.

partenon 9 de jul. de 2010

Entao deve ser outra excecao. Pq esta que vc mandou eh especificamente sobre o “;”

Tire e veja que a excecao vai mudar.

cris.t 9 de jul. de 2010

Não, tirei o ponto-e-virgula e a exceção parece a mesma:

org.springframework.dao.InvalidDataAccessApiUsageException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [SELECT u FROM Users u WHERE u.username=?], line 0, column -1: unexpected end of query.

partenon 9 de jul. de 2010

E logo acima, onde estava isso:

Ainda esta do mesmo jeito?

cris.t 9 de jul. de 2010

Não, agora está assim:

line 1:40 mismatched character '&lt;EOF&gt;' expecting set '1'..'9'

partenon 9 de jul. de 2010

Isso esta estranho… Soh pra tentar isolar o problema, mude seu codigo para algo assim:

String jpql = "SELECT u FROM Users u WHERE u.username = :username";
// String jpql = "from Users where username = :username";   // se o acima ainda der erro, tenta este, soh para testar...
Query query = getEntityManager().createQuery(jpql);  
query.setParameter("username", username);

cris.t 9 de jul. de 2010

Funcionou desta forma!! Obrigada!

Mas qual era o problema?

cris.t 9 de jul. de 2010

Usando da forma que vc comentou:

String jpql = "from Users where username = :username";

Ocorre a seguinte exceção:

org.springframework.dao.InvalidDataAccessApiUsageException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [from Users where username = :username], line 1, column 0: unexpected token [from].
Internal Exception: NoViableAltException(32!=[197:1: document : (root= selectStatement | root= updateStatement | root= deleteStatement );]); nested exception is java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [from Users where username = :username], line 1, column 0: unexpected token [from].
Internal Exception: NoViableAltException(32!=[197:1: document : (root= selectStatement | root= updateStatement | root= deleteStatement );])

...

Caused by: java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [from Users where username = :username], line 1, column 0: unexpected token [from].
Internal Exception: NoViableAltException(32!=[197:1: document : (root= selectStatement | root= updateStatement | root= deleteStatement );])

Mas da primeira forma funcionou:

tnaires 9 de jul. de 2010

No JPQL, toda consulta válida deve começar com SELECT.
No HQL, que é a linguagem de consulta do Hibernate, é permitido omitir a cláusula SELECT. O erro aconteceu porque você está usando EclipseLink, e não Hibernate.

Criado 9 de julho de 2010

Ultima resposta 9 de jul. de 2010

Respostas 10

Participantes 3

10 Respostas

Topicos relacionados