On Monday, Dec 30, 2002, at 19:10 Europe/Amsterdam, Jonathan.O'[EMAIL PROTECTED] wrote:
Stefan,Yeah that is exactly what I am doing. However, I like to have real constraints because I also have other clients access the database.
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?
Euh. The only thing I want is foreign keys with real constraints :-)
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