Column index for composite-element (collection of values)

leonceeo · **Joined:** Wed Mar 01, 2006 6:45 am **Posts:** 2

Hi,

I'm using a collection of values to keep some descriptions of an element.

Code:

<class name"Article" .....>
        ....
        <set name="descriptions" table="CAT_ARTICLE_DS" lazy="false" fetch="subselect">
            <key foreign-key="FK_CAT_ARTICLE_DS"/>
            <composite-element class="Description">
                <property name="locale" column="LOCALE" length="4"/>
                <property name="name" column="NAME" length="100"/>
                <property name="description" column="DESCRIPTION" length="1000"/>
            </composite-element>
        </set>
</class>

I would like to create a index on the ID column from the CAT_ARTICLE_DS table by using schema-update/schema-export, as our database is created in this way.

How can I declare the index in the mapping?

Thanks,
Leon

MikePloed · **Posted:** Wed Mar 01, 2006 9:28 am

As far as I know you can't define an index in a mapping file since this is very database implementation specific information that is only used for the schema export.

leonceeo · **Joined:** Wed Mar 01, 2006 6:45 am **Posts:** 2

It is possible. On each property you can set the index attribute, the problem with the composite-element is that you have no access to the id property.