Two Laptop Bag
The moose likes Object Relational Mapping and the fly likes Hibernate annotations and joins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate annotations and joins" Watch "Hibernate annotations and joins" New topic

Hibernate annotations and joins

Alex Armenteros
Ranch Hand

Joined: May 05, 2010
Posts: 75
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.

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
It's not a secret anymore!