create query join hibernate which returns multiple objects

Question

I am currently doing the following:

 Query q = session.createQuery("select x,s.id from com.package.IdLookupHDO x JOIN com.package.SourceDataHDO s ON x.identifier = s.sourcePrimaryIdentifier");
        for (Object obj : q.list()){

        }

I think this join query will work without a problem. However I expected the query to give back object arrays in the list method because I have requested two things in my select (IdLookupHDO and id). I have searched around and cannot find an answer but how can I retrieve both selected objects?

v.ladynev · Accepted Answer · 2016-03-29 08:42:45Z

3

You don't need on if you have a corresponding association in your persistent classes.

Query q = session.createQuery("select x,s.id from IdLookupHDO x join x.sourceAssociation s");

This query will return the List<Object[]>

List<Object[]> result = (List<Object[]>)q.list();

for (Object[] obj : result){
  // obj[0] is x
  // obj[1] is s.id
}

answered Mar 29, 2016 at 8:42

v.ladynev

20.1k9 gold badges50 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

create query join hibernate which returns multiple objects

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related