Hibernate Native SQL

59.3K views

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

// {
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;
import com.tu.hibernate.entity.User;
public class NativeQueryNativeJoinWithEntity {
    static Logger logger = Logger.getLogger(NativeQueryNativeJoinWithEntity.class.getName());
    static String dash = "--------------------------------------------------------------";
    public static void main(String[] args) {
        Session session = null;
        try {
            session = HibernateUtil.getSessionFactory().openSession();
            // Mapping Native JOIN query to Entities
            nativeJoinWithEntity(session);
        } catch (Exception e) {
            logger.warning(e.toString());
        } finally {
            if (session != null) {
                session.close();
            }
        }
        HibernateUtil.shutdown();
    }
    @SuppressWarnings("unchecked")
    public static void nativeJoinWithEntity(Session session) {
        logger.info(dash);
      // }
        List<Object[]> usersJoin = session
                .createNativeQuery(
                        "select u.*, t.* from user u left outer join team t on u.team_id=t.team_id  where u.user_id=?")
                .addEntity("u", User.class).addJoin("t", "u.team").setParameter(1, 1).list();
        usersJoin.stream().forEach(object -> { // The user's object list would contain a User instance and a
                                                // "joined"
                                                // team instance.
            User userJoin = (User) object[0];
            logger.info("User - " + userJoin.getName());
            logger.info("User Domain - " + userJoin.getDomain().getDomainName());

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

ABOUT US CAREERS PRIVACY FAQ BLOG

The #1 tech hiring platform

SCREENING INTERVIEWING

Adding joins with entity mapping.

Python from Zero to Hero

StockPrice Max Profit

La courbe du Dragon - S5

Exercice Javascript