I'm trying to map a non-entity pojo with the createNativeQuery method of entityManager of jpa. By using something like this
@SqlResultSetMapping(name="ResultMapping",
classes={
@ConstructorResult(
targetClass=Employee.class,
columns={
@ColumnResult(name="empID", type=Long.class),
@ColumnResult(name="empName", type=String.class),
}
)
}
)
public class Loader{
private EntityManager em;
public void load(){
Query query = em.createNativeQuery("select empID, empName from employee", "ResultMapping");
List<Employee> = query.getResultList();
}
}
public class Employee{
private long empID;
private String empName;
public Employee(long empid, String empname)
{
this.empID = empid;
this.empName = empname;
}
}
I getting unknown SqlResultSetMapping ResultMapping error
Where I am supposed to put SqlResultSetMapping so that the entityManager will able to recognize it?
