Question

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

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.

Answer 2

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

友情链接