September 2022 - hibernate-issues

[JIRA] (HHH-15517) "insert from select" With hibernate.default_schema Configured Doesn't Work With Hibernate 6

by Kai Zander (JIRA)

Kai Zander ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517?atlOrigin=eyJpIjoiYmE3Zj... ) Re: "insert from select" With hibernate.default_schema Configured Doesn't Work With Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-15517?atlOrigin=eyJpIjoiYmE3Zj... ) Thanks for the reply! Here are the entity classes: @Getter @Setter @MappedSuperclass @EqualsAndHashCode(onlyExplicitlyIncluded = true ) public abstract sealed class BaseTabData permits TabData, TabDataStaging { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "tab_data_seq" ) @SequenceGenerator(name = "tab_data_seq" , sequenceName = "tab_data_seq" , allocationSize = 500) private Long id; @EqualsAndHashCode.Include private String col1; @EqualsAndHashCode.Include private String col2; @EqualsAndHashCode.Include private String col3; } @Entity @NamedQuery(name = "TabData.copyFromStaging" , query = """ insert into TabData ( id, col1, col2, col3 ) select max(id), col1, col2, col3 from TabDataStaging group by col1, col2, col3""") public final class TabData extends BaseTabData {} @Entity public final class TabDataStaging extends BaseTabData {} I have an integration test running against H2 that does the following: * Insert 500 rows into tab_data_staging * Clear tab_data * Copy all rows from tab_data_staging into tab_data (using the TabData.copyFromStaging named query). Here’s the log output running with Hibernate 5: 2022-09-16 09:18:48.063Z INFO [Pool-1-worker-1] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context 2022-09-16 09:18:48.071Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : call next value for tab_data_seq 2022-09-16 09:18:48.072Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : call next value for tab_data_seq 2022-09-16 09:18:48.081Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data_staging (col2, col1, col3, id) values (?, ?, ?, ?) ... 498 identical insert statements 2022-09-16 09:18:48.096Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data_staging (col2, col1, col3, id) values (?, ?, ?, ?) 2022-09-16 09:18:48.102Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : delete from tab_data 2022-09-16 09:18:48.103Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data ( id, col1, col2, col3 ) select max(tabdatasta0_.id) as col_0_0_, tabdatasta0_.col1 as col_1_0_, tabdatasta0_.col2 as col_2_0_, tabdatasta0_.col3 as col_3_0_ from tab_data_staging tabdatasta0_ group by tabdatasta0_.col1 , tabdatasta0_.col2 , tabdatasta0_.col3 2022-09-16 09:18:48.110Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : select tabdatasta0_.id as id1_20_, tabdatasta0_.col2 as product_2_20_, tabdatasta0_.col1 as product_3_20_, tabdatasta0_.col3 as col34_20_ from tab_data tabdatasta0_ 2022-09-16 09:18:48.120Z INFO [Pool-1-worker-1] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test Here’s the log output running with Hibernate 6 (notice there are no update statements against the HTE table): 2022-09-14T17:50:35.275Z INFO [Pool-1-worker-1] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context 2022-09-14T17:50:35.282Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : select next value for tab_data_seq 2022-09-14T17:50:35.282Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : select next value for tab_data_seq 2022-09-14T17:50:35.287Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data_staging (col2, col1, col3, id) values (?, ?, ?, ?) ... 498 identical insert statements 2022-09-14T17:50:35.301Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data_staging (col2, col1, col3, id) values (?, ?, ?, ?) 2022-09-14T17:50:35.305Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : delete from tab_data 2022-09-14T17:50:35.305Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : create local temporary table HTE_tab_data(id bigint, col2 varchar(255), col1 varchar(255), col3 varchar(255), rn_ integer not null, primary key (rn_)) 2022-09-14T17:50:35.307Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into HTE_tab_data(id,col1,col2,col3,rn_) (select max(p2_0.id),p2_0.col1,p2_0.col2,p2_0.col3,row_number() over() from tab_data_staging p2_0 group by p2_0.col1,p2_0.col2,p2_0.col3) 2022-09-14T17:50:35.313Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : insert into tab_data(id,col1,col2,col3) select p1_0.id,p1_0.col1,p1_0.col2,p1_0.col3 from HTE_tab_data p1_0 2022-09-14T17:50:35.316Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : delete from HTE_tab_data 2022-09-14T17:50:35.319Z DEBUG [Pool-1-worker-1] org.hibernate.SQL : select p1_0.id,p1_0.col2,p1_0.col1,p1_0.col3 from tab_data p1_0 2022-09-14T17:50:35.327Z INFO [Pool-1-worker-1] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test I have hibernate.jdbc.batch_size=1000 configured, if that matters. ( https://hibernate.atlassian.net/browse/HHH-15517#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15517#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4703) HSearch Outbox table module -> inaccesible private field error using Java 9 modules

by Yasin Koyuncu (JIRA)

Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMTE2OTll... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-4703?atlOrigin=eyJpIjoiMTE... ) HSEARCH-4703 ( https://hibernate.atlassian.net/browse/HSEARCH-4703?atlOrigin=eyJpIjoiMTE... ) HSearch Outbox table module -> inaccesible private field error using Java 9 modules ( https://hibernate.atlassian.net/browse/HSEARCH-4703?atlOrigin=eyJpIjoiMTE... ) Issue Type: Bug Affects Versions: 6.1.7.Final Assignee: Unassigned Created: 19/Sep/2022 03:56 AM Priority: Major Reporter: Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hi, I am having some issues with certain fields not being able to be accessed when using Java 9 modules in my project. Caused by: java.lang.reflect.InaccessibleObjectException: Unable to make field private java.lang.Long org.hibernate.search.mapper.orm.coordination.outboxpolling.cluster.impl.Agent.id ( http://org.hibernate.search.mapper.orm.coordination.outboxpolling.cluster... ) accessible: module org.hibernate.search.mapper.orm.coordination.outboxpolling does not "opens org.hibernate.search.mapper.orm.coordination.outboxpolling.cluster.impl" to module org.hibernate.orm.core at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:354) at java.base/java.lang.reflect.AccessibleObject.checkCanSetAccessible(AccessibleObject.java:297) at java.base/java.lang.reflect.Field.checkCanSetAccessible(Field.java:178) at java.base/java.lang.reflect.Field.setAccessible(Field.java:172) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.internal.util.ReflectHelper.ensureAccessibility(ReflectHelper.java:418) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.internal.util.ReflectHelper.findField(ReflectHelper.java:408) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.property.access.internal.PropertyAccessMixedImpl.fieldOrNull(PropertyAccessMixedImpl.java:84) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.property.access.internal.PropertyAccessMixedImpl.getAccessType(PropertyAccessMixedImpl.java:92) at org.hibernate.orm.core(a)5.6.10.Final/org.hibernate.property.access.internal.PropertyAccessMixedImpl.<init>(PropertyAccessMixedImpl.java:47) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.property.access.internal.PropertyAccessStrategyMixedImpl.buildPropertyAccess(PropertyAccessStrategyMixedImpl.java:25) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.internal.util.ReflectHelper.getter(ReflectHelper.java:238) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.internal.util.ReflectHelper.reflectedPropertyClass(ReflectHelper.java:218) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.mapping.SimpleValue.setTypeUsingReflection(SimpleValue.java:542) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.boot.model.source.internal.hbm.ModelBinder.bindSimpleEntityIdentifier(ModelBinder.java:732) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.boot.model.source.internal.hbm.ModelBinder.bindEntityIdentifier(ModelBinder.java:351) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.boot.model.source.internal.hbm.ModelBinder.bindRootEntity(ModelBinder.java:246) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.boot.model.source.internal.hbm.ModelBinder.bindEntityHierarchy(ModelBinder.java:193) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:319) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1460) at org.hibernate.orm.core@5.6.10.Final/org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1494) at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) at spring.beans@5.3.22/org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) at spring.beans@5.3.22/org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) I had a similar issue with Java 9 modules which was fixed earlier. ( https://hibernate.atlassian.net/browse/HSEARCH-4703#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4703#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15517) "insert from select" With hibernate.default_schema Configured Doesn't Work With Hibernate 6

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517?atlOrigin=eyJpIjoiMjZjY2... ) Re: "insert from select" With hibernate.default_schema Configured Doesn't Work With Hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-15517?atlOrigin=eyJpIjoiMjZjY2... ) To answer your first question, I would need to see the entity model used for tab_data. I suspect that the entity is using a sequence generator with an allocation size bigger than 1 though, as that will make some intermediate steps necessary, because the sequence gives a value e.g. 1, but we have to generate the next N-1 values manually, as the next sequence call will give use N+1. Between the insert into the HTE table and the insert to the target table you should see some update statements happening against the HTE table, which assign proper id values based on the sequence generator. I don’t know what Hibernate 5 did before, but I suspect you are using {{@GeneratedValue(AUTO)}}which might have defaulted to using identity generation or SEQUENCE with an allocation size of 1 before. In Hibernate 6 the default for AUTO is SEQUENCE with an allocation size of 50 though. I’ll look into the schema prefixing issue as part of this Jira issue. I also created https://hibernate.atlassian.net/browse/HHH-15525 ( https://hibernate.atlassian.net/browse/HHH-15525 ) as an improvement, which will allow to control whether global temporary tables should be created/dropped as part of hbm2ddl or as part of the running transaction. ( https://hibernate.atlassian.net/browse/HHH-15517#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15517#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15525) Allow GlobalTemporaryTable to participate in hbm2ddl

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjliZmRlNDE5... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNjliZm... ) HHH-15525 ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNjliZm... ) Allow GlobalTemporaryTable to participate in hbm2ddl ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNjliZm... ) Issue Type: Improvement Assignee: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 19/Sep/2022 03:42 AM Fix Versions: 6.2.0 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) https://hibernate.atlassian.net/browse/HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517 ) has shown again that the creation of temporary tables might not always be possible with the database user which is used for normal operations. For global temporary tables, we could emit the DDL in hbm2ddl instead and skip creating/dropping tables during runtime. I suggest we introduce a configuration option for controlling this. ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15525#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15523) Missing use of SqlStringGenerationContext in MapBinder#getFromAndWhereFormula

by Christian Beikov (JIRA)

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15517) "insert from select" With hibernate.default_schema Configured Doesn't Work With Hibernate 6

by Christian Beikov (JIRA)

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15524) Entity with bytecode enhancement is being re-initalized on lazy-load causing reset of parent dirty tracking

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15524 ( https://hibernate.atlassian.net/browse/HHH-15524?atlOrigin=eyJpIjoiMDZiZD... ) Re: Entity with bytecode enhancement is being re-initalized on lazy-load causing reset of parent dirty tracking ( https://hibernate.atlassian.net/browse/HHH-15524?atlOrigin=eyJpIjoiMDZiZD... ) Hi Ben Ganley ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5fc058e... ) , can you please provide a reproducer? Thanks ( https://hibernate.atlassian.net/browse/HHH-15524#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15524#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15524) Entity with bytecode enhancement is being re-initalized on lazy-load causing reset of parent dirty tracking

by Ben Ganley (JIRA)

Ben Ganley ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5fc058e... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzlkNTk3Yjc3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15524?atlOrigin=eyJpIjoiYzlkNT... ) HHH-15524 ( https://hibernate.atlassian.net/browse/HHH-15524?atlOrigin=eyJpIjoiYzlkNT... ) Entity with bytecode enhancement is being re-initalized on lazy-load causing reset of parent dirty tracking ( https://hibernate.atlassian.net/browse/HHH-15524?atlOrigin=eyJpIjoiYzlkNT... ) Issue Type: Bug Affects Versions: 5.6.11 Assignee: Unassigned Attachments: image-20220919-092433.png, image-20220919-092454.png, image-20220919-092511.png, image-20220919-092529.png Components: bytecode-enhancement Created: 19/Sep/2022 02:28 AM Environment: Hibernate 5.6.11.Final Java 18 Postgres 13 Priority: Major Reporter: Ben Ganley ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5fc058e... ) Experiencing issues where after updates to a Hibernate entity, no updated data is being flushed to the database. After some debugging, traces show that lazy-loading an entity is causing the entity to be re-initialized, clearing any fields marked as dirty. Prior to lazy-load of relation After to lazy load of relation Trace from lazy load We have currently worked around this issue in our code base by calling either Hibernate.initialize() or eager loading this relation for the services its needed. ( https://hibernate.atlassian.net/browse/HHH-15524#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15524#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-13735) 'A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance' when persisting, flushing, detaching and merging an Entity in the same Session (using Bytecode enhancement)

by Jens Fischer (JIRA)

Jens Fischer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-13735 ( https://hibernate.atlassian.net/browse/HHH-13735?atlOrigin=eyJpIjoiNGViNG... ) Re: 'A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance' when persisting, flushing, detaching and merging an Entity in the same Session (using Bytecode enhancement) ( https://hibernate.atlassian.net/browse/HHH-13735?atlOrigin=eyJpIjoiNGViNG... ) Same problem here. Does anybody know a workaround? ( https://hibernate.atlassian.net/browse/HHH-13735#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13735#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#100207- sha1:7afd384 )

2 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15523) Missing use of SqlStringGenerationContext in MapBinder#getFromAndWhereFormula

by Christian Beikov (JIRA)

2 years, 1 month

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 September 2022