Hi there,
On JBOSS we can define tables for CMP in file jbosscmp-jdbc.xml.
Is there any way to tell jboss to create multi column index when creating tables for CMP entity beans.
Now I have index based on one column. In file jbosscmp-jdbc.xml I have this:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">
<jbosscmp-jdbc>
<...>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>category_id</column-name>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</sql-type>
<dbindex/>
</cmp-field>
<...>
I mark the column with <dbindex/> and jboss makes database index on it. But now I want to make database index on two columns.