My xml configuration is like this:
<set name="bidPackage" lazy="false">
<key column="BID_ID"/>
<one-to-many class="com.bsteel.baointl.interbid.model.BidPackageModel"/>
</set>

h2 will select main table at first then select another table (BidPackageModel)by every result record in main table. It will generate many sql. Can I config something to let h2 select master and slave table together then auto split records into correct java class?

use outer-join=true and enable outer join fetching in the hibernate config. Or use JOIN FETCH in HQL

Can attrubite out-join exist in element set?
I wrote xml as the following:
<set name="bidPackage" lazy="false" outer-join="true">
<key column="BID_ID"/>
<one-to-many class="com.bsteel.baointl.interbid.model.BidPackageModel"/>
</set>
But h2 throws Exception:
Error parsing XML: XML InputStream(11) Attribute "outer-join" must be declared for element type "set".

I used h2.1 rc1

Yes, and from a long time ago. Your DTD loading sucks.

Do you mean my h2 loading a wrong DTD? I don't think I changed anything about DTD. Where is default DTD h2 loaded and can you give me any suggestion to fix this problem?

Upgrate to latest hibernate, use xerces which enable EntityResolver.

hi,

use hibernate 2.0.
have a mapping as described in the other mails in the topic.

i know i can update hibernate. the question is if i stay with the now hibernate, how can i deal with the problem?

globally i have set hibernate.use_outer_join to true. but it seems not useful. hibernate generates many SQL statements to find fathers and children.

can anyone help? many thanx!


--bs

Check lazy="true" and proxy values of the mapping