Hi,

I am using hibernate 3 annotations

I want to add indexes on foreign keys

I have something like

@OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = "ANATOMY_ID")
@ForeignKey(name = "FK_W_DEVICE_ANATOMY")
@Index (name = "FK_W_DEVICE_ANATOMY") --------//THROWS ERROR
public Anatomy getAnatomy() {
return anatomy;
}

I also have

@OneToMany(cascade = CascadeType.ALL)
@Fetch(FetchMode.SUBSELECT)
@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
@JoinColumn(name = "WIRELESS_DEVICE_ID")
@ForeignKey(name = "FK_CAMERA_W_DEV")
@Index (name = "FK_CAMERA_W_DEV") --------//THROWS ERROR
@IndexColumn(name = "DISPLAY_ORDER")
public List<Camera> getCameras() {
return cameras;
}

I get an error saying "org.hibernate.MappingException: Unable to find logical column name from physical name null in table wireless_device".

The above mappings are in a class which maps to wireless_device table.

How to add indexes on foreignkeys?

Thanks in advance!