Back
Close

Hibernate Native SQL

vembubalaji
4,173 views
01 Hibernate Native SQL
Hibernate Native SQL - Introduction Use parameter binding in native SQL queries Adding scalars Native Joins Adding joins with entity mapping Basic Result set mapping using @SqlResultSetMapping Mapping Non-managed entities via result transformer Mapping Non-managed entities via result Custom Transformer
Previous: Native Joins Next: Basic Result set mapping using @SqlResultSetMapping

Adding joins with entity mapping.

  • We can also use addEntity() and addJoin() methods to fetch the data from associated table using tables join. The above query can be re-written as following;
A quick sample. Check out the JAVA class and SQL file
// { autofold
package com.tu.nativesqlsample;
import java.util.List;
import java.util.logging.Logger;
import org.hibernate.Session;
import com.tu.hibernate.HibernateUtil;
import com.tu.hibernate.entity.Team;
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  • Notice the second query, which fetches the Domain details. This is the eager Loading of the requested object
  • [aliasname].* is used to return all properties of an entity. When we use addEntity() and addJoin() with join queries like above it returns both the objects, as shown above.
Create your playground on Tech.io
This playground was created on Tech.io, our hands-on, knowledge-sharing platform for developers.
Go to tech.io
Suggested playgrounds

ISART - Python - Part 1

By
Plimsky
1,704
52

Tutoring

By
Unnamed contributor
4,297
75

Creating Web API in ASP.NET Core 2.0

By
CarloHerzl
43.2K
23

How to build a chatbot in less than 50 lines of code

By
[CG]Maxime
7,221
44
codingame x discord
Join the CodinGame community on Discord to chat about puzzle contributions, challenges, streams, blog articles - all that good stuff!
JOIN US ON DISCORD
Online Participants