Spring Data Specification or QueryDSL

Question

In one of the projects, we are using Spring Data. Now that the queries are getting complex, we thought about adding Spring Data Specification or QueryDSL.

However, not sure about the best way forward. I think they both serve the same purpose. Is any one is recommended over the other?

Thanks

score 24 · Accepted Answer · answered Oct 18 '12 at 07:36

Spring Data specifications are a bit verbose compared to Querydsl

public CustomerSpecifications {

  public static Specification<Customer> customerHasBirthday() {
    return new Specification<Customer> {
      public Predicate toPredicate(Root<T> root, CriteriaQuery query, CriteriaBuilder cb) {
        return cb.equal(root.get(Customer_.birthday), today);
      }
    };
  }

  public static Specification<Customer> isLongTermCustomer() {
    return new Specification<Customer> {
      public Predicate toPredicate(Root<T> root, CriteriaQuery query, CriteriaBuilder cb) {
        return cb.lessThan(root.get(Customer_.createdAt), new LocalDate.minusYears(2));
      }
    };
  }
}

compared to this

QCustomer customer = QCustomer.customer;
LocalDate today = new LocalDate();
BooleanExpression customerHasBirthday = customer.birthday.eq(today);
BooleanExpression isLongTermCustomer = customer.createdAt.lt(today.minusYears(2));

If you are going to deal with complex queries you might want to pick Querydsl. I believe it will scale better as it is more compact.

This answer is biased, since I am the maintainer of Querydsl.

I love `querydsl`. It offers almost everything a native query will offer. Great Work! — Lokesh, Dec 27 '18 at 07:30

Spring Data Specification or QueryDSL

1 Answers1