Preventing multiple queries

HB_newbie · **Joined:** Fri Aug 04, 2006 6:09 am **Posts:** 18

Hi,

I have set up a many-to-one mapping between my entities (Office and Country).

When i retrieve a list of Offices, I noticed that Hibernate is issuing a query per row to get the country instance.

Is there a way to get all the data in less round trips?

Cheers

R

scarface · **Joined:** Sun Jun 04, 2006 1:58 am **Posts:** 136

http://www.hibernate.org/hib_docs/v3/re ... mance.html

also try reading chapter 7 of HIA if you have that book

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

use join fetch in your HQLs, refere to documentatins.

HB_newbie · **Joined:** Fri Aug 04, 2006 6:09 am **Posts:** 18

Hi,

thanks for that. I have tried the following:

Code:

<many-to-one name="country" column="country_id_fk" not-null="true" lazy="false" fetch="join"/>

But that has not helped. Perhaps disabling the lazy fetching is affecting the query.

Cheers

R