wood burning stoves 2.0*
The moose likes JDBC and the fly likes Can we make any column in nested table as foreign key of a normal table primary key? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can we make any column in nested table as foreign key of a normal table primary key?" Watch "Can we make any column in nested table as foreign key of a normal table primary key?" New topic
Author

Can we make any column in nested table as foreign key of a normal table primary key?

Brahim Bakayoko
Ranch Hand

Joined: Aug 29, 2003
Posts: 155
Can we make any column in nested table as foreign key of a normal table primary key?

I know how to set a nested table column as a primary key:
NESTED TABLE Specs STORE AS nested_table_specs((PRIMARY KEY(NESTED_TABLE_ID, SpecID, ...)))

How is it done for foreign keys?


SCJP, SCWCD, SCBCD, IBM CSD WebSphere v5, <br />A+, MCP 2000 and 2000 server, CST, and few incompleted certification tracks.<br /> <br />Ivory Coast<br /> <br />Analyze your web Request/Response @ <a href="http://webtools.servehttp.com" target="_blank" rel="nofollow">http://webtools.servehttp.com</a> down for a while...
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Can we make any column in nested table as foreign key of a normal table primary key?
 
Similar Threads
hibernate mapping
How to implement OneToOne entity without explicit id field
Generator class for non-primary columns
Composite foreign key mapping in Hibernate 3 using JPA
inserting data of two forms into two tables with same transaction id