Hibernate Native SQL


Open Source Your Knowledge, Become a Contributor

Technology knowledge has to be shared and made accessible for free. Join the movement.

Create Content
Next: Use parameter binding in native SQL queries


Hibernate provide option to execute native SQL queries through the use of SQLQuery object. Hibernate SQL Query is very handy when we have to execute database vendor specific queries that are not supported by Hibernate API. For example query hints or the CONNECT keyword in Oracle Database.

Considering the below entity relationship. We would be discussing the below points;

Alt text

1  Creating Native queries with createNativeQuery
2  Use parameter binding in native SQL queries.
3  Adding scalars
4  Joins
      4.1 Native Joins
      4.2 Adding joins with entity mapping. This is for adding entity via eager loading
5  Iterating through the result set and constructing the Beans
      5.1 Querying with Entity mapping
      5.2 basic Result set mapping using @SqlResultSetMapping
      5.3 Mapping Non-managed entities via result transformer
6  Using @NamedNativeQuery

Open Source Your Knowledge: become a Contributor and help others learn. Create New Content