Description Jörg Schömer 2011-03-08 06:01:20 EST

Build Identifier: 2.2.0

The Model below should create two tables like:

CREATE TABLE A_TAB (ID NUMBER(19), NAME VARCHAR(255))
CREATE TABLE A_EVENTS (A_ID NUMBER(19), WHO VARCHAR(255), WHEN TIMESTAMP)

but EclipseLink generates the these:

CREATE TABLE A_TAB (ID NUMBER(19), NAME VARCHAR(255))
CREATE TABLE A_EVENTS (A_ID NUMBER(19), WHO VARCHAR(255), WHEN VARCHAR(255))

Model:

@Entity
@Table(name="A_TAB")
@SequenceGenerator(name = "A_SEQ", sequenceName = "A_SEQ")
class A {

  @Id
  @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "A_SEQ")
  Integer id;

  String name;

  @ElementCollection
  @CollectionTable(name="A_EVENTS", joinColumns={"A_ID", referencedColumnName = "ID"})
  List<Event> events;

}

@Embeddable
class Event {

  String who;

  @Temporal(TemporalType.TIMESTAMP)
  Date when;

}


Reproducible: Always

Steps to Reproduce:
see details.