I’ve an query class, the query is made and the result I show with System.out command but in the class that I call the query th result is null. I don’t know where I am wronging.
Query:
public CadastroProfissionalMedico listUsuarios(String Nome, String Senha, String CNPJ) {
EntityManagerFactory entMngrFctry = Persistence.createEntityManagerFactory("itcmedbr_PU");
EntityManager entMnger = entMngrFctry.createEntityManager();
entMnger.getTransaction().begin();
String hqlSelct1 = "SELECT m FROM CadastroProfissionalMedico m JOIN CadastroDeClientes c ON m.cnpj = c.cnpj"
+ " WHERE (m.apelido = :Nome AND m.senha = :Senha AND m.cnpj = :CNPJ)";
Query query = (Query) entMnger.createQuery(hqlSelct1);
query.setParameter("Nome", Nome);
query.setParameter("Senha", Senha);
query.setParameter("CNPJ", CNPJ);
CadastroProfissionalMedico usuario = new CadastroProfissionalMedico();
ArrayList<CadastroProfissionalMedico> usuarios;
usuarios = (ArrayList<CadastroProfissionalMedico>) query.getResultList();
System.out.println("Usuario: " + usuarios);
return usuario;
}
Result query:
Usuario: [CadastroProfissionalMedico(ind=9, cnpj=04.377.802/0001-76, nome=Ilo Gabriel, apelido=ilo, cremerj=540.897.450-85, coren=, senha=leao, tipo=1, celular=21-98974-5876, email=leao@email)]
Call the query:
CadastroProfissionalMedico usuario = null;
try {
usuario = (CadastroProfissionalMedico) pcdaoImpl.listUsuarios(Nome, Senha, CNPJ);
logger.info("Usuario recebido1: " + usuario);
} catch (Exception ex) {
Logger.getLogger(Login_S000.class.getName()).log(Level.SEVERE, null, ex);
}
Result of return:
Usuario recebido1: CadastroProfissionalMedico(ind=null, cnpj=null, nome=null, apelido=null, cremerj=null, coren=null, senha=null, tipo=null, celular=null, email=null)]
I’ll appreciate any assistance.
Thanks and best regards.