Creating index for mysql with Jboss configuration

[jdwn]

Hello,

I want to set a foreign key constraint in Jboss (3.2.3).
I'm using a mySQL DB (version MySQL 4.0.17). In order to do this, I've to add an index
to my foreign key field. The problem is I have no idea where to set this in the deployment
descriptors of my ejb. One solution is to create the db tables by myself, but there are
to many tables to do this.

Is there somebody that knows how to create an index on a field by specifying it in the
deployment descriptors of the ejb?

Any help is welcome!
thnx!

[pilhuhn]

Put a tag on the respective field in jbosscmp-jdbc.xml
See http://sourceforge.net/tracker/?func=detail&aid=743570&group_id=22866&atid=381174