May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16696) hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine)

by Suhhoruki Mihhail (JIRA)

Suhhoruki Mihhail ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ca46c8... ) *commented* on HHH-16696 ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiNDE4OT... ) Re: hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine) ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiNDE4OT... ) It seems that Eclipse was linking to older hibernate-core source when I looked up PostgreSQLDialect hierarchy (hence why it did not complain about the @Override on the old initializeFunctionRegistry ) But as I wrote - your answer led me to find org.hibernate.boot.model.FunctionContributor interface, which can be used to register custom functions without relying on Dialect. ( https://hibernate.atlassian.net/browse/HHH-16696#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16696#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16722) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone)

by humbertosales NA (JIRA)

humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16722 ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiNTU4M2... ) Re: LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone) ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiNTU4M2... ) Workaround with Converters import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.time.ZonedDateTime; import javax.persistence.AttributeConverter; import javax.persistence.Converter; @Converter(autoApply = true ) public class LocalDateTimeToTimestampConverter implements AttributeConverter<LocalDateTime, Timestamp> { @Override public Timestamp convertToDatabaseColumn(LocalDateTime attribute) { ZonedDateTime zonedDateTime = attribute.atZone(ZoneId.of( "UTC" )); return Timestamp.from(zonedDateTime.toInstant()); } @Override public LocalDateTime convertToEntityAttribute(Timestamp dbData) { return dbData.toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime(); } } ( https://hibernate.atlassian.net/browse/HHH-16722#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16722#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16725) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTgyZmI5MTU1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) HHH-16725 ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) Change By: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Having a model: {code:java}@Entity @IdClass(IdClass.class) class EntityClass { @Id private String string; @Id private int integer; @ManyToOne private EntityClass parent; @OneToMany(mappedBy = "parent") private List<EntityClass> children = new ArrayList<>(); } class IdClass { private String string; private int integer; }{code} and setting {{hibernate.order_updates}} set to {{true}} leads to an exception when multiple entities of such type are persisted within the same transaction. The problem is caused by {{ExecutableList#add()}}. Since the setting requires sorting, adding a new action tries to call compare method to see if sorting is required. But since the entity is using a composite ID the {{VirtualIdEmbeddable#compare()}} is called with {{IdClass}} instances passed into it, while {{getAttributeMappings()}} returns the attributes of {{EntityClass}} as a result: {noformat}PropertyAccessException: Error accessing field [EntityClass.integer] by reflection for persistent property [EntityClass#integer] : IdClass{..}{noformat} is thrown. I will submit a PR with the test case for this ([https://github. com/hibernate/hibernate-orm/pull/6695|https://github.com/hibernate/hibern...] ). ( https://hibernate.atlassian.net/browse/HHH-16725#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16725#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16725) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmE3NjE0ODMz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) HHH-16725 ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) Issue Type: Bug Affects Versions: 6.2.3 Assignee: Unassigned Created: 30/May/2023 10:39 AM Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Having a model: @Entity @IdClass(IdClass.class) class EntityClass { @Id private String string; @Id private int integer; @ManyToOne private EntityClass parent; @OneToMany(mappedBy = "parent" ) private List<EntityClass> children = new ArrayList<>(); } class IdClass { private String string; private int integer; } and setting hibernate.order_updates set to true leads to an exception when multiple entities of such type are persisted within the same transaction. The problem is caused by ExecutableList#add(). Since the setting requires sorting, adding a new action tries to call compare method to see if sorting is required. But since the entity is using a composite ID the VirtualIdEmbeddable#compare() is called with IdClass instances passed into it, while getAttributeMappings() returns the attributes of EntityClass as a result: PropertyAccessException: Error accessing field [EntityClass.integer] by reflection for persistent property [EntityClass#integer] : IdClass{..} is thrown. I will submit a PR with the test case for this. ( https://hibernate.atlassian.net/browse/HHH-16725#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16725#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMDU0Mj... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMDU0Mj... ) Hello Cedomir, the assertion assertEquals(CHANGED, result.get(0).getInfo(), "plain property not changed"); was only part of the code by accident. I tried to ‘force’ the entity to be dirty by changing the info-value (see commented line) and that was the assertion for this. Ignore/remove this… What did you change exactly? As far as i can see just adding the name-property to the @Entity-annotation? But that can solve be the problem 🤔 I have the impression that the transaction-handling in your test-code is slightly different compared with my test. In my test adding @Transactional(Transactional.TxType.REQUIRES_NEW) means, every method of the test-class will have it’s own new transaction. So insert, update and select run in different transactions. If i change my test-case and let all methods use the same transaction (by using @Transactional without any value, what defaults to REQUIRED), the assertion is green. So within the transaction, the persistence-context holds&returns the correct value. ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16724) Add new type for Oracle timestamp with local time zone

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGQ2M2NjODQx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) HHH-16724 ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) Add new type for Oracle timestamp with local time zone ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) Issue Type: Improvement Assignee: Unassigned Created: 30/May/2023 09:34 AM Environment: Hibernate 6.2.3.Final, Adoptium 17 JDK, Oracle 19.3 Priority: Minor Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Oracle timestamp with local time zone is currently not supported, and since version 6 introduced many type changes it would be nice if hibernate would support timestamp with local time zone out of the box. And at the moment as mentioned in issue https://hibernate.atlassian.net/browse/HHH-16723 there is no easy way to create custom type that can be treated as temporal. ( https://hibernate.atlassian.net/browse/HHH-16724#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16724#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16723) Add a way to make custom type sql code to be treated as temporal

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2I4N2M1ODg3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) HHH-16723 ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Add a way to make custom type sql code to be treated as temporal ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Issue Type: Improvement Assignee: Unassigned Created: 30/May/2023 09:23 AM Environment: Hibernate 6.2.3.Final, Adoptium 17 JDK, Oracle 19.3 Priority: Major Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It is not possible at the moment to create custom temporal type (see org.hibernate.type.SqlTypes.isTemporalType ) . Some hook should be added to allow custom type code to be treated as temporal. This is important as arguments in HQL functions are now validated and this prevents proper validation for custom types that should be temporal . Concretely oracle has timestamp with local time zone type that currently needs this. ( https://hibernate.atlassian.net/browse/HHH-16723#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16723#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16722) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone)

by humbertosales NA (JIRA)

humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDk0OGY0MjUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) HHH-16722 ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone) ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) Issue Type: Bug Affects Versions: 5.6.15 Assignee: Unassigned Components: hibernate-core Created: 30/May/2023 09:08 AM Environment: hibernate-core 5.6.15.Final quarkus 2.16.6.FINAL openjdk 17.0.7 2023-04-18 Windows 10 64 bits SQL Server 2019 or H2 Memory DB (both) Local timezone is WET Priority: Major Reporter: humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *********** The problem *********** The date 2023-03-26 is DAYLIGTH SAVING START in WET (Europe/Lisbon). The 01:00 at 2023-03-26 in timezone WET not exists. When persist this date in java.time.LocalDateTime (withou timezone) the hibernate convert it to java.sql.Timestamp (with timezone) before persist and lost the time because local timezone (JVM) is Europe/Lisbon. The JVM by convetion shift time to upper when it not exists in date time local (OS timezone). When get it data from DB, the Hibernate try re-converter timestamp to LocaDateTime, but the time is wrong and re-converter is impossible. *Atention* : the timezone JDBC properties not work here. It is used after the lost time describe. *UTC* *WET* *Description* 2023-03-26T00:00 2023-03-26T00:00 No problem 2023-03-26T01:00 2023-03-26T02:00 Problem! The time was converted to 02:00. *Not is possible determined* the original time is 01:00 or 02:00. 2023-03-26T02:00 2023-03-26T02:00 Problem. It was 01:00?! 2023-03-26T03:00 2023-03-26T03:00 No problem. ****************** The hibernate code ****************** //org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor public class LocalDateTimeJavaDescriptor extends AbstractTypeDescriptor<LocalDateTime> { //... public <X> X unwrap(LocalDateTime value, Class <X> type, WrapperOptions options) { if ( value == null ) { return null ; } if ( LocalDateTime. class. isAssignableFrom( type ) ) { return (X) value; } if ( java.sql.Timestamp. class. isAssignableFrom( type ) ) { /* * Workaround for HHH-13266 (JDK-8061577). * We used to do Timestamp.from( value.atZone( ZoneId.systemDefault() ).toInstant() ), * but on top of being more complex than the line below, it won't always work. * Timestamp.from() assumes the number of milliseconds since the epoch * means the same thing in Timestamp and Instant, but it doesn't, in particular before 1900. */ return (X) Timestamp.valueOf( value ); //THE BIG PROBLEM <<<<<<<<<< } //... } ************ The Evidence ************ ------ Entity ------ import java.time.LocalDate; import java.time.LocalDateTime; import java.util.UUID; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; import org.hibernate.annotations.GenericGenerator; import lombok.Data; @Entity @Table(name = "DT_ENTITY_WITH_DATETIME" ) @Data public class EntityWithDatetime { private static final long serialVersionUID = 1L; @Id @GeneratedValue(generator = "UUID" ) @GenericGenerator(name = "UUID" , strategy= "org.hibernate.id.UUIDGenerator" ) @Column(name= "ID" ) private UUID id; @Column(name = "CREATED_DATE" ) // @Column(name = "CREATED_DATE" , columnDefinition = "DATETIME2" ) same error // @Column(name = "CREATED_DATE" , columnDefinition = "DATETIME" ) same error private LocalDateTime createdDate; @Column(name = "DATETIME_KEY_UTC" ) private Long datetimeKeyUTC; @Column(name = "MARKET_DATE" ) private LocalDate marketDate; @Column(name = "MARKET_HOUR" ) private Integer marketHour; } ---------- Repository ---------- import javax.enterprise.context.ApplicationScoped; @ApplicationScoped public class EntityWithDatetimeRepository implements PanacheRepository<EntityWithDatetime> { } Unit tests import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertNotEquals; import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.time.ZonedDateTime; import org.junit.jupiter.api.Test; import org.junit.jupiter.api.extension.ExtendWith; import org.mockito.junit.jupiter.MockitoExtension; @ExtendWith(MockitoExtension.class) public class LocaldatetimeTimestampTest { //Test issue in org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor @Test public void testLocalDateTimeTOTimeStamp() { LocalDateTime localdatetime = LocalDateTime.parse( "2023-03-26T01:00" ); Timestamp timestamp = Timestamp.valueOf(localdatetime); assertNotEquals( "2023-03-26 01:00:00.0" , timestamp.toString()); } //Test issue in org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor //work? https://stackoverflow.com/questions/72909759/adding-minutes-to-localdatet... @Test public void testLocalDateTimeTOTimeStampTry1() { LocalDateTime localdatetime = LocalDateTime.parse( "2023-03-26T01:00" ); ZonedDateTime zonedDateTime = localdatetime.atZone(ZoneId.of( "UTC" )); Timestamp timestamp = Timestamp.from(zonedDateTime.toInstant()); LocalDateTime localDateTimeReturned = timestamp.toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime(); assertEquals( "2023-03-26T01:00" , localDateTimeReturned.toString()); } } ---------------- Integration Test ---------------- import static org.junit.jupiter.api.Assertions.assertEquals; import java.io.IOException; import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.Arrays; import java.util.List; import java.util.TimeZone; import javax.inject.Inject; import javax.persistence.EntityManager; import javax.persistence.Tuple; import javax.transaction.Transactional; import org.junit.jupiter.api.Test; import io.quarkus.panache.common.Sort; import io.quarkus.test.common.QuarkusTestResource; import io.quarkus.test.junit.QuarkusTest; @QuarkusTest public class DateTimeIntegrationTest { private static final String QuerySelectMarketDateAndHour = "Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from DT_ENTITY_WITH_DATETIME A " + "where MARKET_HOUR in (0, 1, 2, 3, 22, 23, 24) order by market_hour" ; @Inject EntityWithDatetimeRepository repository; @Inject EntityManager em; @Test //@DataSet(value = "datasets/FunctionalTest.yaml" , strategy = SeedStrategy.IDENTITY_INSERT, cleanBefore = true , fillIdentityColumns = true ) @Transactional public void test() throws IOException { EntityWithDatetime entity00 = createEntityWithDateTime( "2023-03-26T00:00" ); EntityWithDatetime entity01 = createEntityWithDateTime( "2023-03-26T01:00" ); EntityWithDatetime entity02 = createEntityWithDateTime( "2023-03-26T02:00" ); EntityWithDatetime entity03 = createEntityWithDateTime( "2023-03-26T03:00" ); repository.persist(Arrays.asList(entity00, entity01, entity02, entity03)); assertEquals(4, repository.findAll().count()); //lastversion List<Tuple> resultList = em.createNativeQuery(QuerySelectMarketDateAndHour, Tuple.class).getResultList(); System.out.println(QuerySelectMarketDateAndHour); for (Tuple tuple : resultList) { Object [] cols = tuple.toArray(); for ( Object col : cols) { if (col instanceof Timestamp) { System.out.print( String.format( "%s (%s) (%s %s) \t" , col, ((Timestamp) col).toGMTString(), ((Timestamp) col).toLocaleString(), TimeZone.getDefault().toZoneId().toString())); } else { System.out.print( String.format( "%s \t" , col)); } } System.out.println(""); } assertEquals( "2023-03-26T00:00" , ((Timestamp)resultList.get(0).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T01:00" , ((Timestamp)resultList.get(1).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T02:00" , ((Timestamp)resultList.get(2).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T03:00" , ((Timestamp)resultList.get(3).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); System.out.println( "ENTITIES PRINTS" ); List<EntityWithDatetime> listAll = repository.findAll(Sort.by( "marketHour" )).list(); for (EntityWithDatetime entity : listAll) { System.out.println(entity); } assertEquals( "2023-03-26T00:00" , listAll.get(0).getCreatedDate().toString()); assertEquals( "2023-03-26T01:00" , listAll.get(1).getCreatedDate().toString()); assertEquals( "2023-03-26T02:00" , listAll.get(2).getCreatedDate().toString()); assertEquals( "2023-03-26T03:00" , listAll.get(3).getCreatedDate().toString()); } private EntityWithDatetime createEntityWithDateTime( String datetimeCET) { EntityWithDatetime entity = new EntityWithDatetime(); entity.setCreatedDate(LocalDateTime.parse(datetimeCET)); entity.setMarketHour(entity.getCreatedDate().getHour()); //MyDateBusinessToUTC calculate it in UTC.... irrelevant business code!! MyDateBusinessToUTC dateBUTC = new MyDateBusinessToUTC(entity.getCreatedDate(), ZoneId.of( "Europe/Lisbon" )); entity.setMarketDate(dateBUTC.getMarketDate()); entity.setDatetimeKeyUTC(dateBUTC.getDatetimeKeyUtcHour()); return entity; } } ---------- The return ---------- Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,839 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T00:00] 2023-05-30 17:00:55,845 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032600] 2023-05-30 17:00:55,846 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,846 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [0] 2023-05-30 17:00:55,847 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [1d29f0d8-7f5a-4b58-b6c9-c22d0b4a1d61] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,849 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T01:00] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032601] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [1] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [e6084c0c-efbe-4ffa-a5f7-76e9ddfd1d48] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,851 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T02:00] 2023-05-30 17:00:55,851 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032601] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [2] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [b3318092-94e4-4d83-bc16-c0ec65c95e14] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T03:00] 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032602] 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,854 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [3] 2023-05-30 17:00:55,854 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [b2b0dc24-0f5e-403d-8d45-a806f4e33b7f] Hibernate: select count(*) as col_0_0_ from DT_ENTITY_WITH_DATETIME entitywith0_ Hibernate: Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from ODS.DT_ENTITY_WITH_DATETIME A where MARKET_HOUR in ( 0, 1, 2, 3, 22, 23, 24 ) order by market_hour Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from ODS.DT_ENTITY_WITH_DATETIME A where MARKET_HOUR in (0, 1, 2, 3, 22, 23, 24) order by market_hour 2023-03-26 00:00:00.0 (26 Mar 2023 00:00:00 GMT) (26 de mar de 2023 00:00:00 Europe/London) 0 2023032600 2023-03-26 02:00:00.0 (26 Mar 2023 01:00:00 GMT) (26 de mar de 2023 02:00:00 Europe/London) 1 2023032601 2023-03-26 02:00:00.0 (26 Mar 2023 01:00:00 GMT) (26 de mar de 2023 02:00:00 Europe/London) 2 2023032601 2023-03-26 03:00:00.0 (26 Mar 2023 02:00:00 GMT) (26 de mar de 2023 03:00:00 Europe/London) 3 2023032602 ************** The Reference: ************** See org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor. See https://savvytime.com/converter/utc-to-wet/mar-26-2023/1-15am *********** Workaround: *********** Create Types overwrites, forcing ALWAYS timezone UTC. //org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor if ( java.sql.Timestamp. class. isAssignableFrom( type ) ) { ZonedDateTime zonedDateTime = value.atZone(zoneUTC); return (X) Timestamp.from(zonedDateTime.toInstant()); } ( https://hibernate.atlassian.net/browse/HHH-16722#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16722#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:d82e018 )

1 year

1
0
0 / 0

[JIRA] (HHH-16721) HQL with subquery with entity path at least two deep produces wrong SQL

by Nemanja Jovanovic (JIRA)

1 year

1
0
0 / 0

[JIRA] (HHH-16540) UnknownTableReferenceException for entity with Embeddable key-value in map

by Marco Belladelli (JIRA)

1 year

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues May 2023