Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » JoinTable with additional column
JoinTable with additional column [message #932490] Thu, 04 October 2012 02:32 Go to next message
Pavel Zelenka is currently offline Pavel Zelenka
Messages: 61
Registered: July 2009
Member
Hi,

I would appreciate a little help with OneToMany relation using JoinTable. I use EclipseLink 1.1.4

Let's say there are entities Person and Projects. There is a join table which connects projects to persons. But the join table has an additional column "is_valid". Is there any way to tell the EclipseLink to relate only those entities where is_valid=1?
Or the best way is to use entity class for the join table (http://en.wikibooks.org/wiki/Java_Persistence/ManyToMany#Additional_columns_in_join_table)

Thanks

Pavel

Report message to a moderator

Re: JoinTable with additional column [message #932964 is a reply to message #932490] Thu, 04 October 2012 12:05 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 862
Registered: July 2009
Senior Member
While I'm usually against it because it hides data from your object model, there is a way to filter results for the mapping described here:
http://wiki.eclipse.org/EclipseLink/Examples/JPA/MappingSelectionCriteria

This allows you to add in the is_valid=1 to the queries bringing in the data for the mapping. It means though that your cache will not always represent what is in the database - changing is_valid may require the owning entity to be refreshed to have the changes reflected in the entity.

Unless the mapping is read-only though, you will need to map it somehow so it can be inserted into when entities are added to the collection. I usually recommend the Mapping_a_Join_Table_with_Additional_Columns approach because it reflects what is in the database, and allows the application to decide what to display. The entity can transparently filter results to the app with say a getValidEntities method, and allows for queries using the is_valid field if required in the future.

Report message to a moderator

Previous Topic:JTA
Next Topic:Hibernate migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 18:21:03 EDT 2013

Powered by FUDForum. Page generated in 0.01440 seconds