Hibernate Native SQL

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

Create your playground on
This playground was created on, our hands-on, knowledge-sharing platform for developers.
Go to