Entity beans which map two tables with foreign key pointing to alternate key (not primary key)

[Ravi Danum]

Hello,

I am using Toplink and have 2 entity beans: Logger and LuAppList. There is a many-to-one relationship from Logger to LuAppList. The Logger table has a foreign key reference to an alternate key in LuAppList (not the primary key). I get they error:

TOPLINK-45 Missing mapping for field [LU_APP_LIST.app_id]

It works when its mapped to a primary key. But the database table design has changed and the foreign key is now an alternate key.

Does anyone know if this should work, or how to fix it?

Thanks.

Paula