Eclipse Community Forums: EclipseLink » @Index with an@ElementCollection

Home » Eclipse Projects » EclipseLink » @Index with an@ElementCollection(I can not create an Index for an ElementCollection)

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

@Index with an@ElementCollection [message #1006474]

Thu, 31 January 2013 07:45

Guido Häp
Messages: 5
Registered: January 2013
Location: Gerolstein

Junior Member

I have the following Element Collection:
@ElementCollection(fetch = FetchType.LAZY)
@CollectionTable(name = "WH_PickingPos_Semantics",
joinColumns = @JoinColumn(name = "POSITIONID", referencedColumnName = "ID"))
@Column(name = "CLASSNAME")
@Index(name = "WH_Pos_Sem_I1", table = "WH_PickingPos_Semantics",
columnNames = "POSITIONID" )
public Set<String> getSemanticClassNames() {
....

The index is not created.

What can I do?

Report message to a moderator

Re: @Index with an@ElementCollection [message #1007348 is a reply to message #1006474]

Tue, 05 February 2013 10:32

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

Are you using DDL generation? Enable logging, and see what DDL is generated and if any errors occur.

Also try putting the @Index on the class not the attribute, @Index on the attribute is for basic mappings.

James : Wiki : Book : Blog

Report message to a moderator

Re: @Index with an@ElementCollection [message #1007959 is a reply to message #1007348]

Fri, 08 February 2013 08:55

Guido Häp
Messages: 5
Registered: January 2013
Location: Gerolstein

Junior Member

Yes, we use DDL generation.
There is no error in the log. The 'Create Index ..' is just missing.

Creating the index in the class gives the 'Create Index ..' just after the 'Create Table ...' for the table of the class.
This causes an SQL-Error because the table 'WH_PickingPos_Semantics' does not exist when the index is to be created.
EclipseLink tryes to create that table later.

EclipseLink should first create all tables for a .java-file and create the indexes afterwards.

With join-tables there is the same problem: Join-tables are created after the the indexes on the two joined classes.

Best would be to create all tables first and create all inexes afterwards.

Report message to a moderator

Previous Topic:	JPA Timeouts
Next Topic:	Retrieving data from a resultset with two or more same column names.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 16:20:57 EDT 2013