Hibernate Community • View topic - Multiple association on same entity with hibernate Criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Multiple association on same entity with hibernate Criteria

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

XrayPapa

Post subject: Multiple association on same entity with hibernate Criteria

Posted: Tue Oct 21, 2014 9:06 am

Newbie

Joined: Tue Oct 21, 2014 8:59 am
Posts: 1

Hi all ! :)

I want to use this query in criteria

Code:

SELECT a.a_id, b.b_id, b.b_description, sum(c1.c_score) AS score1, sum(c2.c_score) AS score2
FROM b, a, d, c

LEFT OUTER JOIN c AS c1 ON c1.c_id = c.c_id AND c1.c_comment = 'good'
LEFT OUTER JOIN c AS c2 ON c2.c_id = c.c_id AND c2.c_comment = 'nogood'

WHERE b.b_Id = d.d_id
AND d.d_id = c.c_id
AND c.c_foreignkey_a_id = a.a_id

GROUP BY a.a_id, b.b_id, b.b_description

My problem, in this case, is the 2 associations on the same entity ( C => C1 / C => C2).

And I want to know if there is a way to do this with criteria ?

Thanks ! - XP

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum