1 Reply Latest reply on May 7, 2003 3:39 PM by draftdog

    CMR join table names

    draftdog

      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>

        • 1. Re: CMR join table names
          draftdog

          shame on me, I did not see somebody changed the build.xml in CVS for deployment, jboss deployment descriptors we being put in META-INF/jboss instead of META-INF/

          I did not pay attention to it ... and the beans deployed well without the jboss XML files, so kinda easy to overlook

          sorry for this

          Wouter.