Register / Login
Object Relational Mapping
Hibernate annotations and joins
posted 5 years ago
I'd like to have this SQL statement implemented with Hibernate (using annotations)
select * from services serv left join campaigns camp on (serv.enterprise=camp.enterprise and serv.service=camp.service) where serv.service in (LIST) and serv.enterprise='enter';
so I've mapped the 2 entities and in the service class I have this field.
@OneToMany private List<luxdbcampaing> lsCampaing;
but doing this, the join is made using the ID and that is not wanted.
I've tried using @JoinColumns and it tries to create a Foreign key (not wanted) but it complains about using 2 columns in the foreign key.
"A Foreign key refering service from campaing has the wrong number of column. should be 1" this is the error when I use @JoinTable with 2 joincolumns alos the @JoinColumns provoke this error.
Edit: Neither enterprise nor service are IDs of neither table
Orphan delete doesn't seem to be working properly
Anyone know how to construct a one to many mapping with Hibernate / Java?
Problem with joining of two tables with Hibernate
Simple JOIN in JPA proving difficult
Hibernate - How to do associations with join tables?