'How to get join with compare MAX value using Spring boot JPA Specification?

 private Specification<UserEntity> hasMinAvailablePoints(long minPoints) {
   return (root, query, criteriaBuilder) -> {        
   return criteriaBuilder.greaterThanOrEqualTo(
         criteriaBuilder.max(root.join("transactions").get("balance")), minPoints);
    };
 }

Above code throws error as below.

Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet\r\n\tat org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java

jpa specifications

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to get join with compare MAX value using Spring boot JPA Specification?

Sources

Related Questions