Eclipse Community Forums: EclipseLink » Related records as a non-entity collection

Home » Eclipse Projects » EclipseLink » Related records as a non-entity collection(How to load related table records as a set of a basic (non-entity) type?)

Fri, 16 October 2009 15:56

Eclipse User

I have a table FOO represented by an entity class Foo. Each row in FOO can have 0 or more related rows in table FOO_TS. The latter is a very simple table with only one value field (a timestamp) and a key field (fooId) to associate with the main table.

Question is: how can I get all corresponding FOO_TS timestamps into a collection field in class Foo, without creating an entity class for those timestamps? It would be a burden to add a PK field+index into table BAR for just that purpose. By the same token, I want to avoid making a FooTimestamp entity with a composite PK or something of that sort.

Something like this:

@Entity
@Table(name="FOO")
class Foo {
  @Id
  private Integer fooId;

  private Set<Timestamp> timestamps = new HashSet<Timestamp>();

}

Thanks for any help

Mon, 19 October 2009 10:37

Eclipse User

In EclipseLink you can use an @BasicCollection for this, or in EclipseLink 1.2 and JPA 2.0 you can use an @ElementCollection.

http://en.wikibooks.org/wiki/Java_Persistence/ElementCollect ion#Basic_Collections

Previous Topic:	Random deadlock/hang during commit in EJB3 application
Next Topic:	be able to specify JDBC driver jar w/o adding it to manifest

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 05 04:24:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter