Metodo de pesquisa para a classe JpaController

1 resposta
leandrognaf

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;
    }
a classe que estou usando e essas
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.

1 Resposta

Z111

experimenta

Criado 17 de junho de 2011
Ultima resposta 17 de jun. de 2011
Respostas 1
Participantes 2