Erro em query JPQL - unexpected end of query

Olá,

Estou tentando fazer a seguinte query JPQL:

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?

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

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

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

Tire e veja que a excecao vai mudar.

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

E logo acima, onde estava isso:

Ainda esta do mesmo jeito?

This message was edited 1 time. Last update was at 09/07/2010 11:38:10

Não, agora está assim:

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

Funcionou desta forma!! Obrigada!

Mas qual era o problema?

This message was edited 1 time. Last update was at 09/07/2010 11:59:49

Usando da forma que vc comentou:

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:

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.

Notícias, artigos e o maior fórum brasileiro sobre Java