Please, post to jboss-user. Maybe the problem is in case-sensitivity? Make sure CMP and foreign key fields have the same name and use the same case.
alex Wednesday, April 02, 2003, 7:56:41 AM, David Wang wrote: DW> I have 2 CMP entity beans that have one to many relationship. The "Many" DW> side have a foreign key "user_id" that reference primary key in another DW> table. DW> If I declare the foreign key as both CMP and CMR fields, it works only with DW> the default database, doesn't work with postgreSQL. postgresql will complain DW> "duplicate field user_id" when create table or access table. DW> if I declare the foreign key as CMR field only, it works with both database DW> system. DW> Is there a way to make the postgresql work when I declare the field as both DW> CMR and CMP ? DW> regards ------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user