hello,
short question, is it possible JBoss simply ignores the relation-table-mapping tag in the jbosscmp-jdbc.xml ? it seems to me the container always uses its own name for the join-table (as if I did not specify any) depending on the names of the relations
I have this part of XML code for a many-2-many relation between Project and User, and it is never used .... (watching the DEBUG output from the logs)
did someone get this to work yet ?
<ejb-relation>
<ejb-relation-name>project-user-relation</ejb-relation-name>
<relation-table-mapping>
<table-name>PROJECT_USER</table-name>
</relation-table-mapping>
<ejb-relationship-role>
<ejb-relationship-role-name>projects</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>id</field-name>
<column-name>PROJECT_FK</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>users</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>id</field-name>
<column-name>USER_FK</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>