Hibernate Community • View topic - How to join the same association twice?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to join the same association twice?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

janpaet

Post subject: How to join the same association twice?

Posted: Thu Feb 19, 2015 12:06 pm

Newbie

Joined: Sat Sep 18, 2010 3:16 am
Posts: 5

Hi all,
I'm looking for a suitable approach to join the same association twice with Hibernate Critera.

In this case I’d like to join entity B twice with entity A.
B is a OneToMany-Set in A.

The pure SQL-Statement looks like this:

Code:

SELECT
   a.id,
   b1.attribute1
   b2.attribute2
FROM
   A AS a
   INNER JOIN B AS b1 ON a.id = b1.a_id
   INNER JOIN B AS b2 ON a.id = b2.a_id

Is there anybody who could help?
Thanks in advance,
janpaet

Top

Jofix

Post subject: Re: How to join the same association twice?

Posted: Thu Mar 05, 2015 6:28 am

Newbie

Joined: Thu Mar 05, 2015 6:10 am
Posts: 1

Hello,
did you solve your problem?
I'm trying to do the something similar