Hi,

I have a bean which I map to the database using Hibernate. I'm using Hibernate Annotations to indicate the mapping I want, and to create the indices. The thoroughly simplified code is shown below.

The problem I have is that the indices on my byte[] field are not created; specifically that my multi-field index sysUuid does not get created (see example code). In the Hibernate debug logs I do not even see an attempt to create an index!

I'd like to point out that an @Index annotation on the uuid field also does not result in an index on the database.

I do know how to create an index by hand using MySQL:
create index sysuuid on persons ( system, `uuid`(8) );
-----
carmel hotels
Hotels in carmel CA
Bed and Breakfast Carmel