January 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16024) Change rendering of value parameters in JPA Criteria HQL representation

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=eyJpIjoiMmU0MDlmYzI1... ) / Task ( https://hibernate.atlassian.net/browse/HHH-16024?atlOrigin=eyJpIjoiMmU0MD... ) HHH-16024 ( https://hibernate.atlassian.net/browse/HHH-16024?atlOrigin=eyJpIjoiMmU0MD... ) Change rendering of value parameters in JPA Criteria HQL representation ( https://hibernate.atlassian.net/browse/HHH-16024?atlOrigin=eyJpIjoiMmU0MD... ) Issue Type: Task Assignee: Unassigned Components: hibernate-core Created: 11/Jan/2023 07:20 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Coming from the discussion https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topi... ( https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topi... ) , the task is to introduce some sort of context for the org.hibernate.query.sqm.tree.SqmVisitableNode#appendHqlString method, such that a mapping of parameters to generated parameter names can be built, so that we can render the HQL representation in a way that contains a named parameter for JPA Criteria values. ( https://hibernate.atlassian.net/browse/HHH-16024#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16024#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#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15902) @OneToMany relationship with @Where on child table generates wrong sql

by Andrea Boriero (JIRA)

1 year, 11 months

1
0
0 / 0

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

by Marco Belladelli (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4757) Adjust tests to address ORM changes introduced in HHH-15767

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4768) Fix JavaModulePathTest with ORM 6.2

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4775) Improve source code compatibility of Hibernate Search with Hibernate ORM 6.2

by Yoann Rodière (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15885) Hibernate 6 OrderBy in the wrong orders

by Jan Schatteman (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16020) Hibernate doesn't set the correct bind parameter for the offset when using NativeQuery.setFirstResult() on Postgresql

by Jan Schatteman (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16023) ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1

by Fred (JIRA)

Fred ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63be69f... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjUwMDNiNjky... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16023?atlOrigin=eyJpIjoiYjUwMD... ) HHH-16023 ( https://hibernate.atlassian.net/browse/HHH-16023?atlOrigin=eyJpIjoiYjUwMD... ) ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1 ( https://hibernate.atlassian.net/browse/HHH-16023?atlOrigin=eyJpIjoiYjUwMD... ) Issue Type: Bug Affects Versions: 6.1.6 Assignee: Unassigned Components: hibernate-core Created: 11/Jan/2023 05:25 AM Priority: Major Reporter: Fred ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63be69f... ) I’m migrating an application from Hibernate 5.6.14 to 6.1.6 and I encounter issues with the migration of some queries. The original query involving many entities, it has been simplified to the following one for testing purpose : @NamedNativeQueries(value = { @NamedNativeQuery( name = "MyEntity.findMyEntity", query = """ WITH RECURSIVE all_my_entities AS ( SELECT me.* FROM my_entity me ) SELECT {ame.*} FROM all_my_entities ame """)} ) @Entity@Inheritance(strategy = InheritanceType.SINGLE_TABLE) @DiscriminatorColumn(discriminatorType = DiscriminatorType.STRING, name = "catalog_item_type") public class MyEntity<E extends MyEntity> { @Id @GeneratedValue(generator = MY_SEQUENCE) private Long id; private String name; } Here is the simplified version of the repository : @Repository public class MyEntityRepository { private final EntityManager entityManager; public MyEntityRepository(EntityManager entityManager) { this.entityManager = entityManager; } public Set<MyEntity> findMyEntities() { Session session = entityManager.unwrap(Session.class); List<MyEntity> myEntities = session.getNamedNativeQuery("MyEntity.findMyEntity") .addEntity("ame", MyEntity.class) .getResultList(); return new HashSet<>(myEntities); } } I use the following test to reproduce the issue : @SpringBootTest public class TestApplicationTests { @Autowired private MyEntityRepository myEntityRepository; @Test public void shouldBuildNamedQuery() { assertThat(myEntityRepository.findMyEntities()).isEmpty(); } } The above test succeeds with version Hibernate 5.6.14 (Springboot 2.7.7) and fails with Hibernate 6.1.6 (Springboot 3.0.1). The test fails with the exception : java.lang.ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1 at org.hibernate.persister.entity.AbstractEntityPersister.isSelectable(AbstractEntityPersister.java:2039) at org.hibernate.persister.entity.AbstractEntityPersister.fetchProcessor(AbstractEntityPersister.java:2012) at org.hibernate.loader.ast.internal.LoaderSqlAstCreationState.visitFetches(LoaderSqlAstCreationState.java:118) at org.hibernate.sql.results.graph.AbstractFetchParent.afterInitialize(AbstractFetchParent.java:32) at org.hibernate.sql.results.graph.entity.AbstractEntityResultGraphNode.afterInitialize(AbstractEntityResultGraphNode.java:100) at org.hibernate.persister.entity.AbstractEntityPersister.createDomainResult(AbstractEntityPersister.java:1300) at org.hibernate.persister.entity.AbstractEntityPersister.selectFragment(AbstractEntityPersister.java:1892) at org.hibernate.query.sql.internal.SQLQueryParser.resolveProperties(SQLQueryParser.java:236) at org.hibernate.query.sql.internal.SQLQueryParser.substituteBrackets(SQLQueryParser.java:159) at org.hibernate.query.sql.internal.SQLQueryParser.process(SQLQueryParser.java:63) at org.hibernate.query.sql.internal.NativeSelectQueryPlanImpl.<init>(NativeSelectQueryPlanImpl.java:54) at org.hibernate.engine.query.internal.NativeQueryInterpreterStandardImpl.createQueryPlan(NativeQueryInterpreterStandardImpl.java:39) at org.hibernate.query.sql.internal.NativeQueryImpl.createQueryPlan(NativeQueryImpl.java:649) at org.hibernate.query.sql.internal.NativeQueryImpl.lambda$resolveSelectQueryPlan$7(NativeQueryImpl.java:610) at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveSelectQueryPlan(QueryInterpretationCacheStandardImpl.java:83) at org.hibernate.query.sql.internal.NativeQueryImpl.resolveSelectQueryPlan(NativeQueryImpl.java:608) at org.hibernate.query.sql.internal.NativeQueryImpl.doList(NativeQueryImpl.java:602) at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:363) at org.hibernate.query.Query.getResultList(Query.java:94) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:401) at jdk.proxy2/jdk.proxy2.$Proxy133.getResultList(Unknown Source) at com.example.repository.CatalogItemRepository.findMyEntities(CatalogItemRepository.java:24) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:752) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703) at com.example.repository.CatalogItemRepository$$SpringCGLIB$$0.findMyEntities(<generated>) at com.example.TestApplicationTests.shouldBuildNamedQuery(TestApplicationTests.java:22) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) ( https://hibernate.atlassian.net/browse/HHH-16023#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16023#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#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15948) move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15948 ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZGEyN2... ) Re: move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZGEyN2... ) I’d say moving the stuff from org.hibernate.metamodel.model.convert (with package structure) under org.hibernate.type.descriptor.converter and move AttributeConverterMutabilityPlanImpl into the newly moved org.hibernate.type.descriptor.converter.internal ( https://hibernate.atlassian.net/browse/HHH-15948#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15948#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#100213- sha1:b01baad )

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