I have 2 CMP entity beans that have one to many relationship. The "Many" side have a foreign key "user_id" that reference primary key in another table.
 
If I declare the foreign key as both CMP and CMR fields, it works only with the default database, doesn't work with postgreSQL. postgresql will complain "duplicate field user_id" when create table or access table.
 
if I declare the foreign key as CMR field only, it works with both database system.
 
Is there a way to make the postgresql work when I declare the field as both CMR and CMP ?
 
regards
 

Reply via email to