How to create a db index in a many-to-one association?

HeeroJheng · **Joined:** Tue Aug 22, 2006 10:52 pm **Posts:** 3

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

Hibernate version: 3.2.4 sp1

Mapping documents:Using Hibernate Annotation.

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:PostgreSQL 8.1.8

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

I used @Index to define a DB index in a many-to-one association, like this:

Code:

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="latest_exercise")
   @Index(name="exercise_index")
   public ExerciseRecord getLatestExercise() {
      return latestExercise;
   }

But it is not created. How to create this index?

emmanuel · **Posted:** Fri Jun 08, 2007 5:43 pm

Which Hibernate Annotations are you using, AFAIR it has been fixed.

HeeroJheng · **Joined:** Tue Aug 22, 2006 10:52 pm **Posts:** 3

The version of the Hibernate-annotations that I used is 3.3.0.
Is it a bug?

emmanuel · **Posted:** Mon Jun 11, 2007 7:14 pm

Are you sure it's not applied?
My unit test (o.h.test.annotations.various.IndexTest and Trunk) show the index generation working (for HSQLDB at least).

It's like the example you've posted.