Here's a simplified version of the DB schema I used for a many to many
relationship between CMP Entity beans called Account and Customer
create table customer
(
customerid integer not null,
title character(3) not null,
firstname varchar(30) not null,
lastname varchar(30) not null,
pin character(4) not null,
primary key (customerid)
);
create table account
(
accid character(11) not null,
balance decimal(8,2) not null,
interest decimal(5,3),
type varchar(60) not null,
primary key(accid)
);
create table custacct
(
customerid integer not null,
accid character(11) not null,
primary key(customerid, accid),
foreign key(customerid) references customer ON DELETE RESTRICT,
foreign key(accid) references account ON DELETE RESTRICT
);
Here's the corresponding snippet from my openejb-jar.xml file
<relationships>
<ejb-relation>
<ejb-relation-name>Accounts-Customers</ejb-relation-name>
<many-to-many-table-name>
custacct
</many-to-many-table-name>
<ejb-relationship-role>
<relationship-role-source>
<ejb-name>Account</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>customers</cmr-field-name>
</cmr-field>
<role-mapping>
<cmr-field-mapping>
<key-column>accid</key-column>
<foreign-key-column>accid</foreign-key-column>
</cmr-field-mapping>
</role-mapping>
</ejb-relationship-role>
<ejb-relationship-role>
<relationship-role-source>
<ejb-name>Customer</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>accounts</cmr-field-name>
</cmr-field>
<role-mapping>
<cmr-field-mapping>
<key-column>customerid</key-column>
<foreign-key-column>customerid</foreign-key-column>
</cmr-field-mapping>
</role-mapping>
</ejb-relationship-role>
</ejb-relation>
</relationships>
On 4/20/07, Mark Aufdencamp <[EMAIL PROTECTED]> wrote:
Hi All,
I'm continuing my studies and have successfully deployed CMP Entity Beans
with some rudimentary QL. I'm now working on come container manged
relationships (CMR). I can't seem to find much documentation on the
appropriate mapping of the ejb-jar relationships to the openejb-jar
definitions. Can someone provide some direction to documentation on the
openejb-jar mappings. In particulare, I'm working on a Many-To-Many
relationship. I have a 3rd NF Table structure and the Entity Beans, just
need that last bit of info on the openejb-jar mappings.
Thanks,
Mark Aufdencamp
[EMAIL PROTECTED]
