July 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16986) CoercionException caused by attempted coercion of query param to entity field type

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16986 ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMDMwMj... ) Re: CoercionException caused by attempted coercion of query param to entity field type ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMDMwMj... ) But, upon closer inspection, it’s a bit hard to argue that this particular query is something that Hibernate could possibly accept. If I have a query like select 2 * ?1 , Hibernate has to assign a type to the query result before returning a Query object to the program, and in this case it can't know that type until Query.setParameter() is called. So, it does the best it can do, and infers that ?1 must be an integer type. Which is pretty reasonable. And then when you try to bind a non-integral value to that parameter by calling setParameter() , you receive: java.lang.ArithmeticException: Rounding necessary which is also not unreasonable. (Silently truncating the BigDecimal seems worse to me.) So I don’t see this case as fixable. That said, there are some related cases where we probably could do better, and there’s actually an existing issue related to this: https://hibernate.atlassian.net/browse/HHH-16102. In particular, this query: session.createQuery( "SELECT 1 WHERE 2 * ?1 > 0" ) .setParameter(1, BigDecimal.valueOf(123.446)) .getSingleResult(); is one that we probably should accept. ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16102) Parameters in date/time arithmetic

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16102 ( https://hibernate.atlassian.net/browse/HHH-16102?atlOrigin=eyJpIjoiODY1Yj... ) Re: Parameters in date/time arithmetic ( https://hibernate.atlassian.net/browse/HHH-16102?atlOrigin=eyJpIjoiODY1Yj... ) So https://hibernate.atlassian.net/browse/HHH-16986 reports a very similar issue with queries like: session.createQuery( "SELECT 2 * ?1" ) .setParameter(1, BigDecimal.valueOf(123.446)) .getSingleResult(); However, in this particular case, we actually can’t really do much better. ( https://hibernate.atlassian.net/browse/HHH-16102#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16102#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16986) CoercionException caused by attempted coercion of query param to entity field type

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16986 ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMDE3ZT... ) Re: CoercionException caused by attempted coercion of query param to entity field type ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMDE3ZT... ) By the way, it’s incredibly easy to reproduce this without Spring. It took me less than five minutes. Please take the time to narrow things down in future. ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16986) CoercionException caused by attempted coercion of query param to entity field type

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16986 ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiODFmYW... ) Re: CoercionException caused by attempted coercion of query param to entity field type ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiODFmYW... ) Before reporting problems with Spring Data, you should always first attempt to reproduce the problem with only Hibernate, and no Spring. So please close this issue, then attempt to reproduce your problem with no Spring, and, if you are able to do so, you’re very welcome to submit a new issue describing a problem with Hibernate , that does not make reference to Spring APIs. Thanks. ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16986) CoercionException caused by attempted coercion of query param to entity field type

by Ruben Gehring (JIRA)

Ruben Gehring ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6401f5e... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTZjYTlmNDU0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMTZjYT... ) HHH-16986 ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMTZjYT... ) CoercionException caused by attempted coercion of query param to entity field type ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiMTZjYT... ) Issue Type: Bug Affects Versions: 6.2.6 Assignee: Unassigned Attachments: hibernate-issues.zip Components: query-hql Created: 24/Jul/2023 09:55 AM Environment: Hibernate: 6.2.6 Java: 19 (Adoptium JDK) OS: Windows 10 Database: H2 2.1.214 Spring Boot: 3.1.2 Priority: Major Reporter: Ruben Gehring ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6401f5e... ) Description ----------- When using Spring Data Jpa to write a query multiplying an entity field with a passed parameter hibernate seems to get confused which number should have which type, resulting in a CoercionException. Steps to reproduce ------------------ * Import attached project as gradle project into your IDE * Run the tests Expected: Tests pass (no asserts → no failures) Actual result: All tests throw the InvalidDataAccessApiUsageException caused by Hibernate throwing a CoercionException. Details ------- Queries the like of @Query(""" SELECT test.intField * ?1 FROM TestEntity test """) BigDecimal calculateFromEntityField(BigDecimal value); throw an Exception with message > > > > Parameter value [2.5] did not match expected type [BasicSqmPathSource(intField > : Integer) ] > > Note that 2.5 is passed as the value parameter and is of type BigDecimal. Attempting to use it for the entity's intField does not work, since it is not of type Integer. I initially suspected the error may be with Spring but when debugging I see they call Hibernate’s AbstractSharedSessionContract.createQuery with the query string SELECT test.intField*?1 FROM TestEntity test which seems correct. In return they get back an object of type QuerySqmImpl with the content querySqmImpl.parameterMetadata.queryParameters [0].key.anticipatedType = BasicSqmPathSource(intField : Integer) which does not match the input value of 2.5 and should presumably be some kind of BigDecimal datatype instead. So it seems to me that the issue probably lies with Hibernate getting confused which of the operands of the multiplication is the query parameter. Note that I tried to use named parameters and parameter objects (unwrapped using SPeL i.e. {{:# {#params.myParam} }} as well and always got the same result. ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-15939) add short literals to HQL or relax type checking for integer types

by Gavin King (JIRA)

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16939) Optimistic and Pessimistic Force Increment Update Statements are not committed when using a batch

by Andrea Boriero (JIRA)

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16670) ENUM column definitions cannot be customized (on MySQL/MariaDB)

by Christian Beikov (JIRA)

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16670) ENUM column definitions cannot be customized (on MySQL/MariaDB)

by Christian Beikov (JIRA)

2 years, 8 months

1
0
0 / 0

[JIRA] (HHH-16795) improvements to QueryException hierarchy

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16795 ( https://hibernate.atlassian.net/browse/HHH-16795?atlOrigin=eyJpIjoiYjdjOG... ) Re: improvements to QueryException hierarchy ( https://hibernate.atlassian.net/browse/HHH-16795?atlOrigin=eyJpIjoiYjdjOG... ) Please close this. ( https://hibernate.atlassian.net/browse/HHH-16795#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16795#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100232- sha1:a133497 )

2 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2023