Hibernate version: 3.2.2

Name and version of the database you are using: MySQL 5.0.28

Here I have a weird legacy table, let me call it Table1. Table1 has two columns columnA and columnB, it does not have any primary key. ColumnA is the foreign key referencing the PK of Table2. ColumnA is not nullable. ColumnA and ColumnB together is a foreign key referencing the composite primary key of Table3. ColumnB is nullable. How to map this table? Table2 and Table3 are both already correctly mapped. I'm using JPA annotation. Thanks a lot for any help!


Ellen

forgot to say:

cardinality between Table1 and Table2: ManyToOne
cardinality between Table1 and Table3: ManyToOne

The PK of Table2, semantically ColumnA, is a part of the composite PK of Table3.

Thanks!

ellen

Can you fox hibernate saying column A is the primary key. If not as far as I know, I think it is not possible in Hibernate without a primary key column. The .equals and hashcode method base all their functionality based on the PK value.