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?)

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

Fri, 16 October 2009 15:56

LexLythius
Messages: 2
Registered: October 2009

Junior Member

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

Report message to a moderator

Mon, 19 October 2009 10:37

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

Senior Member

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

James : Wiki : Book : Blog : Twitter

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 02:35:13 EDT 2014