1 Reply Latest reply on Mar 23, 2002 12:52 AM by David Ward

    table-name ignored in jbosscmp-jdbc.xml

    David Ward Newbie

      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>