Hibernate Native SQL

53.1K 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: Mapping Non-managed entities via result transformer

Custom Transformers!

In case the columns returned from the result set names does not match the names on the mapped JavaBean attributes, and then we opt for the explicit transformation.

A quick sample. Check out the JAVA class and SQL file

// {
package com.tu.nativesqlsample;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.hibernate.Session;
import com.tu.hibernate.HibernateUtil;
public class NativeQueryParameterBinding {
    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();
            logger.info(dash);
            // 2.2 Native query - parameter binding
            parameterBinding(session);
        } catch (Exception e) {
            logger.warning(e.toString());
        } finally {
            if (session != null) {
                session.close();
            }
        }
        HibernateUtil.shutdown();
    }
    @SuppressWarnings("unchecked")
    public static void parameterBinding(Session session) {
        // }
        List<Object[]> users = session.createNativeQuery(
                "SELECT user_Id,name,username,isadmin,region_id,team_id,domain_id FROM user u where u.user_id=?")
                .setParameter(1, 1).list();
        users.stream().forEach(objects -> {
            Integer id = (Integer) objects[0];
            String name = (String) objects[1];
            System.out.println(String.format("Info: User[ %d, %s ]", id, name));
        });
    }
}

Here, we would implement ResultTransformer interface and override the transformTuple and transformList methods.
The actual object building logic is present in the transformTuple method. The input argument for the method are an object array of the column alias (aliases) and respective column values (tuple).
Please note, this has been depreciated since hibernate v5.2, with no new approach being proposed- https://discourse.hibernate.org/t/hibernate-resulttransformer-is-deprecated-what-to-use-instead/232

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

The #1 tech hiring platform

SCREENING INTERVIEWING

ABOUT US CAREERS PRIVACY FAQ

Custom Transformers!

Python program(for beginners)

Exercice Javascript

Lista de Exercícios de Kotlin

Beginner Python Concepts