October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-4386) @ManyToOne in composite id should prevent fetch=EAGER

by Christian Beikov (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15605) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2

by Hannes Rosenögger (JIRA)

Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjM0ZmIwMTBk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiYjM0Zm... ) HHH-15605 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiYjM0Zm... ) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiYjM0Zm... ) Change By: Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) In one of my applications, we use an attribute converter to store zoneddatetime objects as human-readable strings in the database. This works just fine with hibernate 5.6.11 and even 6.1.1, but in hibernate 6.1.2 and newer it suddenly breaks when comparing dates. Normal crud operations work as intended. The error message with hibernate > 6.1.1 is: {noformat}java.lang.IllegalArgumentException: Unsure how to handle given Java type [java.lang.String] as TemporalType#TIMESTAMP{noformat} I’ve created a small sample project to showcase the behavior: [https://github.com/123Haynes/hibernate-test-case-HHH-15605|https://github...] Simply change the Hibernate Version to 6.1.1 and the test will pass. Anything newer, and it will fail. I tested this with a h2 and a hsql database, same error so I don’t think it’s database specific. I’m not sure if I missed something that I need to change in the release notes, or if this usecase is really broken. Any help with this would be greatly appreciated. 🙂 ( https://hibernate.atlassian.net/browse/HHH-15605#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15605#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#100209- sha1:13f5f09 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-10880) Bad sql with composite keys

by Christian Beikov (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-4327) @Id on multiple properties

by Christian Beikov (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-8259) Allow pluggable component tuplizers for composite-id elements on the mapping dtd

by Christian Beikov (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15605) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2

by Hannes Rosenögger (JIRA)

Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTFjYTkyYzdj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiMTFjYT... ) HHH-15605 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiMTFjYT... ) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiMTFjYT... ) Change By: Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) In one of my applications, we use an attribute converter to store zoneddatetime objects as human-readable strings in the database. This works just fine with hibernate 5.6.11 and even 6.1.1, but in hibernate 6.1.2 and newer it suddenly breaks when comparing dates. Normal crud operations work as intended. The error message with hibernate 6 is: {noformat}java.lang.IllegalArgumentException: Unsure how to handle given Java type [java.lang.String] as TemporalType#TIMESTAMP{noformat} I’ve created a small sample project to showcase the behavior: [https://github.com/123Haynes/ data hibernate - jpa-demo/blob/main/src/ test /java/com/example/datajpademo/DataJpaDemoApplicationTests.java|https://github.com/123Haynes/data - jpa case - demo/blob/main/src/test/java/com/example/datajpademo/DataJpaDemoApplicationTests.java|smart HHH - link](main branch with spring boot 2.7.4 and hibernate 5.6.11, testcase works as intended) [ 15605| https://github.com/123Haynes/ data hibernate - jpa-demo/blob/spring-boot-3/src/ test /java/com/example/datajpademo/DataJpaDemoApplicationTests.java|https://github.com/123Haynes/data - jpa case - demo/blob/spring HHH - boot-3/src/test/java/com/example/datajpademo/DataJpaDemoApplicationTests.java 15605 |smart-link] (branch spring-boot-3 with hibernate Simply change the Hibernate Version to 6.1. 4, testcase fails with 1 and the error mentioned) test will pass. Anything newer, and it will fail. I tested this with a h2 and a hsql database, same error so I don’t think it’s database specific. I’m not sure if I missed something that I need to change in the release notes, or if this usecase is really broken. Any help with this would be greatly appreciated. 🙂 ( https://hibernate.atlassian.net/browse/HHH-15605#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15605#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#100209- sha1:13f5f09 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-8370) Support RowValue constructor syntax in in lists for SQL Server 2008

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWI0OGJmZTQ1... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-8370?atlOrigin=eyJpIjoiOWI0OGJ... ) HHH-8370 ( https://hibernate.atlassian.net/browse/HHH-8370?atlOrigin=eyJpIjoiOWI0OGJ... ) Support RowValue constructor syntax in in lists for SQL Server 2008 ( https://hibernate.atlassian.net/browse/HHH-8370?atlOrigin=eyJpIjoiOWI0OGJ... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) As discussed in [ HSEARCH-1367 ] : it seems that when loading a list of entities by primary key is slow on SQL Server 2008 when the key is composite. It was reported that we generate a more efficient SQL statement for Oracle, and that this SQL Server version actually would support this same syntax and this would fix the performance problem. See linked issue for all details. In short, the aim of this enhancement request is that {noformat}WHERE (FIELD1,FIELD2) IN ((?,?),(?,?),...){noformat} which doesn’t work on SQL Server is rendered with EXISTS and VALUES like this {noformat}SELECT * FROM EntityTable T WHERE EXISTS ( SELECT * FROM (VALUES (?,?), (?,?), (?,?)) AS V(FIELD1, FIELD2) WHERE T.FIELD1 = V.FIELD1 AND T.FIELD2 = V.FIELD2){noformat} This is apparently faster on SQL Server than the regular emulation: {noformat}WHERE ((T.FIELD1=? AND T.FIELD2=?) OR (T.FIELD1=? AND T.FIELD2=?) OR ... (T.FIELD1=? AND T.FIELD2=?)){noformat} ( https://hibernate.atlassian.net/browse/HHH-8370#add-comment?atlOrigin=eyJ... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-8370#add-comment?atlOrigin=eyJ... ) 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#100209- sha1:13f5f09 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15605) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2

by Hannes Rosenögger (JIRA)

Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmQ1Yjc1MTJk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiNmQ1Yj... ) HHH-15605 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiNmQ1Yj... ) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2 ( https://hibernate.atlassian.net/browse/HHH-15605?atlOrigin=eyJpIjoiNmQ1Yj... ) Change By: Hannes Rosenögger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec3d02... ) In one of my applications, we use an attribute converter to store zoneddatetime objects as human-readable strings in the database. This works just fine with hibernate 5.6.11 and even 6.1.1 , but in hibernate 6.1. 4 2 and newer it suddenly breaks when comparing dates. Normal crud operations work as intended. The error message with hibernate 6 is: {noformat}java.lang.IllegalArgumentException: Unsure how to handle given Java type [java.lang.String] as TemporalType#TIMESTAMP{noformat} I’ve created a small sample project to showcase the behavior: [https://github.com/123Haynes/data-jpa-demo/blob/main/src/test/java/com/ex... branch with spring boot 2.7.4 and hibernate 5.6.11, testcase works as intended) [https://github.com/123Haynes/data-jpa-demo/blob/spring-boot-3/src/test/ja...] (branch spring-boot-3 with hibernate 6.1.4, testcase fails with the error mentioned) I tested this with a h2 and a hsql database, same error so I don’t think it’s database specific. I’m not sure if I missed something that I need to change in the release notes, or if this usecase is really broken. Any help with this would be greatly appreciated. 🙂 ( https://hibernate.atlassian.net/browse/HHH-15605#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15605#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#100209- sha1:13f5f09 )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15605) Date comparisons with attributeconverters for Zoneddatetime broken since Hibernate 6.1.2

by Hannes Rosenögger (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4721) Re-enable tests disabled because of HHH-15606

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiZTY1ZjQ2... ) / Task ( https://hibernate.atlassian.net/browse/HSEARCH-4721?atlOrigin=eyJpIjoiZTY... ) HSEARCH-4721 ( https://hibernate.atlassian.net/browse/HSEARCH-4721?atlOrigin=eyJpIjoiZTY... ) Re-enable tests disabled because of HHH-15606 ( https://hibernate.atlassian.net/browse/HSEARCH-4721?atlOrigin=eyJpIjoiZTY... ) Issue Type: Task Assignee: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: tests Created: 17/Oct/2022 08:28 AM Fix Versions: 6.2-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) https://hibernate.atlassian.net/browse/HSEARCH-4708 ( https://hibernate.atlassian.net/browse/HSEARCH-4708 ) will introduce a commit on branch wip/main/orm6-in-main-code that disables some tests, because they cannot work properly as long as that bug isn’t fixed in Hibernate ORM 6. See occurrences of the ticket key HHH-15606 in the code. Simply reverting the whole commit that introduced these occurrences should be enough to restore the tests. ( https://hibernate.atlassian.net/browse/HSEARCH-4721#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4721#add-comment?atlOrigin... ) 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#100209- sha1:13f5f09 )

2 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022