how to make table index

Daniel choi · **Joined:** Mon Sep 05, 2005 9:27 pm **Posts:** 2

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Mapping documents:

I made hbm.xml file that is

<id name="keyword" type="string" unsaved-value="0">
<column name="KEYWORD" length="100" not-null="true" index="iSynonym_keyword_index"/>
<generator class="assigned"/>
</id>

cause of making index for KEYWORD column.
but I can't make index that has two attribute for primary key ( super key )
read that below..

<composite-id>
<key-property name="collectionID" type="string" length="100"/>
<key-property name="keyword" type="string" length="100"/>
</composite-id>

I can't write english well, but I guess you will understand the question.

Daniel choi · **Joined:** Mon Sep 05, 2005 9:27 pm **Posts:** 2

i use oracle dbms.
if primary key is set at ddl statement which table create,
then oracle automatically make field index..
i know that but I am not confident, but i read oracle tutorial, i realize ask stupid question.
may be another table attribute is problem...

Romsl · **Joined:** Sun Apr 24, 2005 4:25 am **Posts:** 28

I have the same problem. The definition/attribute index doesn't build an index on database.