[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-159) Trans-database Support

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

The following comment has been added to this issue:

     Author: Christian Bauer
    Created: Sat, 28 Jun 2003 7:15 AM
       Body:
I think this should be solved at the database level, not with ORM. Most good RDBMS support some way to join databases/schemas. Even some kind of replication would work.

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

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-159
    Summary: Trans-database Support
       Type: New Feature

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1

   Assignee: 
   Reporter: Mike Gorman

    Created: Thu, 26 Jun 2003 8:13 AM
    Updated: Thu, 26 Jun 2003 8:13 AM

Description:
Ability to define an object model, and specify that some classes live in database A, and some live in database B.  Hibernate should assume that it can not join between the databases and, in fact, the databases may be from different vendors.

I know this can be done by creating multiple Sessions, but I don't think this will make trans-database relationships work.  That is, I need to be able to have 1-1 and 1-M relationships defined between objects that live in two different databases.  When Hibernate goes to lazily initialize a 1-1 or 1-M relationship, it needs to be able to do so using a Connection connected to the appropriate database.  If M-M can be achieved, as well, so much the better (will require specification of which database the M-M table lives in, I believe.)

Goal is that a single Session can be used to obtain objects and resulting objects' relationships all work, even though they may be using Connections from the other database.


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