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)

@Index with an@ElementCollection [message #1006474]

Thu, 31 January 2013 07:45

Eclipse User

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?

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

Tue, 05 February 2013 10:32

Eclipse User

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.

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

Fri, 08 February 2013 08:55

Eclipse User

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.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 10:50:27 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter