July 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiYmIxNj... ) Re: Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiYmIxNj... ) This change breaks some of our (admittedly fragile and suboptimal) query result parsing code, here’s an example: Query query = em.createNativeQuery(sql.toString()); for ( Object [] result : query.getResultList()) { BigDecimal userId = (BigDecimal) result[15]; If this backwards compatibility break is intentional, my apologies: this report can inded be closed (unless you think that a mention of the change in the migration guide ( https://github.com/hibernate/hibernate-orm/blob/6.0/migration-guide.adoc ) is warranted). ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiODg5ND... ) Re: Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiODg5ND... ) P.S. If I recall correctly, this change was probably made so that Hibernate behaves the same on Oracle as on all other databases. That is, if we persist a field of type Long to a column, then running a native query on that column should return Long. ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16923) Deleting all entities of a given type fails when using a composite primary key

by Philip Lowney (JIRA)

Philip Lowney ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c18c2f... ) *commented* on HHH-16923 ( https://hibernate.atlassian.net/browse/HHH-16923?atlOrigin=eyJpIjoiNTVkZm... ) Re: Deleting all entities of a given type fails when using a composite primary key ( https://hibernate.atlassian.net/browse/HHH-16923?atlOrigin=eyJpIjoiNTVkZm... ) Thank you @Marco Balladelli for checking into this so quickly. I will build locally once HH-26709 ( https://hibernate.atlassian.net/browse/HHH-16709 ) is merged and I will confirm that this is resolved. ( https://hibernate.atlassian.net/browse/HHH-16923#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16923#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiMzBjMD... ) Re: Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiMzBjMD... ) Almost all changes between Hibernate 5 and 6 are intentional, yes. Is there any reason why you believe that this change is incorrect. Because otherwise this issue looks like a question, not a bug report. ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjdmMmQzZDU5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiZjdmMm... ) HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiZjdmMm... ) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiZjdmMm... ) Change By: Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) It seems that some type mappings have changed between Hibernate versions 5 and 6, is this intentional ? Here are some of the changes I’ve noticed when parsing NativeQuery results : ||*SQL Data type*||*Java type (Hibernate 5)*||*Java type (Hibernate 6)*|| |NUMBER(19,0)|java.math.BigDecimal|java.lang.Long| |NUMBER(1,0)|java.math.BigDecimal|java.lang.Integer or java.lang.Boolean| ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiZmVmMD... ) Re: Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiZmVmMD... ) I’ve attached a link to a gitlab repo containing a demo of the behavior change (using testcontainers) : run mvn test in both subfolders to compare the result types. ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16927) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal

by Morgan PEYRE (JIRA)

Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGM5NmU0ZDcw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiNGM5Nm... ) HHH-16927 ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiNGM5Nm... ) Some NUMBER column types now get mapped to Boolean/Integer/Long instead of BigDecimal ( https://hibernate.atlassian.net/browse/HHH-16927?atlOrigin=eyJpIjoiNGM5Nm... ) Issue Type: Bug Affects Versions: 6.2.2, 6.2.4, 6.2.5, 6.2.6 Assignee: Unassigned Components: hibernate-core Created: 12/Jul/2023 04:10 AM Environment: Hibernate 6.2.5.Final Oracle XE 18 (Docker image gvenzl/oracle-xe:18-slim-faststart) Java 17.0.7 (OpenJDK 17.0.7+7-Ubuntu-0ubuntu122.04.2) Ubuntu Ubuntu 22.04.2 / WSL2 (GNU/Linux 5.15.90.1-microsoft-standard-WSL2 x86_64) Priority: Major Reporter: Morgan PEYRE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) It seems that some type mappings have changed between Hibernate versions 5 and 6, is this intentional ? Here are some of the changes I’ve noticed: *SQL Data type* *Java type (Hibernate 5)* *Java type (Hibernate 6)* NUMBER(19,0) java.math.BigDecimal java.lang.Long NUMBER(1,0) java.math.BigDecimal java.lang.Integer or java.lang.Boolean ( https://hibernate.atlassian.net/browse/HHH-16927#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16927#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#100231- sha1:2d13be9 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4899) Use the links to Appendix instead of Javadocs where possible in reference documentation

by Yoann Rodière (JIRA)

2 years, 9 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