How to map query to non-entity class + entity class

Question

I know how to do query to resultClass mapping in IBatis.

How can I map the native query result to the object that is a mix of entity class and scalars in hibernate ? How can I set the parameters ?

Please Help.

axtavt · Accepted Answer · 2011-02-10 13:12:19Z

2

With Hibernate Session API, you can do it by comining addEntity() and addScalar() methods:

Query q = s.createSQLQuery(
    "select p.*, count(e.id) as c " +
    "from Project p left join Employee e on p.id = e.project_id " +
    "group by p.id")
    .addEntity(Project.class).addScalar("c");

In JPA you can do it with @SqlResultSetMapping:

@SqlResultSetMappings(
    @SqlResultSetMapping(name = "projectWithCount"
        entities = @EntityResult(entityClass = Project.class),
        columns = @ColumnResult(name = "c")))

...

Query q = s.createSQLQuery(
        "...", "projectWithCount")

answered Feb 10, 2011 at 13:12

axtavt

243k42 gold badges518 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sunny_dev Over a year ago

I am new to @SqlResultSetMappings, so can you also tell which class will this annotation entry go to? Will this annotation go into a class which is not an entity class and has 2 properties: 1 pointing to Project class and 1 pointing to int c; ?

Collectives™ on Stack Overflow

How to map query to non-entity class + entity class

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related