Hibernate version: Hibernate 3.0.5

Consider a scenario as shown in Fig. 1. Here the hierarchy of P is mapped using Table-Per-ClassHierarchy and that of X is mapped using Table-Per-ConcreteClass. The cardinality of association is one-to-many (from P to X) and the association is bidirectional.

<<See attachment: Fig1.jpg>>Figure 1 Class Diagram containing an association

The ideal database schema for this association would be as shown in Fig 2.

<<See attachment: Fig2.jpg>>Figure 2 Ideal Database Schema
But as I don’t know much hibernate-mapping-tags, I have mapped this using following hbm files:

P.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="chsncc.bi.one2many">
<class name="P" table="PTEST">
<id name="id" column="ID" type="java.lang.Long">
<generator class="increment"/>
</id>
<set name="xs" table="P_XTEST">
<key column="P_ID"/>
<many-to-any meta-type="string" id-type="long">
<meta-value value="Z1" class="Z1"/>
<meta-value value="Z2" class="Z2"/>
<column name="X_CLASSNAME"/>
<column name="X_ID"/>
</many-to-any>
</set>
</class>
</hibernate-mapping>

Z1.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="chsncc.bi.one2many">
<class name="Z1" table="Z1TEST">
<id name="id" column="ID" type="java.lang.Long">
<generator class="increment"/>
</id>
<join table="P_XTEST" inverse="true">
<key column="X_ID"/>
<many-to-one name="p" column="P_ID"/>
</join>
</class>
</hibernate-mapping>

Z2.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="chsncc.bi.one2many">
<class name="Z2" table="Z2TEST">
<id name="id" column="ID" type="java.lang.Long">
<generator class="increment"/>
</id>
<join table="P_XTEST" inverse="true">
<key column="X_ID"/>
<many-to-one name="p" column="P_ID"/>
</join>
</class>
</hibernate-mapping>

And the resultant database schema is as shown in Fig. 3.


<<See attachment: Fig3.jpg>>Figure 3 The resultant database schema
This requires an extra table to be created.

Is there any way by which I can map it to the ideal schema?

Thanks in advance.
[/img]

[img]C:/Fig1.JPG[/img]
[img]C:/Fig2.JPG[/img]
[img]C:/Fig3.JPG[/img][/url]

there was some problem attaching images. hence reentered the issue.
please refer to : http://forum.hibernate.org/viewtopic.ph ... highlight=