in my weblogic-cmp-rdbms.xml the tag weblogic-relationship-role therisn't

[giuseppe astarita]

Hi, i must specify the option "cascade-delete" for the CMR fields i have two files xml: weblogic-ejb-jar.xml and weblogic-cmp-rdbms.xml but the tag
<weblogic-relationship-role> is not located in them how can i do?

Thanks for answer

[Pranav Shukla]

Hi there,

<weblogic-relationship-role> can be specified in weblogic-cmp-rdbms.xml where you map your foreign key column.

Here is a sample weblogic-cmp-rdbms.xml

<weblogic-rdbms-jar>
<weblogic-rdbms-bean>
<ejb-name>CustomerBean</ejb-name>
<data-source-name>myDS</data-source-name>
 
<table-map>
<table-name>Customer</table-name>
<field-map>
<cmp-field>customerId</cmp-field>
<dbms-column>CustomerId</dbms-column>
</field-map>
<field-map>
<cmp-field>customerName</cmp-field>
<dbms-column>CustomerName</dbms-column>
</field-map>
<field-map>
<cmp-field>customerAddress</cmp-field>
<dbms-column>CustomerAddress</dbms-column>
</field-map>
</table-map>
 
<automatic-key-generation>
<generator-type>Oracle</generator-type>
<generator-name>cust_sequence</generator-name>
<key-cache-size>1</key-cache-size>
</automatic-key-generation>
 
</weblogic-rdbms-bean>
 
<weblogic-rdbms-bean>
<ejb-name>OrderBean</ejb-name>
<data-source-name>myDS</data-source-name>
 
<table-map>
<table-name>ItemOrder</table-name>
<field-map>
<cmp-field>orderId</cmp-field>
<dbms-column>OrderId</dbms-column>
</field-map>
<field-map>
<cmp-field>date</cmp-field>
<dbms-column>OrderDate</dbms-column>
</field-map>
</table-map>
 
<automatic-key-generation>
<generator-type>Oracle</generator-type>
<generator-name>order_sequence</generator-name>
<key-cache-size>1</key-cache-size>
</automatic-key-generation>
 
</weblogic-rdbms-bean>
 

<weblogic-rdbms-relation>  
<relation-name>CustomerOrderRelation</relation-name>  
<weblogic-relationship-role>      
<relationship-role-name>OrderRole</relationship-role-name>   
<relationship-role-map>      
<column-map>           
<foreign-key-column>CustomerId</foreign-key-column> 
<key-column>CustomerId</key-column>        
</column-map>    
</relationship-role-map>
</weblogic-relationship-role>
</weblogic-rdbms-relation>
 
<database-type>Oracle</database-type>
 
</weblogic-rdbms-jar>
 

Check this link

Hope this helps.

Cheers
Pranav