Hi All,

I am using the joined subclass in hibernate mapping. The following are the sample mapping file I used.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<joined-subclass entity-name="Asset_Holding" extends="Data"
table="RT_DATA_ASSET_HOLDING" dynamic-update="true" dynamic-insert="true">

<key column="ID"/>
<property name="MACAddress" type="string" column="MACADDRESS" />
<property name="vendor_order" type="string" column="VENDOR_ORDER" />
<property name="arbtry_rack_exist_flag" type="string" column="ARBTRY_RACK_EXIST_FLAG" />
</joined-subclass>
</hibernate-mapping>



This mapping file Asset_Holding childclass) extends the Data(ParentClass). I have more than 61 table like this.
My problem is The hibernate joins all the subclass tables when selecting the parent info but Mysql allows us to join only 60 tables.
I have used below given query for selecting parent data.

select datainfo from Data as dataInfo.


Could you please help us to resolve this issue?

Thanks in advance
Eswar