Hi,

I'm working on mapping an existing legacy database which has tables spread across multiple schemas.

Basically the problem is i want to create a mapping from one table in Schema A to another table in Schema B. But the columns to be mapped are not constrained to each other in any way (FK/PK) and are not the PK of either table.

It's required that the mapping be a one-to-many relationship from Table A to Table B, i.e. contain a set of Table B records.

Maybe worth mentioning that this column is a foreign key in Table B to another table (Table C).

How can this relationship be expressed in Hibernate?
Do i have to use HQL to express this relationship or can it be done using Hibernate's xml elements? Or do i need to add constraints to the db?

Thanks for any help,
John

Hibernate version: 3.2.4.sp1

Name and version of the database you are using: Oracle 10g

In the mapping file use the schema attribute as shown below.



Hope this helps.

Nikhil

Thanks for that. Got it sussed with combination of schema="" and using property-ref attribute on the key element in order to reference the correct column.

Cheers,
John