Using annotations to implement a static join in hibernate

Question

Hi, I'm relatively new to hibernate and was wondering if someone could help me out. While I have no issues implementing a normal join on multiple columns in hibernate using the

@JoinColumns

tag, I'm stumped when trying to implement the following query in annotations:

SELECT A.* FROM TABLEA A
LEFT OUTER JOIN TABLEB B
ON A.UID = B.ID
AND B.NAME = 'JAY'

As you can see the join is also based on a value ('JAY') which is not a column. I don't know how to proceed with such a mapping in annotations.

Can someone help?

Thanks, Jay

Answer 1

you don't need to specify b.name as a join condition. instead just specify it as part of the where clause.

SELECT A.* 
FROM TABLEA A 
LEFT OUTER 
JOIN TABLEB B ON A.UID = B.ID 
WHERE B.NAME is null or B.NAME = 'JAY'

Answer 2

It's unclear from your question whether you're trying to map this as HQL query or an association.

I'm assuming you're talking about a query and that association between TABLEA and TABLEB is already mapped via A.UID and B.ID columns. In that case you can write your query using with keyword:

select a.*
  from TableA a
  left join a.tableB b
  with b.name = 'JAY'

If that's not what you're looking for, please clarify your question.