Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate annotations and joins

Alex Armenteros
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic