Hi, All,
I am new to hibernate, please help. I want to map different tables to one class like this
Tables:
1)Loan:
-loanID
-currentBalance
2)Address :
- addressID
- street
- citystatezip
3)Property:
- propertyID;
- addressID;
- loanID;
I create single POJO class AccountView which contains fields from ALL tables.
public class AccountView{
long loanID;
double currentBalance;
Address address;
}
i also have a class Address in a different folder
public class Address{
long addressID;
String street;
String citystatezip;
}
I did my hibernate mapping for AccountView as following:
<hibernate-mapping>
<class name="com.myaccount.AccountView" table="Loan">
<cache usage="read-only"/>
<id name="loanID" type="long" unsaved-value="-1">
<column name="loanID" sql-type="long" not-null="true"/>
<generator class="assigned"/>
</id>
<property column="currentBalance" name="currentBalance" not-null="false" type="double"/>
<set name="address" table="PROPERTY" cascade="all">
<key column="loanID" />
<many-to-many column="addressID" class="com.myprofile.Address" />
</set>
</class>
</hibernate-mapping>
But it gives me errors....
Please suggest me how to do hibernate mapping(Mapping *.hbm.xml file) in this case.
Thanks in Advance.
