With the following in jbosscmp-jdbc.xml in JBoss3.0.0beta2 and JDK1.3.1_02 on RedHat 7.1, kernel 2.4.9-31,i386...
The auto-generated xref table is not using my defined name of GROUPS_USERS; instead it is creating one called GROUP_USERS_USER_GROUPS. Any idea what I'm doing wrong? Thanks!
<ejb-relation>
<ejb-relation-name>Group-User</ejb-relation-name>
<table-mapping>
<table-name>GROUPS_USERS</table-name>
<ejb-relationship-role>
<ejb-relationship-role-name>
Groups-Have-Users
</ejb-relationship-role-name>
<table-key-fields>
<table-key-field>
<field-name>groupKey</field-name>
<column-name>GRP_KEY</column-name>
</table-key-field>
</table-key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>
Users-Have-Groups
</ejb-relationship-role-name>
<table-key-fields>
<table-key-field>
<field-name>userKey</field-name>
<column-name>USR_KEY</column-name>
</table-key-field>
</table-key-fields>
</ejb-relationship-role>
</table-mapping>
</ejb-relation>
please ignore - if you dig and find the dtd in cvs for beta2, you will find that the table-mapping is now relation-table-mapping that contains table-name and *doesn't* contain ejb-relationship-role 's. Also, table-key-field(s) is now just key-field(s).