Pessoal estou tentando criar um metodo na classe JpaController para procurar uma linha na tabela
o metodo e esse
public List<Login> ProcuraUsuario(){
EntityManager em = emf.createEntityManager();
Query query = em.createQuery("select * from Login");
List<Login> logins = query.getResultList();
return logins;
}
import controller.LoginJpaController;
import java.util.List;
import model.Login;
public class TestaLista {
public static void main (String [] args){
LoginJpaController lc = new LoginJpaController();
List<Login> logins = lc.ProcuraUsuario();
for(Login l : logins){
System.out.println("Usuario: " +l.getLogUsuario());
}
}
}
e o erro e esse
nit:
deps-module-jar:
deps-ear-jar:
deps-jar:
library-inclusion-in-archive:
library-inclusion-in-manifest:
Compiling 1 source file to C:\Documents and Settings\User\Meus documentos\NetBeansProjects\JspNeriMenta\build\web\WEB-INF\classes
Note: C:\Documents and Settings\User\Meus documentos\NetBeansProjects\JspNeriMenta\src\controller\LoginJpaController.java uses unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
compile:
compile-test-single:
run-test-with-main:
Exception in thread "main" java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
[EL Info]: 2011-06-17 09:10:07.609--ServerSession(17764792)--EclipseLink, version: Eclipse Persistence Services - 2.0.2.v20100323-r6872
Exception Description: Syntax error parsing the query [select * from Login], line 1, column 7: unexpected token [*].
[EL Info]: 2011-06-17 09:10:08.656--ServerSession(17764792)--file:/C:/Documents and Settings/User/Meus documentos/NetBeansProjects/JspNeriMenta/build/web/WEB-INF/classes/_JspNeriMentaPU login successful
Internal Exception: NoViableAltException(91!=[361:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1328)
at controller.LoginJpaController.ProcuraUsuario(LoginJpaController.java:136)
at TestaLista.main(TestaLista.java:10)
Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing the query [select * from Login], line 1, column 7: unexpected token [*].
Internal Exception: NoViableAltException(91!=[361:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
at org.eclipse.persistence.exceptions.JPQLException.unexpectedToken(JPQLException.java:372)
at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.handleRecognitionException(JPQLParser.java:319)
at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.addError(JPQLParser.java:245)
at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.reportError(JPQLParser.java:362)
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:2071)
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectItem(JPQLParser.java:1351)
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectClause(JPQLParser.java:1266)
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectStatement(JPQLParser.java:352)
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.document(JPQLParser.java:276)
at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.parse(JPQLParser.java:133)
at org.eclipse.persistence.internal.jpa.parsing.jpql.JPQLParser.buildParseTree(JPQLParser.java:94)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:198)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:173)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:125)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:109)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1326)
... 2 more
Caused by: NoViableAltException(91!=[361:1: selectExpression returns [Object node] : (n= aggregateExpression | n= scalarExpression | OBJECT LEFT_ROUND_BRACKET n= variableAccessOrTypeConstant RIGHT_ROUND_BRACKET | n= constructorExpression | n= mapEntryExpression );])
at org.eclipse.persistence.internal.jpa.parsing.jpql.antlr.JPQLParser.selectExpression(JPQLParser.java:1992)
... 13 more
Java Result: 1
CONSTRUÍDO COM SUCESSO (tempo total: 4 segundos)
Ja agradeço a atenção de vc6.