about a query

tads · **Posted:** Tue Aug 23, 2005 3:58 pm

Hibernate version: 2.1.4

Name and version of the database you are using: Oracle 9i

Hi all,

I´m with a problem with LazyInitializationException,
when I try the following query:

Code:

select c from Company c
left join c.companyDocuments cDoc
left join fetch cDoc.documentType cDocTp
where cDoc.nbDocument = '111222333'
and     cDocTp.idDocumentType = 4

Each company can to have one or more CompanyDocument (List).
In this case, all companies have 2 documents,
where one documentType 1 and one documentType 4.
So, when I try execute the above query,
the hibernate loads 2 companyDocument for each company, but
the documentType is only loaded when the idDocumentType = 4.

How can I load the all documentType in this case?

thanks!

ramnath · **Posted:** Tue Aug 23, 2005 11:37 pm

Hi
Check this out.
--------------------------
Hibernate ignores my outer-join="true" setting and fetches an association lazily, using n+1 selects!
HQL queries always ignore the setting for outer-join defined in the mapping document. This setting applies only to associations fetched using get() or load(), Criteria queries, and graph navigation. If you need to enable eager fetching for a HQL query, use an explicit LEFT JOIN FETCH.

Note also that Hibernate does not support outer join fetching of more than one many-valued association in the same query.
------------------------

Associations have to be specified in your HQL, otherwise they will not get loaded.

Read up "Hibernate ignores my outer-join="true" setting and fetches an association lazily, using n+1 selects!"
Also look in to this forum.

http://forum.hibernate.org/viewtopic.ph ... highlight=

tads · **Posted:** Wed Aug 24, 2005 7:44 am

ramnath,

I did many queries, but query like this not yet.
Very cool.

thank you very much!

[]´s

tads · **Posted:** Mon Sep 05, 2005 10:26 am

Hi,

Using the following query:

Code:

select c from Company c
left join fetch c.companyDocuments cDoc
left join fetch cDoc.documentType cDocTp
where  cDocTp.idDocumentType = 4 

Only companyDocuments with idDocumentType = 4 is returned.

How can I retrieve companies with ALL companyDocuments, but with
idDocumentType = 4 ??

thanks

athu9999 · **Joined:** Mon Mar 28, 2005 12:58 pm **Posts:** 27

Use the "with" for the appropriate join. I'm not sure if this is exactly the solution but use it as a sample:

Code:

select c from Company c
left join fetch c.companyDocuments cDoc
left join fetch cDoc.documentType cDocTp with cDocTp.idDocumentType = 4 