Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is Nested Join possible, mapping a POJO to multiple tables.

 
Nishant Varma
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.
I am trying to map a POJO LoanSearchDTO.java to multiple tables.
Tables LOAN_ST and LOAN_CONT_ALLTN are associated to table LOAN through ID_LOAN.
Table CASH_CONT is associated to table LOAN_CONT_ALLTN through ID_LOAN_PCH_CONT.
This means tables LOAN and CASH_CONT are associated through table LOAN_CONT_ALLTN
(a kind of transitive association)
I could map all tables to Loan through ID_LOAN using Join, however am struggling to Join CASH_CONT.

My mapping file looks as follows:-
<hibernate-mapping>
<class name="LoanSearchDTO" table="LOAN">
<id name="LoanId" type="long">
<column name="ID_LOAN" />
<generator class="assigned" />
</id>
<property name="borrowerLastName" column="NAME_BORR_LST" type="string"/>

<join table="LOAN_ST">
<key column="ID_LOAN"/>
<property name="loanStatusCode" column="CD_LOAN_ST" type="int"/>

</join>

<join table="LOAN_CONT_ALLTN">
<key column="ID_LOAN"/>
<property name="contractNumber" column="ID_LOAN_PCH_CONT" type="long"/>
</join>
<hibernate-mapping>

Question: how do I specify mapping to CASH_CONT table. I tried Nested Join like below however that does not seem to
work.
This does not work:
<join table="LOAN_CONT_ALLTN">
<key column="ID_LOAN"/>
<property name="contractNumber" column="ID_LOAN_PCH_CONT" type="long"/>
<join table="CASH_CONT">
<key column="ID_LOAN_PCH_CONT"/>
<property name="contractExpiryDate" column="DT_CONT_EXPTN" type="Date"/>
</join>
</join>

Is there any other approach?

Would really appreciate any help. Thank You!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic