Hello.

I´m new to Hibernate and I want to know if working with a database wich doesn´t use Foreign Keys between tables, I can define these relations in an hibernate-mapping file.
For example I have 2 tables, Departements and Users and Users has a field called Dept but no FK references Departments table.
In Hibernate what would happen if I create Departments hibernate-mapping file and Users hibernate-mapping file with one to many relationship???

Thanks!!!

Hi,
Hibernate needs to map the object relation into a database relation. Which means if User has many Dept. so in the Dept. table there would be an FK (UserId) to represent this multiplicity. Please read a book called Hibernate In Action first to understand the ORM

Regards,

Thank´s for the link to Hibernate In Action, it´s been very usefull.
If I´ve understood ok, relations between tables must been defined using Foreign Keys so Hibernate can do mapping all right.

Then although I have a column called Dept in User table, if this column isn´t defined as a FK to Department PK table, Hibernate won´t do the mapping ok. Is that?

Thank´s.