I have two Sybase tables, member and member_transn related by a foreign key constraint in member_transn on columns orgn_id and member_number, neither of which are part
I have developed CMP beans for these tables, the relevant relationship
section of the jbosscmp-jdbc.xml is:
<ejb-relation>
<ejb-relation-name>member-member_transn</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>member-has-member_transn</ejb-relationship-role-name>
<fk-constraint>true</fk-constraint>
<key-fields/>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>member_transn-has-member</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>orgn_id</field-name>
<column-name>orgn_id</column-name>
</key-field>
<key-field>
<field-name>member_number</field-name>
<column-name>member_number</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>
When I try to deploy I get this message:
org.jboss.deployment.DeploymentException: Role: member_transn-has-member
with multiplicity many using foreign-key mapping is not allowed to have
key-fields
But if I take out the key-field entries I get:
org.jboss.deployment.DeploymentException: Atleast one role of a
foreign-key mapped relationship must have key fields:
ejb-relation-name=member-member_transn
I have tried several variations on jbosscmp-jdbc.xml layout with no
success.
Any suggestions?
David
--
David Whitmarsh
Sparkle Computer Co Ltd
Systems Development and Consultancy
UNIX/LINUX/Windows, C/C++/perl/java Sybase
web: www.sparkle-cc.co.uk
mob: +44 (0)7802 537097
==========================================
signature.asc
Description: This is a digitally signed message part
