[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2117) hbm2ddl generate additional foreign key column for super class when try to map from holder class to sub class

[Egor (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2117?page=comments#action_24666 ] 

Egor commented on HHH-2117:
---------------------------

Generated tables by SchemaExport

HolderClass
-----------------------
id_holder_class PK

SuperClass
-----------------------
id_super_class PK
class_type
id_holder_class FK

SubClass
-----------------------
id_super_class PK, FK
id_holder_class FK

> hbm2ddl generate additional foreign key column for super class when try to map from holder class to sub class
> -------------------------------------------------------------------------------------------------------------
>
>          Key: HHH-2117
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2117
>      Project: Hibernate3
>         Type: Bug

>     Versions: 3.1.3
>  Environment: MS SQL 2000, PointBase Micro 5
>     Reporter: Egor
>     Priority: Minor

>
>
> I have next classes
> SuperClass
>       |
>       |             *    1
> SubClasss-----HolderClass
> Mappings for this classes
> <class name="SuperClass" table="locations" discriminator-value="0">
>    <id name="idSuperClass" type="short">
>       <column name="id_super_class" />
>       <generator class="assigned" />
>    </id>
>    <discriminator type="byte">
>       <column name="class_type" />
>    </discriminator>
>    ......................................
> </class>
> <subclass name="SubClass" extends="SuperClass" discriminator-value="1">
>    <join table="SubClass">
>       <key>
>          <column name="id_super_class" />
>       </key>
>       <many-to-one name="holderClass" class="HolderClass" >
>          <column name="id_holder_class" />
>       </many-to-one>
>       ......................................
>    </join>
> </subclass>
> <class name="HolderClass" table="HolderClass">
>    <id name="idHolderClass" type="short">
>       <column name="id_holder_class" />
>       <generator class="assigned" />
>    </id>
>    <bag name="subClassList" table="SubClass" inverse="true">
>       <key column="id_holder_class" />
>       <one-to-many class="SubClass" />
>    </bag>
>    ......................................
> </class>
> When I try to generate schema with SchemaExport, i get next tables
>                  FK
> SuperClass-----
>         |PK              |
>         |FK         PK|
> SubClasss-----HolderClass
>                FK

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira