[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-364) One to One foreign Key issue

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Fri, 26 Sep 2003 3:53 AM
       Body:
Please submit a test case to reproduce this problem. TIA.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-364


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-364
    Summary: One to One foreign Key issue
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
   Versions:
             2.0.3

   Assignee: 
   Reporter: Jon King

    Created: Thu, 25 Sep 2003 10:09 PM
    Updated: Thu, 25 Sep 2003 10:09 PM
Environment: Windows 2000, Ant 1.5.4, Oracle 8i, Java 1.4

Description:
I have a PURCHASE ORDER with a one to one relationship with a BUYER and SUPPLIER, I have set it up so the PK of the Purchase Order is the FK of the BUYER & SELLER tables but only the last one-to-one foreign key is ever created. 

<class name="domain.TxPurchaseOrder" table="TX_PURCHASE_ORDER">
   ....

   <id column="PO_ID" name="id" type="long" unsaved-value="null">
     <generator class="sequence" >
         <param name="sequence">TX_PURCHASE_ORDER_SEQ</param>
     </generator>
   </id>

   <one-to-one name="SellingParty" 
               class="domain.TxPoSellingParty" 
               cascade="all" 
               constrained="true" />

   <one-to-one name="BuyingParty" 
               class="domain.TxPoBuyingParty" 
               cascade="all" 
               constrained="true"/> 

   ...

</class>

In the Selling and Buying classes I have :- 

 <id column="PO_ID" name="id" type="long" unsaved-value="null">
     <generator class="foreign" />
 </id>

In the output I get: -

     [java] alter table TX_PURCHASE_ORDER add constraint FK8092ED8B48CAF5B foreign key (PO_ID) references TX_PO_BUYING_PARTY

but the Selling Party does not get a foreign key. 


I would have expected both to get a foreign key contraint, have I done something wrong or is this correct ?




---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira