Hello!

Is there a way to create indexes on columns of a table which is created to store @CollectionOfElements?

My code is:

...
@CollectionOfElements(fetch = FetchType.EAGER)
@JoinTable(name = "TOKENS", joinColumns = @JoinColumn(name = "NODE_FK"))
@Column(name = "TOKEN")
@IndexColumn(name = "POSITION")
public List<String> getTokens() {
return tokens;
}
...

After automatic schema createion for postgresql dialect I have a table:
CREATE TABLE path_token
(
node_fk int8 NOT NULL,
token varchar(255),
"position" int4 NOT NULL,
CONSTRAINT path_token_pkey PRIMARY KEY (node_fk, "position"),
CONSTRAINT fk99d8113f4c4aa404 FOREIGN KEY (node_fk) REFERENCES tree_node (id) ON UPDATE NO ACTION ON DELETE NO ACTION
)

Everything is nice and works but I want to add 3 indexes : for t every column of this table. Is there a way to do it with annotations? Any workarounds?

Thanks for any help!!!
Michael


Hibernate version:
1.3/annotations 1.3beta8

Hmm...

One more strange thing: the name of the table itself is not the one I provide with the annotations, but rather the autogenerated name.

Annotations reference has an example:
@JoinTable(
table=@Table(name="BoyFavoriteNumbers"),
joinColumns = @JoinColumn(name="BoyId")
)
which should in theory change the generated table name, but in my 3.1beta8 @JoinColumn annotation does NOT have the table property at all! Well, and it looks like the name (of the table?) property is also ignored...

Any ideas on this? Actually I'm more interested in getting the indexes generated, but having the table name OK would also be fine :-)

Thanks!!!
Michael

you'll have to set the index manually, using an hbm database-object for example.

I can't reproduce the table name issue, are you sure of it?

Hello!

I have switched to 3.2 CR and the table name issue seems to be gone. I'm not sure if it is gone because of the update or something else: my domain objects are under heavy development and I can't correlate it for sure.

Actually, would not it be nice to have a way to set the indexes using annotations? I like and heavily use the schema autogeneration feature.

Thanks for your work, and your answer!
Michael

Is there still no way to index a @CollectionOfElements field via annotations (As of Mar, 2007)? If not, how can this be done via database-object? The docs seem to only talk about customizing higher level things like create and drop statements.