7

using JPA 2.1 and hibernate 5.1.x, this is possible with JPQL

select s.lowerBound,
l.status
...
from Serie s
left join Line l on
s.lowerBound between l.lineStart and l.lineEnd

how do i write this using Criteria api? i attempted this

Root<Serie> serieRoot = query.from(Serie.class);
Root<Line> lineRoot query.from(Line.class);
query.where(criteriaBuilder.between(s.get("lowerBound"), l.get("lineStart"), s.get("lineEnd")))

but this doesn't allow me to specify it's a left join.

kfc
  • 291
  • 7
  • 24

1 Answers1

5

What you do with your Criteria query doesn't allow you to specify that as a left join, because it's not really a left join. You just have multiple roots in your query, and according to the Hibernate documentation that uses cartesian products, however with a left join you get nulls on the right side if there are no matches.

Since the Form interface only allows you to create joins from attributes of your entity, I think what you want to achieve is not doable with the Criteria API. You either have to do two queries to the database or you have to use JPQL or SQL to do it in one query.

ytg
  • 1,755
  • 2
  • 23
  • 41
  • 7
    it's a shame it can't be done with criteria API. each approach, be it JPQL or criteria API, lacks a few features that the other has. it's frustrating – kfc Feb 28 '17 at 07:45