Hello,
I am facing a unique (unique for my experience) DB setup that I am at a
loss to replicate in OJB. The tables look something like this:
1) Table 'A':
"A_ID" INTEGER NOT NULL ,
"A_NAME" CHARACTER (40) NOT NULL ,
PRIMARY KEY (A_ID)
2) Table 'B':
"B_ID" INTEGER NOT NULL ,
"B_NAME" CHARACTER (40) NOT NULL ,
PRIMARY KEY (B_ID)
3) Table 'C':
"C_ID" INTEGER NOT NULL ,
"C_NAME" CHARACTER (40) NOT NULL ,
PRIMARY KEY (C_ID)
4) Table 'A_B_REL':
"A_ID" INTEGER NOT NULL ,
"B_ID" INTEGER NOT NULL ,
"DISPLAY_SEQUENCE" INTEGER NOT NULL ,
PRIMARY KEY (A_ID, B_ID)
5) Table 'B_C_REL':
"A_ID" INTEGER NOT NULL ,
"B_ID" INTEGER NOT NULL ,
"C_ID" INTEGER NOT NULL ,
"DISPLAY_SEQUENCE" INTEGER NOT NULL ,
PRIMARY KEY (A_ID, B_ID, C_ID) ,
CONSTRAINT SOMECON FOREIGN KEY (A_ID, B_ID) REFERENCES A_B_REL (A_ID, B_ID)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
