using hibernate with tables have no relation
posted 8 years ago
Yes. You can apply arbitary relationships via HQL on unrelated fields, just as you can in SQL. Support for unions (which are the only valid join accross unrelated tables) are not there yet. But if you absolutely had to do them Hibernate support SQL too.
Originally posted by Sherif Shehab:
Hi,
Can hibernate be used in 2 tables without any relation or association between them ? or hibernate must be used only with tables got primary and foreign keys between them ??
Yes. You can apply arbitary relationships via HQL on unrelated fields, just as you can in SQL. Support for unions (which are the only valid join accross unrelated tables) are not there yet. But if you absolutely had to do them Hibernate support SQL too.
posted 8 years ago
HI , no i mean that these two tables doesn't have a foreign key constraint from one to the other, what i'm thinking in that table A in db1 , table B in db2 , the last table will be a backup for table A , so there is no foreign or primary keys between them or any associations ... got me ?
Originally posted by Angel Taveras:
Hello Sherif, you mean that these two tables doesn't have a foreign key constraint from one to the other or that doesn't have anything in common not even a single row,
regards,
HI , no i mean that these two tables doesn't have a foreign key constraint from one to the other, what i'm thinking in that table A in db1 , table B in db2 , the last table will be a backup for table A , so there is no foreign or primary keys between them or any associations ... got me ?
Thanks,
Sherif
posted 8 years ago
No, Hibernate cannot do this. Hibernate is primarily designed to work with relational data. As soon as you stray from relational data you start to have problems.
You can do it with database specific functionality: some databases allow you to define a logical database that spans more than one actual database (Oracle for example allows you to access one databse from another using linking).
However what you suggest sounds like it would be better achieved using the database's own replication mecahnism and keep a (presumably hot?) backup that way.
[ December 23, 2008: Message edited by: Paul Sturrock ]
what i'm thinking in that table A in db1 , table B in db2 ,
No, Hibernate cannot do this. Hibernate is primarily designed to work with relational data. As soon as you stray from relational data you start to have problems.
You can do it with database specific functionality: some databases allow you to define a logical database that spans more than one actual database (Oracle for example allows you to access one databse from another using linking).
However what you suggest sounds like it would be better achieved using the database's own replication mecahnism and keep a (presumably hot?) backup that way.
[ December 23, 2008: Message edited by: Paul Sturrock ]
posted 8 years ago
I agree with Paul it's very hard to make it work with an ORM. Sherif why do you want to make a join or make a relationship with these two tables if they contain the same data? Maybe if you can tell us a little about what you're trying to do with it we can come with a recommendation,
regards,
[ December 24, 2008: Message edited by: Angel Taveras ]
regards,
[ December 24, 2008: Message edited by: Angel Taveras ]
posted 8 years ago
actually the goal i wanna reach is to back up a table for instance named table1 in db1 in table2 in db2 , so how i can do any relation and the 2 tables in different DBs ? any recommendations
Originally posted by Angel Taveras:
I agree with Paul it's very hard to make it work with an ORM. Sherif why do you want to make a join or make a relationship with these two tables if they contain the same data? Maybe if you can tell us a little about what you're trying to do with it we can come with a recommendation,
regards,
[ December 24, 2008: Message edited by: Angel Taveras ]
actually the goal i wanna reach is to back up a table for instance named table1 in db1 in table2 in db2 , so how i can do any relation and the 2 tables in different DBs ? any recommendations
Thanks,
Sherif
posted 8 years ago
Why do they need to be related? And if they are related, should they not be in the same schema?
Database backups are something databases have been doing years before Hibernate existed. Just use the tools your database provides. Which database are you using?
Sherif Shehab wrote:Originally posted by Angel Taveras:
I agree with Paul it's very hard to make it work with an ORM. Sherif why do you want to make a join or make a relationship with these two tables if they contain the same data? Maybe if you can tell us a little about what you're trying to do with it we can come with a recommendation,
regards,
[ December 24, 2008: Message edited by: Angel Taveras ]
actually the goal i wanna reach is to back up a table for instance named table1 in db1 in table2 in db2 , so how i can do any relation and the 2 tables in different DBs ? any recommendations
Why do they need to be related? And if they are related, should they not be in the same schema?
Database backups are something databases have been doing years before Hibernate existed. Just use the tools your database provides. Which database are you using?
