Dear Hibernate users,

I'm using Hibernate Tools 3.0.0 in Eclipse 3.4.1.

I've been using the reverse engineering functionality. I would like to know if it is possible to reverse engineer a relationship where the parent table has a primary key and the child tables have foreign keys (which is the primary key of the parent table). I would like to link the data within the database using one id.

I received the following error:

org.hibernate.cfg.reveng.JDBCReader - The JDBC driver didn't report any primary key columns in tb_products. Asking rev.eng. strategy

Are there any examples to implement this (i.e. changes to the hibernate.reveng.xml file)? or ideas how to implement this.

Thanks Alyssa

not sure what your first question is about - that is just normal many-to-one associations, right ?

But about the warning in the logs it indicates there is no primary keys defined for the table ?

Yes thats right, do i need to have a primary key in every table? I thought it would be okay to have a foreign key ? Which is actually a reference to the primary key in the parent table.

The table should still have a primary-key if you want to have an association.

Otherwise you are looking at it being a join-table which is not something the reverse engineering supports - you can map that with hbm.xml or annotations though.

Thanks for your advice.