January 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16002) JPQL queries failing through composite key

by Adrian Cox (JIRA)

Adrian Cox ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60e7210... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmEwZGMxZjkx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16002?atlOrigin=eyJpIjoiNmEwZG... ) HHH-16002 ( https://hibernate.atlassian.net/browse/HHH-16002?atlOrigin=eyJpIjoiNmEwZG... ) JPQL queries failing through composite key ( https://hibernate.atlassian.net/browse/HHH-16002?atlOrigin=eyJpIjoiNmEwZG... ) Issue Type: Bug Affects Versions: 5.4.0, 5.6.14 Assignee: Unassigned Created: 08/Jan/2023 08:49 AM Environment: Hibernate 5.6.14, Java 11, Windows 10 Priority: Major Reporter: Adrian Cox ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60e7210... ) Hibernate 5.6 generates incorrect SQL for JPQL queries involving an `@IdClass` mapping. The test case is here: https://github.com/AdrianAtHumboldt/hibernate-test-case-idclass ( https://github.com/AdrianAtHumboldt/hibernate-test-case-idclass ) The tests pass with Hibernate 5.3.27, but fail for 5.4.0 through to 5.6.14. There are two likely related failures - in the first failure the expected parameter type has changed for a query. In the query `select x from EntityX x where x.link.attribute = ?1 and x.link.s = ?2` Parameter type 2 is now expected to be long, which is the primary key of S. In the second failure the wrong SQL is generated for the query `select x from EntityX x where x.link.attribute = ?1 and x.link.s.id = ?2`. The final line is a test on x.id instead of on x.link.s.id. select entityx0_.id as id1_2_, entityx0_.link_entitys_id as link_ent2_2_, entityx0_.link_entityv_id as link_ent3_2_ from EntityX entityx0_ cross join Link link1_ where entityx0_.link_entitys_id=link1_.entitys_id and entityx0_.link_entityv_id=link1_.entityv_id and link1_. attribute =? and entityx0_.id=? ( https://hibernate.atlassian.net/browse/HHH-16002#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16002#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-10557) @Loader doesn't work for bags

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-10557 ( https://hibernate.atlassian.net/browse/HHH-10557?atlOrigin=eyJpIjoiNDYzN2... ) Re: @Loader doesn't work for bags ( https://hibernate.atlassian.net/browse/HHH-10557?atlOrigin=eyJpIjoiNDYzN2... ) This is fixed. ( https://hibernate.atlassian.net/browse/HHH-10557#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-10557#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16000) Add @SQLSelect annotation as abbreviation for @NamedNativeQuery + @Loader

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16000 ( https://hibernate.atlassian.net/browse/HHH-16000?atlOrigin=eyJpIjoiZWIyOD... ) Re: Add @SQLSelect annotation as abbreviation for @NamedNativeQuery + @Loader ( https://hibernate.atlassian.net/browse/HHH-16000?atlOrigin=eyJpIjoiZWIyOD... ) For completeness/consistency I have also added @HQLQuery and deprecated @Loader. And I added some proper tests for the functionality(there were none in the main test suite). Unless anyone has objections to this change, I think this issue can be closed. ( https://hibernate.atlassian.net/browse/HHH-16000#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16000#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16000) Add @SQLSelect annotation as abbreviation for @NamedNativeQuery + @Loader

by Gavin King (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16001) CacheKeyImplementation is not serializable for some types

by Thomas Heigl (JIRA)

Thomas Heigl ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzI1ODQ3Y2I5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzI1OD... ) HHH-16001 ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzI1OD... ) CacheKeyImplementation is not serializable for some types ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzI1OD... ) Change By: Thomas Heigl ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) This was originally reported to as a [bug|https://github.com/EsotericSoftware/kryo/issues/934] to my project, but I think that this is something that has to be resolved in Hibernate itself. {{CacheKeyImplementation}} implements Serializable, but cache keys for some types have fields that are not serializable. See the following stacktrace: {noformat}Caused by: org.hibernate.cache.CacheException: com.esotericsoftware.kryo.KryoException: java.lang.reflect.InaccessibleObjectException: Unable to make field private transient volatile boolean java.lang.reflect.Executable.hasRealParameterData accessible: module java.base does not "opens java.lang.reflect" to unnamed module @2c13da15 Serialization trace: getterMethod (org.hibernate.property.access.spi.GetterFieldImpl) getters (org.hibernate.tuple.component.PojoComponentTuplizer) componentTuplizer (org.hibernate.type.EmbeddedComponentType) type (org.hibernate.cache.internal.CacheKeyImplementation) at org.redisson.hibernate.RedissonStorage.evictData(RedissonStorage.java:183) at org.hibernate.cache.spi.support.StorageAccess.removeFromCache(StorageAccess.java:35) at org.hibernate.cache.spi.support.AbstractCachedDomainDataAccess.remove(AbstractCachedDomainDataAccess.java:91) at org.hibernate.action.internal.CollectionAction.evict(CollectionAction.java:140) at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:52) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ... 4 more{noformat} Cache keys for {{org.hibernate.type.EmbeddedComponentType}} contain a reference to {{java.lang.reflect.Field}} via {{org.hibernate.tuple.component.PojoComponentTuplizer}}. Classes in {{java.lang.reflect}} are not serializable. This issue has been resolved in Hibernate 6 where cache keys no longer reference the type itself, but the disassembled state of the type. Does it make sense to backport the changes from to cache keys from Hibernate 6 to 5? ( https://hibernate.atlassian.net/browse/HHH-16001#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16001#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16001) CacheKeyImplementation is not serializable for some types

by Thomas Heigl (JIRA)

Thomas Heigl ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzliMGViYjFm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzliMG... ) HHH-16001 ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzliMG... ) CacheKeyImplementation is not serializable for some types ( https://hibernate.atlassian.net/browse/HHH-16001?atlOrigin=eyJpIjoiYzliMG... ) Issue Type: Bug Affects Versions: 5.6.14 Assignee: Unassigned Components: hibernate-core Created: 07/Jan/2023 02:38 AM Priority: Major Reporter: Thomas Heigl ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) This was originally reported to as a bug ( https://github.com/EsotericSoftware/kryo/issues/934 ) to my project, but I think that this is something that has to be resolved in Hibernate itself. CacheKeyImplementation implements Serializable, but cache keys for some types have fields that are not serializable. See the following stacktrace: Caused by: org.hibernate.cache.CacheException: com.esotericsoftware.kryo.KryoException: java.lang.reflect.InaccessibleObjectException: Unable to make field private transient volatile boolean java.lang.reflect.Executable.hasRealParameterData accessible: module java.base does not "opens java.lang.reflect" to unnamed module @2c13da15 Serialization trace: getterMethod (org.hibernate.property.access.spi.GetterFieldImpl) getters (org.hibernate.tuple.component.PojoComponentTuplizer) componentTuplizer (org.hibernate.type.EmbeddedComponentType) type (org.hibernate.cache.internal.CacheKeyImplementation) at org.redisson.hibernate.RedissonStorage.evictData(RedissonStorage.java:183) at org.hibernate.cache.spi.support.StorageAccess.removeFromCache(StorageAccess.java:35) at org.hibernate.cache.spi.support.AbstractCachedDomainDataAccess.remove(AbstractCachedDomainDataAccess.java:91) at org.hibernate.action.internal.CollectionAction.evict(CollectionAction.java:140) at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:52) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ... 4 more Cache keys for org.hibernate.type.EmbeddedComponentType contain a reference to java.lang.reflect.Field via org.hibernate.tuple.component.PojoComponentTuplizer. Classes in java.lang.reflect are not serializable. This issue has been resolved in Hibernate 6 where cache keys no longer reference the type itself, but the disassembled state of the type. Does it make sense to backport the changes from to cache keys from Hibernate 6 to 5? ( https://hibernate.atlassian.net/browse/HHH-16001#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16001#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16000) Add @SQLSelect annotation as abbreviation for @NamedNativeQuery + @Loader

by Gavin King (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-10557) @Loader doesn't work for bags

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-10557 ( https://hibernate.atlassian.net/browse/HHH-10557?atlOrigin=eyJpIjoiNmUxNT... ) Re: @Loader doesn't work for bags ( https://hibernate.atlassian.net/browse/HHH-10557?atlOrigin=eyJpIjoiNmUxNT... ) So the actual nature of the issue here is that there is not and has never been any equivalent to the <load-collection/> result set mapping element available in annotations. In principle, the @Loader annotation should refer to a named query with a @CollectionResult , but the @CollectionResult annotation simply doesn’t exist, and be added without duplicating the whole @SqlResultSetMapping annotation. Nevertheless, I think I’ve found a workaround that lets you use a named query with a @ColumnResult or @EntityResult to load the collection. ( https://hibernate.atlassian.net/browse/HHH-10557#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-10557#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:f908df2 )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-10557) @Loader doesn't work for bags

by Gavin King (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15999) Hibernate 6.1.6.Final TableGenerator produces negative ID's

by Egor Lesko (JIRA)

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