Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
It is sorta covered in the
JavaRanch Style Guide
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?