I am using jboss-3.0.3_tomcat-4.1.12 , mysql and CMP 2.0 .
I get this wrong sql sentence:
ALTER TABLE events ADD INDEX ind_nplan, anio (nplan, anio), ADD CONSTRAINT fk_events_party FOREIGN KEY (nplan, anio) REFERENCES parties (anio, nplan)
due to my standardjbosscmp-jdbc.xml:
<fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
Is this a bug?