2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues June 2023

hibernate-issues@lists.jboss.org

1 participants
1521 discussions

Start a nNew thread

[JIRA] (HHH-16778) TimeZoneStorageType.NORMALIZE_UTC & COLUMN not normalized to UTC

by Ivan Andrianto (JIRA)

Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjA3ZWFlYzZi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMjA3ZW... ) HHH-16778 ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMjA3ZW... ) TimeZoneStorageType.NORMALIZE_UTC & COLUMN not normalized to UTC ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMjA3ZW... ) Change By: Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I have this column. As I know, the time should be normalized to UTC in the database {noformat}public class Purchase { @Id @GeneratedValue @GenericGenerator(name = "UUID", type = UuidGenerator.class) private UUID id; @TimeZoneStorage(TimeZoneStorageType.TIMESTAMP_UTC) private ZonedDateTime purchasedAt; }{noformat} Then, I try to save a record, where the time is created using {{ZonedDateTime}} with a non UTC {{ZoneId}} (the same as the local system). {noformat}ZonedDateTime time = ZonedDateTime.of(2023, 6, 11, 15, 0, 0, 0, ZoneId.of("Asia/Jakarta")); Purchase purchase = new Purchase(); puchase.setPurchasedAt(time); Purchase savedPurchase = purchaseRepository.save(purchase); Purchase retrievedPurchase = purchaseRepository.findById(savedPurchase.getId());{noformat} The expected value should be {{2023-06-11 08:00:00}} (normalized to UTC), but I got {{2023-06-11 15:00:00}} in the database I use PostgreSQL 12 and the column type is timestamp without timezone Then, when the record is retrieved, the column value is {{2023-06-11T15:00Z}} which is incorrect. I have seen the related code change in [https://github.com/hibernate/hibernate-orm/pull/4940/commits/7e4bacb1126b...] But somehow the data stored in the database is incorrect The value from hibernate log is {{binding parameter [2] as [TIMESTAMP_UTC] - [2023-06-11T08:00:00Z]}} The parameter value from PostgreSQL log when inserting is {{$2 = '2023-06-11 15:00:00+07'}} (and stored in the database as {{2023-06-11 15:00:00}}) ( https://hibernate.atlassian.net/browse/HHH-16778#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16778#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16778) TimeZoneStorageType.NORMALIZE_UTC & COLUMN not normalized to UTC

by Ivan Andrianto (JIRA)

Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGUyMjk0ZTlm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiOGUyMj... ) HHH-16778 ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiOGUyMj... ) TimeZoneStorageType.NORMALIZE_UTC & COLUMN not normalized to UTC ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiOGUyMj... ) Change By: Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Summary: TimeZoneStorageType. T NORMALIZE_UTC & COLUMN not normalized to UTC ( https://hibernate.atlassian.net/browse/HHH-16778#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16778#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16778) TimeZoneStorageType.T

by Ivan Andrianto (JIRA)

Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDIzYzBiMDYy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiNDIzYz... ) HHH-16778 ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiNDIzYz... ) TimeZoneStorageType.T ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiNDIzYz... ) Change By: Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Summary: TimeZoneStorageType.T ( https://hibernate.atlassian.net/browse/HHH-16778#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16778#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16778) TimeZoneStorageType

by Ivan Andrianto (JIRA)

Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjQ0YTMxZWVh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiYjQ0YT... ) HHH-16778 ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiYjQ0YT... ) TimeZoneStorageType ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiYjQ0YT... ) Change By: Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Summary: sfsaewa TimeZoneStorageType ( https://hibernate.atlassian.net/browse/HHH-16778#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16778#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16778) sfsaewa

by Ivan Andrianto (JIRA)

Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTQ1MjUyMWIx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMTQ1Mj... ) HHH-16778 ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMTQ1Mj... ) sfsaewa ( https://hibernate.atlassian.net/browse/HHH-16778?atlOrigin=eyJpIjoiMTQ1Mj... ) Issue Type: Bug Assignee: Unassigned Created: 11/Jun/2023 06:12 AM Priority: Major Reporter: Ivan Andrianto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) ( https://hibernate.atlassian.net/browse/HHH-16778#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16778#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16777) add typesafe version of Hibernate.isPropertyInitialized()

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16777 ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiMmNiMz... ) Re: add typesafe version of Hibernate.isPropertyInitialized() ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiMmNiMz... ) Added. ( https://hibernate.atlassian.net/browse/HHH-16777#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16777#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16777) add typesafe version of Hibernate.isPropertyInitialized()

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *assigned* an issue to Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjBjODVkYmQ2... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiNjBjOD... ) HHH-16777 ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiNjBjOD... ) add typesafe version of Hibernate.isPropertyInitialized() ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiNjBjOD... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Assignee: Unassigned Gavin King ( https://hibernate.atlassian.net/browse/HHH-16777#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16777#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16777) add typesafe version of Hibernate.isPropertyInitialized()

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDczNzlkZmFl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiMDczNz... ) HHH-16777 ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiMDczNz... ) add typesafe version of Hibernate.isPropertyInitialized() ( https://hibernate.atlassian.net/browse/HHH-16777?atlOrigin=eyJpIjoiMDczNz... ) Issue Type: Improvement Assignee: Unassigned Created: 11/Jun/2023 00:42 AM Priority: Minor Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Like in HR, add a method with this signature: public <E, T> boolean isPropertyInitialized(E entity, Attribute<E, T> attribute) ( https://hibernate.atlassian.net/browse/HHH-16777#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16777#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16775) Hibernate interoperability with SQL Server is broken when useBulkCopyForBatchInsert=true

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16775 ( https://hibernate.atlassian.net/browse/HHH-16775?atlOrigin=eyJpIjoiZDNiM2... ) Re: Hibernate interoperability with SQL Server is broken when useBulkCopyForBatchInsert=true ( https://hibernate.atlassian.net/browse/HHH-16775?atlOrigin=eyJpIjoiZDNiM2... ) Thanks Jakub Havlik ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a6759f... ) ( https://hibernate.atlassian.net/browse/HHH-16775#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16775#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16775) Hibernate interoperability with SQL Server is broken when useBulkCopyForBatchInsert=true

by Jakub Havlik (JIRA)

Jakub Havlik ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a6759f... ) *commented* on HHH-16775 ( https://hibernate.atlassian.net/browse/HHH-16775?atlOrigin=eyJpIjoiYzJjMW... ) Re: Hibernate interoperability with SQL Server is broken when useBulkCopyForBatchInsert=true ( https://hibernate.atlassian.net/browse/HHH-16775?atlOrigin=eyJpIjoiYzJjMW... ) Hi. I’ve created a minimal test case https://github.com/jakubhavlik/HHH-16775 with this latest version 6.2.4.Final and it’s also reproducible there. But after trying the latest com.microsoft.sqlserver:mssql-jdbc:12.3.0.jre17-preview version this test passed and I’ve found out this https://github.com/microsoft/mssql-jdbc/pull/1992 which means that SQL Server developers fixed it on their side and we either have to use preview version or wait. So I guess you can close this. ( https://hibernate.atlassian.net/browse/HHH-16775#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16775#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#100225- sha1:956085d )

2 years, 10 months

1
0
0 / 0

Jump to page: