0 Replies Latest reply on Oct 31, 2002 8:03 AM by vinola_r

    Probl CMR

    vinola_r

      hello,

      I use Jboss 3.0.3 et postgresql
      I have got a problem with my CMP/CMR on Jboss
      <!-- Relation Document-Personne entre Document et Personne -->
      <ejb-relation>
      <ejb-relation-name>Document-Personne</ejb-relation-name>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Document</ejb-relationship-role-name>
      Many
      <cascade-delete/>
      <relationship-role-source>
      <ejb-name>Document</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>idPersonne1</cmr-field-name>
      </cmr-field>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>IdPersonne</ejb-relationship-role-name>
      One
      <relationship-role-source>
      <ejb-name>Personne</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>document</cmr-field-name>
      <cmr-field-type>java.util.Collection</cmr-field-type>
      </cmr-field>
      </ejb-relationship-role>
      </ejb-relation>

      When I deploy my .ear
      Jboss can't create my relationship tables
      I ve got this error :
      java.sql.SQLException: wrong data type: INT4 in statement [CREATE TABLE XX_XX_XX_XX (Document INT4 NOT NULL, Personne INT4 NOT NULL, CONSTRAINT PK_XX_XX_XX_XX PRIMARY KEY (Document, Personne))

      can you help me please,

      thanks,
      romain.