January 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16034) CASE Statement in jpql throws assertion error when running H2 in Oracle mode with OracleDialect

by Vijayasaradhi Danda (JIRA)

Vijayasaradhi Danda ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmJkMDU2ODIz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16034?atlOrigin=eyJpIjoiYmJkMD... ) HHH-16034 ( https://hibernate.atlassian.net/browse/HHH-16034?atlOrigin=eyJpIjoiYmJkMD... ) CASE Statement in jpql throws assertion error when running H2 in Oracle mode with OracleDialect ( https://hibernate.atlassian.net/browse/HHH-16034?atlOrigin=eyJpIjoiYmJkMD... ) Issue Type: Bug Affects Versions: 6.1.6 Assignee: Unassigned Components: query-hql Created: 12/Jan/2023 11:41 AM Environment: OpenJDK Runtime Environment (build 17.0.2+8-86), Mac OS Monterey Version 12.6.2, H2 2.1.214 Priority: Blocker Reporter: Vijayasaradhi Danda ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) We have been using H2 for our db integration tests running it in Oracle mode (MODE=Oracle since our production database is Oracle. Then we used to use OracleDialect to make sure genereated sqls would be reasonably Oracle compliant. That way each developer working on db access code could easily run db integration tests quickly on their workstations. We upgraded from hibernate version 5.6.8 using org.hibernate.dialect.OracleDialect to version 6.1.6 again using org.hibernate.dialect.OracleDialect and one of our jpql queries failed that was using CASE statement for its order by clause with java.lang.AssertionError at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.getLeftHandExpression(AbstractSqlAstTranslator.java:593) at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitDecodeCaseSearchedExpression(AbstractSqlAstTranslator.java:4888) Debugging it we found that OracleSqlAstTranslator gets Oracle version through OracleDialect class which in turn relies on H2 db driver version returning version 1-2 resulting line 420 picking visitDecodeCaseSearchedExpression instead of super.visitCaseSearchedExpression resulting in the error. That seems to be a minor error but we would appreciate if you could devise a solution otherwise we don’t know how to get our unit tests working. ( https://hibernate.atlassian.net/browse/HHH-16034#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16034#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15906) Hibernate 6 create EMF exception

by Rob Scala (JIRA)

Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15906 ( https://hibernate.atlassian.net/browse/HHH-15906?atlOrigin=eyJpIjoiOTUwYj... ) Re: Hibernate 6 create EMF exception ( https://hibernate.atlassian.net/browse/HHH-15906?atlOrigin=eyJpIjoiOTUwYj... ) Interesting. Did you run it in version 6.1.6.Final? I tried 6.2.0.CR ( http://6.2.0.CR ) 1, and it started working for me. ( https://hibernate.atlassian.net/browse/HHH-15906#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15906#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15966) ElementCollection with nested Embeddables fails with ArrayIndexOutOfBoundsException

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15604) Identically-named association in entity root and elementcollection of embeddables leads to assertion error

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15955) Hibernate 6.1.6 Never Uses LimitHandler w/ DB2

by Matt Henry (JIRA)

Matt Henry ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bff329... ) *commented* on HHH-15955 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiZTI1MD... ) Re: Hibernate 6.1.6 Never Uses LimitHandler w/ DB2 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiZTI1MD... ) I think that should be okay for now 😄 ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15955#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16033) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal

by William Rosenquist Burns (JIRA)

William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjU5MGQ2MjYy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiYjU5MG... ) HHH-16033 ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiYjU5MG... ) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiYjU5MG... ) Change By: William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) While updating Infinispan 2LC to use Hibernate 6.2.0 from 6.0.2 we found a regression with how many to many mappings do a removal. It seems to be trying to use the primary key identifier instead of the foreign key field. This is a problem for a test as the primary key is a Long and the foreign key is a String. This causes a ClassCastException when it tries to remove any many-to-many mappings that may exist. {noformat} <bag name="bagOfItems" inverse="true" table="items_otheritems"> <key column="other_item_id"/> <many-to-many class="Item" property-ref="name" column="item_name" /> </bag>{noformat} This mapping is the underlying cause. The test just creates an entity in one session, then in a second loads it and removes it, quite simple. PR will be attached after. The stack trace is as follows from the [PR|https://github.com/hibernate/hibernate-orm/pull/5945] {noformat}java.lang.ClassCastException: class java.lang.Long cannot be cast to class java.lang.String (java.lang.Long and java.lang.String are in module java.base of loader 'bootstrap') at org.hibernate.type.descriptor.java.StringJavaType.unwrap(StringJavaType.java:27) at org.hibernate.type.descriptor.jdbc.VarcharJdbcType$1.doBind(VarcharJdbcType.java:110) at org.hibernate.type.descriptor.jdbc.BasicBinder.bind(BasicBinder.java:61) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:87) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at org.hibernate.engine.jdbc.mutation.spi.BindingGroup.forEachBinding(BindingGroup.java:51) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.beforeStatement(JdbcValueBindingsImpl.java:85) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.performNonBatchedMutation(AbstractMutationExecutor.java:93) at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleNonBatched.performNonBatchedOperations(MutationExecutorSingleNonBatched.java:40) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:43) at org.hibernate.persister.collection.mutation.RemoveCoordinatorStandard.deleteAllRows(RemoveCoordinatorStandard.java:113) at org.hibernate.persister.collection.AbstractCollectionPersister.remove(AbstractCollectionPersister.java:1124) at org.hibernate.action.internal.CollectionRemoveAction.execute(CollectionRemoveAction.java:112) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:616) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:487) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:329) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:58) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1403) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:476) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2269) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1933) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:426) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) at org.hibernate.testing.orm.transaction.TransactionUtil.wrapInTransaction(TransactionUtil.java:54) at org.hibernate.testing.orm.transaction.TransactionUtil.inTransaction(TransactionUtil.java:24) at org.hibernate.testing.orm.junit.SessionFactoryExtension$SessionFactoryScopeImpl.inTransaction(SessionFactoryExtension.java:375) at org.hibernate.testing.orm.junit.SessionFactoryExtension$SessionFactoryScopeImpl.inTransaction(SessionFactoryExtension.java:352) at org.hibernate.orm.test.manytomanyassociationclass.nestedreference.ItemSelfReferenceTest.testSimpleCreateAndDelete(ItemSelfReferenceTest.java:31){noformat} ( https://hibernate.atlassian.net/browse/HHH-16033#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16033#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15928) Distinct with maxResults fails under SQLServer

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16033) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal

by William Rosenquist Burns (JIRA)

William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmY1NTMyNDM4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiMmY1NT... ) HHH-16033 ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiMmY1NT... ) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiMmY1NT... ) Change By: William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) While updating Infinispan 2LC to use Hibernate 6.2.0 from 6.0.2 we found a regression with how many to many mappings do a removal. It seems to be trying to use the primary key identifier instead of the foreign key field. This is a problem for a test as the primary key is a Long and the foreign key is a String. This causes a ClassCastException when it tries to remove any many-to-many mappings that may exist. {noformat} <bag name="bagOfItems" inverse="true" table="items_otheritems"> <key column="other_item_id"/> <many-to-many class="Item" property-ref="name" column="item_name" /> </bag>{noformat} This mapping is the underlying cause. The test just creates an entity in one session, then in a second loads it and removes it, quite simple. PR will be attached after. The stack trace is as follows from the [PR|https://github.com/hibernate/hibernate-orm/pull/5945] {noformat}java.lang.ClassCastException: class java.lang.Long cannot be cast to class java.lang.String (java.lang.Long and java.lang.String are in module java.base of loader 'bootstrap') at org.hibernate.type.descriptor.java.StringJavaType.unwrap(StringJavaType.java:27) at org.hibernate.type.descriptor.jdbc.VarcharJdbcType$1.doBind(VarcharJdbcType.java:110) at org.hibernate.type.descriptor.jdbc.BasicBinder.bind(BasicBinder.java:61) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:87) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at org.hibernate.engine.jdbc.mutation.spi.BindingGroup.forEachBinding(BindingGroup.java:51) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.beforeStatement(JdbcValueBindingsImpl.java:85) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.performNonBatchedMutation(AbstractMutationExecutor.java:93) at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleNonBatched.performNonBatchedOperations(MutationExecutorSingleNonBatched.java:40) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:43) at org.hibernate.persister.collection.mutation.RemoveCoordinatorStandard.deleteAllRows(RemoveCoordinatorStandard.java:113) at org.hibernate.persister.collection.AbstractCollectionPersister.remove(AbstractCollectionPersister.java:1124) at org.hibernate.action.internal.CollectionRemoveAction.execute(CollectionRemoveAction.java:112) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:616) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:487) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:329) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:58) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1403) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:476) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2269) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1933) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:426) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) at org.hibernate.testing.orm.transaction.TransactionUtil.wrapInTransaction(TransactionUtil.java:54) at org.hibernate.testing.orm.transaction.TransactionUtil.inTransaction(TransactionUtil.java:24) at org.hibernate.testing.orm.junit.SessionFactoryExtension$SessionFactoryScopeImpl.inTransaction(SessionFactoryExtension.java:375) at org.hibernate.testing.orm.junit.SessionFactoryExtension$SessionFactoryScopeImpl.inTransaction(SessionFactoryExtension.java:352) at org.hibernate.orm.test.manytomanyassociationclass.nestedreference.ItemSelfReferenceTest.testSimpleCreateAndDelete(ItemSelfReferenceTest.java:31){noformat} ( https://hibernate.atlassian.net/browse/HHH-16033#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16033#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16033) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal

by William Rosenquist Burns (JIRA)

William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) *commented* on HHH-16033 ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiYTBkYz... ) Re: Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiYTBkYz... ) This seems to be related to https://hibernate.atlassian.net/browse/HHH-16031 ( https://hibernate.atlassian.net/browse/HHH-16031 ) , but I am not sure if it is the same cause or not. ( https://hibernate.atlassian.net/browse/HHH-16033#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16033#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#100214- sha1:b03f6a4 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16033) Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal

by William Rosenquist Burns (JIRA)

William Rosenquist Burns ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a7b38f... ) *commented* on HHH-16033 ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiMTc2OD... ) Re: Many-to-Many inverse mapping referencing the same class uses pk instead of fk field for removal ( https://hibernate.atlassian.net/browse/HHH-16033?atlOrigin=eyJpIjoiMTc2OD... ) Reproducer is at https://github.com/hibernate/hibernate-orm/pull/5945 ( https://github.com/hibernate/hibernate-orm/pull/5945 ) ( https://hibernate.atlassian.net/browse/HHH-16033#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16033#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#100214- sha1:b03f6a4 )

1 year, 11 months

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 January 2023