Hibernate Native SQL

vembubalaji

61.1K views

GitHub

Open Source Your Knowledge, Become a Contributor

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

Create Content

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

// {
        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.

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

Open Source Your Knowledge, Become a Contributor

5/8 Adding joins with entity mapping

Adding joins with entity mapping.

PYTHON: BEGINNER QUIZ (10 Questions)

PYTHON STRING METHODS: center(), rjust() and ljust().

Stored Procedures con T-SQL

Python from Zero to Hero