A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
Hibernate annotations and joins
Joined: May 05, 2010
Oct 26, 2010 05:58:22
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
I agree. Here's the link:
subject: Hibernate annotations and joins
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?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014