Hibernate Community • View topic - Implementing RIGHT and LEFT OUTER JOIN using HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Implementing RIGHT and LEFT OUTER JOIN using HQL

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

sekharsp

Post subject: Implementing RIGHT and LEFT OUTER JOIN using HQL

Posted: Sat Aug 23, 2008 1:37 pm

Newbie

Joined: Sat Aug 23, 2008 1:30 pm
Posts: 4

Hi ,

I implemented JOIN using HQL. When i tried to use session.enablefilter...it didnt work .

Can someone tell me whether it is possible to use session.enablefilter on HQL join queries?

Is it possible to create join querieis using CRITERIA ...can someone give me a simple example ?

Top

nordborg

Post subject:

Posted: Sun Aug 24, 2008 4:28 pm

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

I think filters are only applied to the root entity in the query. Eg. only the entity following the "from" part. For example:

Code:

from A a join a.b b

The filter is only applied to A, not B.

Top

sekharsp

Post subject: Thanks for the reply

Posted: Sat Aug 30, 2008 8:52 am

Newbie

Joined: Sat Aug 23, 2008 1:30 pm
Posts: 4

Thanks

Top

brut

Post subject:

Posted: Tue Sep 02, 2008 3:09 am

Newbie

Joined: Tue Sep 02, 2008 2:44 am
Posts: 1
Location: Ukrain, Ivano-Frankivsk

Quote:

The filter is only applied to A, not B.

Can you tell me what to do if I want to filter B.
To make Hibernate generate something like this:

Code:

SELECT a.id, b.name 
FROM table1 a LEFT JOIN table2 b ON (a.id = b.foreingId AND b.locale='EN');

Thanks.[/code]

Top

Page 1 of 1

[ 4 posts ]

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