Hi,
I have a table with two columns for example a table test has two columns "id" and "name" where id is a primary key

Now I need to create a complex index for both the columns but priority must be (name,id)

Following is the query to create this table.. But how do I represent it in .hbm.xml file.. Please help


CREATE TABLE `Test1`.`New Table` (

`id` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT,

`name` VARCHAR(45) NOT NULL,

PRIMARY KEY (`id`),

INDEX `Index_2`(`name`, `id`)

)

Hello,

If you're using xml there it's an attribute named index that it's used to create the index on the associated property if you use the same name for two or more properties then it will create the index with those properties in the order that are declared.

If you're using annotation the attribute of @org.hibernate.annotations.Index with the name of the indexes and the columnames.

regards,

Thank you.. I have tried this out.. My problem here is the order of the index columns.
But I need the order for the name column first and then the "id". But I am not able to do this as my id is the primary key and it hbm, this needs to be always declared first. Please let me know if there is any way for this Thanks in advance