May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16542) (Jakarta EE 10 Platform TCK) jpa/core/entitytest/cascadeall/oneXone/cascadeAll1X1Test10 test regression

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16557) NaturalIdCache remains with wrong key-value after create-delete-recreate action

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmNiZTEzNGEz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiYmNiZT... ) HHH-16557 ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiYmNiZT... ) NaturalIdCache remains with wrong key-value after create-delete-recreate action ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiYmNiZT... ) Change By: Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Precondition: We have an entity class annotated with NaturalIdCache and the choosen strategy is CacheConcurrencyStrategy.READ_WRITE. When persisting & deleting such an entity object within the same transaction, after the commit we remain with an obsolete cache entry (key=<naturalid-value> value=<primary key>) If we now create another persistent object with the same naturalId value, this cannot be resolved anymore from shared cache anymore because the cache entry points to an obsolete (deleted) primary key. {noformat} scope.inTransaction( (session) -> { AllCached it = new AllCached( "it" ); session.persist(it); session.remove(it); } ); // now recreate with same naturarId naturalId value scope.inTransaction( (session) -> { AllCached it = new AllCached( "it" ); session.persist(it); } ); scope.inTransaction( (session) -> { final AllCached shouldBeThere = session.bySimpleNaturalId( AllCached.class ).load( "it" ); assertNotNull( shouldBeThere ); // FAILS!!!! } ); {noformat} For more informations please see upcoming Pullrequest which will contain a testcase and a fix proposal. ( https://hibernate.atlassian.net/browse/HHH-16557#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16557#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:f83bc8f )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16557) NaturalIdCache remains with wrong key-value after create-delete-recreate action

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16557 ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiZTc0Yj... ) Re: NaturalIdCache remains with wrong key-value after create-delete-recreate action ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiZTc0Yj... ) Explanation: the problem is that with ReadWrite Access strategy the insertion of a new cache entry get deferred to afterTransactionCompletion. (see NaturalIdReadWriteAccess.java methods insert and afterInsert). Thus the order of insert/delete get inverted: * ActionQueue processes inserts → insertion of a new cache entry get deferred to afterTransactionCompletion. * ActionQueue processes deletes→ removal of according cache entry (does not exist yet) * afterTransactionCompletion process → insertion of a cache entry with obsolete value Later when creating a new instance with same NaturalId then the cache get not updated bacause of the existing entry. As we see in the code below from NaturalIdReadWriteAccess.java the entry will only be created if not existing already. @Override public boolean afterInsert(SharedSessionContractImplementor session, Object key, Object value) { try { writeLock().lock(); Lockable item = (Lockable) getStorageAccess().getFromCache( key, session ); if ( item == null) { getStorageAccess().putIntoCache( key, new Item( value, null, getRegion().getRegionFactory().nextTimestamp() ), session ); ( https://hibernate.atlassian.net/browse/HHH-16557#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16557#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:f83bc8f )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16557) NaturalIdCache remains with wrong key-value after create-delete-recreate action

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDJmMDgwZjM2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiZDJmMD... ) HHH-16557 ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiZDJmMD... ) NaturalIdCache remains with wrong key-value after create-delete-recreate action ( https://hibernate.atlassian.net/browse/HHH-16557?atlOrigin=eyJpIjoiZDJmMD... ) Issue Type: Bug Affects Versions: 5.6.13, 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 05/May/2023 02:03 AM Environment: Normal environment using 2ndLevel-Cache. Working on entity classes configured for shared cache with StrictReadWrite Access strategy & NaturalIdCache Labels: CacheConcurrencyStrategy.READ_WRITE NaturalIdCache Priority: Major Reporter: Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Original estimate: 1h Remaining Estimate: 1h Precondition: We have an entity class annotated with NaturalIdCache and the choosen strategy is CacheConcurrencyStrategy.READ_WRITE. When persisting & deleting such an entity object within the same transaction, after the commit we remain with an obsolete cache entry (key=<naturalid-value> value=<primary key>) If we now create another persistent object with the same naturalId value, this cannot be resolved anymore from shared cache anymore because the cache entry points to an obsolete (deleted) primary key. scope.inTransaction( (session) -> { AllCached it = new AllCached( "it" ); session.persist(it); session.remove(it); } ); // now recreate with same naturarId value scope.inTransaction( (session) -> { AllCached it = new AllCached( "it" ); session.persist(it); } ); scope.inTransaction( (session) -> { final AllCached shouldBeThere = session.bySimpleNaturalId( AllCached.class ).load( "it" ); assertNotNull( shouldBeThere ); // FAILS!!!! } ); For more informations please see upcoming Pullrequest which will contain a testcase and a fix proposal. ( https://hibernate.atlassian.net/browse/HHH-16557#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16557#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:f83bc8f )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16556) SQLServer2016Dialect deprecation javadoc has wrong version

by Vincent Jansen (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16556) SQLServer2016Dialect deprecation javadoc has wrong version

by Vincent Jansen (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16556) SQLServer2016Dialect deprecation javadoc has wrong version

by Vincent Jansen (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16556) SQLServer2016Dialect deprecation message has wrong version

by Vincent Jansen (JIRA)

Vincent Jansen ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjBjNTljNDRj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16556?atlOrigin=eyJpIjoiYjBjNT... ) HHH-16556 ( https://hibernate.atlassian.net/browse/HHH-16556?atlOrigin=eyJpIjoiYjBjNT... ) SQLServer2016Dialect deprecation message has wrong version ( https://hibernate.atlassian.net/browse/HHH-16556?atlOrigin=eyJpIjoiYjBjNT... ) Issue Type: Bug Assignee: Vincent Jansen ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 05/May/2023 01:30 AM Priority: Minor Reporter: Vincent Jansen ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In SQLServer2016Dialect the deprecation says use SQLServerDialect(11). @deprecated use {@code SQLServerDialect(11)} I think this should be SQLServerDialect(13) as this is also the version used in the constructor and is the “internal version”. ( https://hibernate.atlassian.net/browse/HHH-16556#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16556#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:f83bc8f )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16554) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements

by Ahmet Tanakol (JIRA)

Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDRmNDE1YTJm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMDRmND... ) HHH-16554 ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMDRmND... ) UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements ( https://hibernate.atlassian.net/browse/HHH-16554?atlOrigin=eyJpIjoiMDRmND... ) Change By: Ahmet Tanakol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, I was updating our SpringBoot version from 2.x to 3.x, and I am having trouble with starting our app. I created the tables by using liquibase in the past. When I start my application I see the below exception. {code:java} Suppressed: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used with Dialects that support CTE that can take UPDATE or DELETE statements as well at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:123) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.query.sqm.mutation.internal.cte.CteInsertStrategy.<init>(CteInsertStrategy.java:107) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final] at org.hibernate.dialect.PostgreSQLDialect.getFallbackSqmInsertStrategy(PostgreSQLDialect.java:828) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]{code} One of my entites looks like the following (I created the sequence in liquibase changelog file); {noformat}import com.fasterxml.jackson.annotation.JsonIgnore; import java.time.OffsetDateTime; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; import org.hibernate.annotations.CreationTimestamp; import org.hibernate.annotations.GenericGenerator; import org.hibernate.annotations.Parameter; import org.hibernate.annotations.UpdateTimestamp; import org.hibernate.envers.Audited; @Data @Entity @Builder @NoArgsConstructor @AllArgsConstructor @Audited public class PaymentAccount { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "payment_account_seq") @GenericGenerator( name = "payment_account_seq", strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator", parameters = {@Parameter(name = "sequence_name", value = "payment_account_seq")}) @JsonIgnore private Long id; private String ciamId userId ; private String providerName; private String providerUserId; @CreationTimestamp @Column(updatable = false) private OffsetDateTime createdAt; @UpdateTimestamp private OffsetDateTime updatedAt; } {noformat} I couldn’t be sure what is causing this issue. I would appreciate if you can help me solve it. You can find the configuration I use below. * hibernate-envers: 6.1.7.Final * hibernate-core: 6.1.7.Final * hibernate-commons-annotations:6.0.6.Final * spring-boot-starter-data-jpa:3.0.6 * postgresql jdbc driver:42.5.4 * postgres 14 {noformat} datasource: url: jdbc:postgresql://localhost:8086/mydb username: admin password: admin driver-class-name: org.postgresql.Driver hikari: maximum-pool-size: 12 idle-timeout: 60000 pool-name: BackendHikariPool connection-timeout: 45000 minimum-idle: 1 connection-test-query: SELECT 1 type: com.zaxxer.hikari.HikariDataSource jpa: show-sql: false open-in-view: false hibernate: ddl-auto: none properties: org.hibernate.envers.do_not_audit_optimistic_locking_field: false hibernate: namingStrategy: org.hibernate.cfg.ImprovedNamingStrategy dialect: org.hibernate.dialect.PostgreSQLDialect hbm2ddl: auto: none temp: use_jdbc_metadata_defaults: false sql: init: continue-on-error: true platform: org.hibernate.dialect.PostgreSQLDialect{noformat} ( https://hibernate.atlassian.net/browse/HHH-16554#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16554#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:f83bc8f )

2 years, 11 months

1
0
0 / 0

[JIRA] (HBX-2073) Investigate and reenable failing test 'org.hibernate.tool.hbm2x.hbm2hbmxml.FormulaTest.TestCase#testReadable()'

by Koen Aers (JIRA)

2 years, 11 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 May 2023