Hibernate Community • View topic - Index sequence for EmbeddedID

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Index sequence for EmbeddedID

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

chinkang

Post subject: Index sequence for EmbeddedID

Posted: Mon Feb 04, 2013 7:47 am

Newbie

Joined: Mon Feb 04, 2013 7:38 am
Posts: 2

Hello~
As Hibernate will automatically create index for the primary keys in the table, as well as the primary key type of EmbeddedID, I would need your advice on how to specify the sequence of column in the index. Currently it seems it auto created in alphabetic order.

Code:

Index Name      Table_name   Column_name   Column_pos   Descend
--------------   ------------   -----------   ----------   ------------
SYS_C00209013   HOSTTRAFFIC   BACKBONEID   1      ASC
SYS_C00209013   HOSTTRAFFIC   HOSTID      2      ASC
SYS_C00209013   HOSTTRAFFIC   TIMESTAMP   3      ASC

How could I make it like this

Code:

Index Name    Table_name   Column_name   Column_pos   Descend
--------------   ------------   -----------   ----------   ------------
SYS_C00209013   HOSTTRAFFIC   TIMESTAMP   1      ASC
SYS_C00209013   HOSTTRAFFIC   HOSTID      2      ASC
SYS_C00209013   HOSTTRAFFIC   BACKBONEID   3      ASC

Thank you

Top

chinkang

Post subject: Re: Index sequence for EmbeddedID

Posted: Wed Feb 06, 2013 3:57 am