Hibernate Community • View topic - HQL syntax for fetch

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL syntax for fetch

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

bluespud

Post subject: HQL syntax for fetch

Posted: Fri Sep 29, 2006 5:46 am

Newbie

Joined: Thu Aug 31, 2006 7:56 am
Posts: 14

I use the following to force the read of Rep on read on Order.

Code:

from Order ord left join fetch ord.Rep rep

I now want to force the read of RepGroup (Order.Rep.RepGroup), but I dont know the syntax for the second 'join fetch'

Top

wykoff

Post subject:

Posted: Fri Sep 29, 2006 7:50 am

Beginner

Joined: Thu Aug 24, 2006 6:01 am
Posts: 49
Location: sophia-antipolis, France

You can just add a join fetch one after the other for each relation you want to fetch:

Code:

from Order ord 
left join fetch ord.Rep rep
left join fetch ord.Rep.RepGroup

You just have to be careful to use join fetch on only one collection if any.

Top

bluespud

Post subject:

Posted: Thu Oct 05, 2006 5:45 am

Newbie

Joined: Thu Aug 31, 2006 7:56 am
Posts: 14

Perfect, thanks.

Top

Page 1 of 1

[ 3 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