Pessoal,
Estou com um problema na hora de rodar um query baseada em um SqlResultSetMapping.
Erro:org.hibernate.MappingException: Unknown SqlResultSetMapping [AAA]
Meu Stateless Bean:
@Stateless
@SqlResultSetMapping(name="AAA",
entities={
@EntityResult(entityClass=com.certification.entity.ejb.User.class,
fields={
@FieldResult(name="cpf", column="cpf"),
@FieldResult(name="name", column="name")
}
)
},
columns={
@ColumnResult(name="cep")
}
)
public class StatelessBean implements StatelessBeanLocal, StatelessBeanRemote {
@PersistenceContext
EntityManager em;
...
...
...
public Object joinUserWithCEP(Integer cpf) {
try {
Query q = em.createNativeQuery(
"SELECT u.cpf AS cpf, " +
"u.name AS name, " +
"e.cep AS cep, " +
"FROM User u, Endereco e " +
"WHERE u.cpf = "+cpf+" ",
"AAA");
return q.getSingleResult();
}
catch (Exception e) {
System.out.println("Erro:"+e.getMessage());
return null;
}
}
}
Chamando a funcao do session bean a partir de um servlet:
StatelessBeanRemote sbr = (StatelessBeanRemote) initialContext.lookup("SCBCD/"+StatelessBean.class.getSimpleName()+ "/remote");
Object cepUser = sbr.joinUserWithCEP(new Integer(1234));
Alguém poderia me dar uma dica?