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.