I set up a SqlResultMapping for the User entity.
@SqlResultSetMapping(name="User", entities={
@EntityResult(entityClass=User.class, fields = {
@FieldResult(name="userid", column="userid"),
@FieldResult(name="username", column="username")
})}
)
@NamedNativeQuery(name="GetUsers",
query="select userid, username from user",
resultSetMapping="User")List userList = em.createNamedQuery("GetUsers").getResultList();User user = (User) userList.get(0)