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);

,

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: