We are using criteriaBuilder to fetch data from DB. We used to have smth like criteriaBuilder.avg(root.get(SOME_PARAM)).as(BigDecimal.class) However after spring update fromn 3.1.1 → 3.4.1 it seems that the cast to big decimal stopped working. It returns double and we are expecting BigDecimal in …

Thank you for your swift reply! Tried that as well like so: JpaExpression<BigDecimal> castedAvg = ((JpaExpression<BigDecimal>) criteriaBuilder.avg(root.get(CUSTOM_PARAM))).cast(BigDecimal.class); It gives Inconvertible types; cannot cast ‘jakarta. persistence. criteria. Expression<java. lang. …

Sorry, my bad, should have been like this JpaExpression<BigDecimal> castedAvg = ((JpaExpression<Double>) criteriaBuilder.avg(root.get(CUSTOM_PARAM))).cast(BigDecimal.class); It works

Hibernate cast from double to BigDecimal

Hibernate ORM

beikov January 20, 2025, 1:20pm 2

See CriteriaBuilder cast function example - #4 by isivanoff.

Topic		Replies	Views
Casting double precision to numeric in postgresql Hibernate ORM	1	1695	July 14, 2023
Set precision in criteria BigInteger cast Hibernate ORM	3	1156	September 30, 2022
Hibernate Criteria API throws org.hibernate.QueryException: CAST function should only have 2 arguments Hibernate ORM	1	270	August 5, 2024
CriteriaBuilder cast function example Hibernate ORM	5	15123	February 28, 2025
Hibernate BigDecimal conversion Hibernate ORM	0	1379	October 3, 2019

Hibernate cast from double to BigDecimal

Related topics