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.
Can you give an example where you want to have some other field or
combination of fields as a unique reference to a foreign table?
I would think this is probably a bad idea in the long run.
HTH,
Jonathan O'Connor
Stefan Arentz <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
30.12.2002 16:55
Please respond to jboss-user
To: [EMAIL PROTECTED]
cc:
Subject: Re: [JBoss-user] 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 are other people handling this? Use another CMP2 engine? I can image
that for many projects it is a requirement to have foreign keys or map
to existing databases. How do you solve that with JBoss?
S.
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
