Loading a parent-childs relationship mapped with a collection I'm getting a list with several times the same parent - same pointer. Actually for each child I'm getting a 'new' parent.

The issue is for two large tables (1mio parents and over 20mio childs).

I would appreciate some help or ideas on this issue (currently join fetch is disabled).

ScrollableResult is not working for collection, bad luck as it was a good idea.

We had too disable secondary cache as it had some memory leaks - sorry no time to understand/find out why.

Mapping file :

<hibernate-mapping package="ch.iris.riskpro.tng.model.contract">
<class name="Contract_CFL">
<id name="contractID" column="CONTRACT_ID">
<generator class="increment"/>
</id>
<set name="cashflows" lazy="false" cascade="all-delete-orphan">
<key column="CONTRACT_ID"/>
<one-to-many class="ContractCashflow_CFL"/>
</set>
<property name="bookValueDate" type="timestamp" column="BOOK_VALUE_DATE"/>
<property name="contractDealDate" type="timestamp" column="CONTRACT_DEAL_DATE"/>
<property name="fxRateAtCDD" column="FX_RATE_AT_CCD"/>
<property name="fxRateAtBVD" column="FX_RATE_AT_BVD"/>
<property name="sourceSystemName" column="SOURCE_SYSTEM_NUMBER"/>
<many-to-one name="contractCurrency" class="ch.iris.riskpro.tng.model.market.Currency" lazy="false" column="CONTRACT_CURRENCY"/>
</class>

<class name="ContractCashflow_CFL" table="CONTRACT_CFL_CASHFLOW">
<id name="id" column="ID">
<generator class="increment"/>
</id>
<property name="amount" column="AMOUNT"/>
<property name="date" column="AMOUNT_DATE"/>
</class>
</hibernate-mapping>


Code :

Criteria criteria = session.createCriteria(Contract_CFL.class)
.setFetchMode("cashflows", FetchMode.JOIN);
List list = criteria.list();
iter = list.iterator();
listSize = list.size();


Result :

[0] = {ch.iris.riskpro.tng.model.contract.Contract_CFL@1822}
...
[8] = {ch.iris.riskpro.tng.model.contract.Contract_CFL@1822}
[9] = {ch.iris.riskpro.tng.model.contract.Contract_CFL@2033}
..
[17] = {ch.iris.riskpro.tng.model.contract.Contract_CFL@2033}

Hello,

I have the same problem with Hibernate 3.0.5.

When I set the fetch mode to JOIN for a collection in a criteria query, hibernate does not eleminate the duplicates produced by the join. Instead Hibernate returns each object as many times as elements are in the collection belonging to this object. With fetch mode SELECT everything works fine, but I want eager fetching.

Is this a bug? Or have I missed something in the Hibernate book and online docs?

Markus

Run it through a distinct root result transformer. Think of it in the sense of what would happen in SQL if you tried the same thing, you would get a unique row for each combination.

Thanks for your answer.

I'm just too blind, because this topic is covered in the FAQ...

Markus