[Hibernate-issues] [Hibernate-JIRA] Created: (HB-425) Many-to-one With Join Table

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

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-425
    Summary: Many-to-one With Join Table
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: Jesse Costello-Good

    Created: Mon, 27 Oct 2003 7:06 AM
    Updated: Mon, 27 Oct 2003 7:06 AM

Description:
http://forum.hibernate.org/viewtopic.php?p=2175822#2175822

I propose allowing a many-to-one/one-to-many relationship between two classes be implemented with a separate join table.

The join table would look like: 

many_id int not null, 
one_id int not null unique, 
primary key (many_id, one_id) 

This would be useful if for some reason you didn't want to change the many side table to include a FK to the one side (i.e. there are very many rows but very few relationships, so for space efficiency), you are migrating from a many-to-many relationship, or you plan to migrate eventually to a many-to-many relationship. 

many-to-many is unsatisfactory for this situation because on the many side class I want only a simple pointer to the single related object; I don't want to deal with a collection.


---------------------------------------------------------------------
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