1 Reply Latest reply on Feb 23, 2004 6:22 AM by Heiko Rupp

    Creating index for mysql with Jboss configuration

    jdwn Newbie

      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!