Eclipse Community Forums: EclipseLink » Index on enumerated collection?

Home » Eclipse Projects » EclipseLink » Index on enumerated collection?(Index on enumerated collection via annotation?)

Show: Today's Messages :: Show Polls :: Message Navigator

Index on enumerated collection? [message #1697123]

Mon, 01 June 2015 18:00

Mike Summers

Messages: 7
Registered: November 2014

Junior Member

I have an entity with an enumerated collection and I'd like to set an index on the enumeration string. This has no effect (no error, no index):

   @Enumerated(EnumType.STRING)
   @ElementCollection
   @Updateable
   @Index(table="fitableentity_state", columnNames={"state"})
   private Set<FitableEntityState> state = numSet.of(FitableEntityState.Inactive);

I don't get an index on state in the table fitableentity_state as I'd expect.

Is there a way to do this via annotation or is a migration the only choice?

Thanks.

Report message to a moderator

Re: Index on enumerated collection? [message #1697205 is a reply to message #1697123]

Tue, 02 June 2015 12:46

Mike Summers

Messages: 7
Registered: November 2014

Junior Member

For future reference this a solution:

   @CollectionTable(indexes={@Index(columnList="state")})
   @Enumerated(EnumType.STRING)
   @ElementCollection(targetClass = FitableEntityState.class)
   @Updateable
   private Set<FitableEntityState> state = EnumSet.of(FitableEntityState.Inactive);

ElementCollection can be refactored out into CollectionTable but for Eclipselink 2.6 this works nicely with

<property name="eclipselink.ddl-generation" value="drop-and-create-tables" />
<property name="eclipselink.ddl-generation.output-mode" value="database" />

in persistence.xml

Report message to a moderator

Previous Topic:	moxy fails to render json, jaxb error thrown
Next Topic:	Two Persists within One Transactional Method

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:28:49 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter