Re: [JBoss-user] Question about CMP/CMR

2003-01-01 Thread Dain Sundstrom
On Monday, December 30, 2002, at 02:29 PM, Stefan Arentz wrote: Huh? Foreign keys are *legacy* database structure? Any pre existing schema is legacy to me. -dain --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven.

Re: [JBoss-user] Question about CMP/CMR

2003-01-01 Thread Dain Sundstrom
On Monday, December 30, 2002, at 02:33 PM, Stefan Arentz wrote: On Monday, Dec 30, 2002, at 19:10 Europe/Amsterdam, Jonathan.O'[EMAIL PROTECTED] wrote: Stefan, Most of our tables use a generated key (via an Oracle Sequence) as the primary key. Any tables that wanty a foreign key reference to

Re[2]: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Alex Loubyansky
Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key. Currently, this is not supported. alex Sunday, December 29, 2002, 3:32:33 PM, you wrote: LF Hallo Alex, LF I know you ported this feature not long ago from HEAD to 3.2. LF

RE: Re[2]: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Panagiotis Korros
] Question about CMP/CMR Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key. Currently, this is not supported. alex Sunday, December 29, 2002, 3:32:33 PM, you wrote: LF Hallo Alex, LF I know you ported this feature not long ago

Re[4]: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Alex Loubyansky
, December 30, 2002 12:19 PM PK To: Langelage, Frank PK Subject: Re[2]: [JBoss-user] Question about CMP/CMR PK Frank, PK if I understood you right, you want to map a CMR field with foreign key PK to a CMP field that is not a primary key. Currently, this is not PK supported. PK alex PK Sunday

Re: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Stefan Arentz
Alex Loubyansky wrote: Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key. Currently, this is not supported. Yeah I also removed foreign key constraints from my tables. This is pretty silly though. How are other people

Re: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Dain Sundstrom
On Monday, December 30, 2002, at 10:55 AM, Stefan Arentz wrote: Alex Loubyansky wrote: Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key. Currently, this is not supported. Yeah I also removed foreign key constraints from

Re: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Jonathan . O'Connor
] Question about CMP/CMR Alex Loubyansky wrote: Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key. Currently, this is not supported. Yeah I also removed foreign key constraints from my tables. This is pretty silly though. How

Re: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Stefan Arentz
On Monday, Dec 30, 2002, at 18:27 Europe/Amsterdam, Dain Sundstrom wrote: On Monday, December 30, 2002, at 10:55 AM, Stefan Arentz wrote: Alex Loubyansky wrote: Frank, if I understood you right, you want to map a CMR field with foreign key to a CMP field that is not a primary key.

Re: [JBoss-user] Question about CMP/CMR

2002-12-30 Thread Stefan Arentz
On Monday, Dec 30, 2002, at 19:10 Europe/Amsterdam, Jonathan.O'[EMAIL PROTECTED] wrote: Stefan, Most of our tables use a generated key (via an Oracle Sequence) as the primary key. Any tables that wanty a foreign key reference to this, always use this generated key. Yeah that is exactly what I

Re: [JBoss-user] Question about CMP/CMR

2002-12-29 Thread Alex Loubyansky
Hello Frank, in JBoss-3.2 (cvs version) you can map foreign key fields to primary key fields. This is done by specifying the same column names for foreign and primary key fields. alex Saturday, December 28, 2002, 9:12:26 PM, you wrote: LF JBoss-Head, JDK 1.4.1, Informix-DB LF Following given

[JBoss-user] Question about CMP/CMR

2002-12-28 Thread Langelage, Frank
JBoss-Head, JDK 1.4.1, Informix-DB Following given situation: Bean 1: Name=Festa, DBTable=festa, PK=festa_serial Bean 2: Name=Festr, DBTable=festr, PK=festa_serial+festr_pos_nr, FK=festa_serial - festa Bean 3: Name=febdr, DBTable=febdr, PK=febdr_serial, FK=festa_serial - festa As you can see,