Using JPA-Hibernate

ORM.XML

<package>com.datesite.user</package>

<entity class="DateUser">
<table name="DATEUSER"/>
<attributes>
<id name="id">
<generated-value strategy="IDENTITY"/>
</id>
<basic name="userName">
<column name="USERNAME"/>
</basic>
<basic name="password">
<column name="PASSWORD"/>
</basic>
<basic name="email">
<column name="EMAIL"/>
</basic>
<basic name="tosVersion">
<column name="TOSVERSION"/>
</basic>
<transient name="all"/>
</attributes>
</entity>

Entity Manager

@Repository
@Transactional
public class EntityManagerDateUser implements DateUserManagerI, Serializable {

private EntityManager em;

public EntityManagerDateUser() {

}

@PersistenceContext
public void setEntityManager(EntityManager entityManager) {
this.em = entityManager;
}

@Transactional(readOnly = true)
@SuppressWarnings("unchecked")
public List getAll() {

return this.em.createQuery("SELECT ID,USERNAME,PASSWORD,EMAIL, TOSVERSION FROM DATEUSER du").getResultList();

}
}

Gives Exception

java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: DATEUSER is not mapped [SELECT ID,USERNAME,PASSWORD,EMAIL, TOSVERSION FROM DATEUSER du]

Scratching my Head why isn't Hibernate finding the Mapping?. Note this is a JPA Mapping.

Any help appreciated.
Thanks
Barry

You should not use table/column names in HQL statments, but class/property names. Eg. try something like this instead:



Note that this will return a List with an Object[] in each element. If you want DateUser objects you should simply do:

That did the trick. Many thanks!