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 12: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 15:32

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

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.

Report message to a moderator

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

Fri, 08 February 2013 13: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: Sat Oct 01 12:32:01 GMT 2016

.:: Contact :: Home ::.