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)