[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5189) Same table is mapped twice but different primary keys. Giving error while secondPassCompileForeignKeys.

Same table is mapped twice but different primary keys. Giving error while secondPassCompileForeignKeys. ------------------------------------------------------------------------------------------------------- Key: HHH-5189 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5189 Project: Hibernate Core Issue Type: Bug Environment: OS: Linux DB : Oracle Hibernate Version : 3.2.5 ga Reporter: Sardar Romender Singh Priority: Trivial Two tables are mapped with different primary keys. Example : I have customer table which is mapped to Customer Entity whose primary keys are Customer id and status (which says authorized customer or un authorized customer). I have one more entity mapped to same table CustomerLight which will load only some specific fields of the customer which contains the where clause which specifies to load only authorized customer. There are some more entities which are mapped to customer entity with key-many-to-one relationship. After loading of the mapping file while validation of foriegn key constraints its failing Foreign key constraint failed "must have same number of columns as the referenced primary key" This is happening only in some environments not all.