Eclipse Community Forums: EclipseLink » Addtional Foreign Key

Help

Home

Home » Eclipse Projects » EclipseLink » Addtional Foreign Key

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

Addtional Foreign Key [message #704300]

Thu, 28 July 2011 13:28

Michal

Messages: 3
Registered: July 2011

Junior Member

Hi,
I am working on some project and have such situation:

I have Entity Service:

@Entity
public class Service implements Serializable {
@Id
private Long id;
@ManyToMany
Collection<Language> language;
}

And entity Language:

@Entity
public class Language implements Serializable {
@Id
@Column(length=4)
private String id;
}

Thanks to it I have Entity Service which contains collection of available languages in DB it creates table: Service, Language and Service_Language for many to many mapping.

Now I want to add subscription entity:

@Entity
public class Subscription implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;

@ManyToOne(optional=false)
private Service service;
@ManyToOne
private User user;

@ManyToOne
private Language language;
}

Now it creates table Subscription with service_id field which is foreign key to Service.id and field language_id which is foreign key to Language.id

OK but in this situation I can create subscription entity with some service id and language which is not on that service list.

I need one more foreign key contraint: foreign key (service_id,language_id) references Service_Language(service_id,language_id)

Ive tried some methods but it does not work and I cannot find anything in Google.

Maybe some of you can help me.

Cheers
Mike

Report message to a moderator