Posts Tagged Annotations

Hibernate Annotations Named native Query


Problem: How to use named native queries in Hibernate/JPA Annotated Entities

Solution:

In the entity class, you can use these below annotations. Continuing with the earlier post, regarding the oracle connect sql, if chosen to

use the sql from an entity will look like below

@Entity
@SqlResultSetMapping(name = "implicit", entities = @EntityResult(entityClass = pakagepath.Employee.class))
@NamedNativeQuery(name = "namednativeqry", query = "select * from customer start with manager_id = :mgrId connect by prior emp_id = manager_id D relationship_cd = ‘IS MANAGER OF’", resultSetMapping = "implicit")

From the code, this can be called using the 

session.getNamedQuery("nativenamedqry").setString("mgrId",334);

,

Leave a comment