Foreign key constraint not added as requested ...

[tomerbd]

I'm using mysql , jboss.
following is the important part of my jbosscmp-jdbc.xml, notice the preferred-relation-mapping tag...

<jbosscmp-jdbc>
 <defaults>
 <datasource>java:/MySqlDS</datasource>
 <datasource-mapping>mySQL</datasource-mapping>
 <create-table>true</create-table>
 <remove-table>true</remove-table>
 <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
 </defaults>
</jbosscmp-jdbc>

I received this message from jboss :

Foreign key constraint not added as requested

Why didnt it create the foreign keys ?

[tomerbd]

PS

I'm using jboss3.2.5, and had the same problem on jboss3.2.4

the relationship constraints wern't created while jboss created the tables on my database....

[tomerbd]

Its ok i figured it :) I have added

<fk-constraint>true</fk-constraint>

:)