Hi all, see my problem:
Code:
<class name="OpisIdent" table="OPIS_IDENT">
..
..
..
<bag cascade="all-delete-orphan" lazy="false" name="anOpisIdentLiceOrgs">
<key/>
<one-to-many class="OpisIdentLiceOrg"/>
<loader query-ref="test"/>
</bag>
...
...
<sql-query name="test">
<load-collection alias="alias1" role="OpisIdent.anOpisIdentLiceOrgs"/>
SELECT oilo.id , oilo.ID_LICE_ORG ,oilo.id_opis_ident ,
oilo.DATA_BEG ,oilo.DATA_END ,
nvl(pom.NAIM_ORG,pom.IME||' '|| pom.PREZIME ||' '|| pom.FAMILIA) names, lo.EGN_BULSTAT,lo.TIP
FROM OPIS_IDENT_LICE_ORG oilo,
LICA_ORG_OTN_JIVOTNI looj,
LICA_ORG_POM pom,
LICA_ORG lo
WHERE oilo.ID_LICE_ORG=looj.id AND
looj.ID_LICE_ORG=lo.ID AND
looj.ID_LICE_ORG = pom.ID_LICA_ORG (+) AND
pom.pom(+)=1 AND
oilo.id_opis_ident=?
</sql-query>
...
When I load main class i see that sql-query is executed correctly, all needed data is returned.
But my collection anOpisIdentLiceOrgs is empty.
What is wrong?
Thanks.