data dictionary

[Former Member]

HEllo All,

1)We are trying to build a simple application having around 6-7 tables. These tables will be used entirely for a portal application. The tables have foreign key relations. How do I express the foreign key relations using Java Dictionary?

I understand that this can be done using CMP/CMR but I feel using entity beans would over-engineer our application.Is there

a way to acheive foreign key constraints without using EJB?

2) If we are not using Java Dictionary to create these tables ,is there some other way we can create these so that they

can reside in the portal database?

Thanks

[former_member182372 · Accepted solution]

Hello vijay,

AKAIK, there is no possible way to create foreign key relations using java dictionary. As workaround you can create SQL script (specific for DB you are using) which creates all necessary relations and run it after deployment of dictionary. Or you can specify foreign relations in JDO (see slide 32 from https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7d5db590-0201-0010-dd93-9ec...

Best regards, Maksim Rashchynski.