Dear hibernaters,

I have a table (USER_EVENT) with many-to-one relationships to some dictionaries. I want to load all records from this table along with the dictionary values. The straightforward:

List eventList = session.find("from UserEvent");

does not use outer joins and does one query for each dictionary value.

On the other hand,

session.load(UserEvent.class, new Long(900));

does use outer joins which confirms that the configuration is fine.

Is this the expected behaviour? What should I do to enable outer joins when fetching a list?

Thanks,

Bogdan Calmac.

OK, after some more invesigation it seems that

List eventList = session.find("from UserEvent ue left join ue.topic");

does the job.

Is there any way to have hibernate detect the relationships as when calling load()? Something like loadAll()?

I would prefer to keep the relationships in the hibernate configuration, it makes the code easier to maintain.

Thanks,

Bogdan Calmac