Hi, I have the following situation: JBoss 3 RC3, Oracle db. 3 tables: table1 with prim key: pk1 table2 with prim key: pk2 table3 with primary key: pk1+pk2
All tables have their entity beans. Also entity bean 3 has relations to entity 1 and 3 (n-1 relationships). The problem is that when I create entity 3, and give an instance of entity 1 and 2 with the create step (that's what I want). the SQL Insert statement has duplicate column names. Because the primary keys in table 3 are also the foreign keys for the relation ships from entity 3 to entity 1 and 2. I cannot remove the primary key cmp-fields from entity bean 3, since then I won't have a primary key any more in entity 3 (I cannot generate a primary from cmr foreign key fields, can I?). How is this supposed to work? Is it possible at all, or must the database table 3 be redesigned, and get it's own prim key? (That is actually no solution, since I'm talking about an existing database) Any help or pointer to the right direction is much appreciated. Wouter _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
