Tenho uma tabela chamada pessoa e tentando fazer uma consulta que retorne 2 campos mas vi que estou errando na consulta, alguém que pode dar um HELP?
public class IDAOPessoaImple implements IDAOPessoa {
@Override
public Pessoa consultaUsuario(String login, String senha) {
Pessoa pessoa = null;
EntityManager entityManager = JPAUtil.getEntityManager();
EntityTransaction transaction = entityManager.getTransaction();
transaction.begin();
pessoa = (Pessoa) entityManager.createQuery("select from Pessoa p where p.login = '" + login + "' and p.senha = '" +senha+"' ").getSingleResult();
transaction.commit();
entityManager.close();
return pessoa;
}
}
Meu erro
Message java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: from near line 1, column 8 [select from br.com.jsf.model.Pessoa p where p.login = 'chico' and p.senha = 'chico' ]
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
javax.servlet.ServletException: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: from near line 1, column 8 [select from br.com.jsf.model.Pessoa p where p.login = 'chico' and p.senha = 'chico' ]
javax.faces.webapp.FacesServlet.service(FacesServlet.java:606)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
br.com.jsf.filter.FilterAutenticacao.doFilter(FilterAutenticacao.java:34)
Root Cause
javax.faces.el.EvaluationException: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: from near line 1, column 8 [select from br.com.jsf.model.Pessoa p where p.login = 'chico' and p.senha = 'chico' ]
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:101)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
javax.faces.component.UICommand.broadcast(UICommand.java:315)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:795)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1260)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
br.com.jsf.filter.FilterAutenticacao.doFilter(FilterAutenticacao.java:34)
Root Cause