April 2023 - hibernate-issues - Jboss List Archives

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16424 ( https://hibernate.atlassian.net/browse/HHH-16424?atlOrigin=eyJpIjoiOGExND... ) Re: dot id subquery ( https://hibernate.atlassian.net/browse/HHH-16424?atlOrigin=eyJpIjoiOGExND... ) The types of paths in comparison expressions are now checked for compatibility as per https://hibernate.atlassian.net/browse/HHH-15802 , so your queries are failing on purpose. What Hibernate 5 did in the past was not safe. See some discussions about this here https://github.com/hibernate/hibernate-orm/pull/5800 and the migration guide entry: https://github.com/hibernate/hibernate-orm/blob/6.2/migration-guide.adoc#... ( https://hibernate.atlassian.net/browse/HHH-16424#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16424#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16424) dot id subquery

by Thorsten Goetzke (JIRA)

Thorsten Goetzke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6422e66... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTk1ZTg3ZjA5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16424?atlOrigin=eyJpIjoiOTk1ZT... ) HHH-16424 ( https://hibernate.atlassian.net/browse/HHH-16424?atlOrigin=eyJpIjoiOTk1ZT... ) dot id subquery ( https://hibernate.atlassian.net/browse/HHH-16424?atlOrigin=eyJpIjoiOTk1ZT... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Attachments: FunTest.java Components: query-hql Created: 03/Apr/2023 05:42 AM Priority: Major Reporter: Thorsten Goetzke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6422e66... ) Hello I was trying to create a reproducer for https://hibernate.atlassian.net/browse/HHH-15661 and it seems to be connected to the way that sometimes hibernates allows you to use “.id” instead of the real Entity. I remember that using a syntax like “where x.id ( http://x.id ) in” instead of “where x in ( http://x.in ) ” at some point in hibernate long ago helped you to work around some hibernate bugs, now it seems to trigger some hard to debug ones. Expected: query 0,1,2 should work or break the same. Preferably work because at some point they did.. Actual query 0 and 1 pass the interpreter but fail at execution. Adding an extra “()” will break the query at the intepreter, with a least an understandable message. ( https://hibernate.atlassian.net/browse/HHH-16424#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16424#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16250) Mapping same column twice and one of them using a custom type leads to "Unknown wrap conversion requested"

by Andrea Boriero (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16423) LazyInitializationException when calling em.refresh() on entity with lazy and eager children

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *commented* on HHH-16423 ( https://hibernate.atlassian.net/browse/HHH-16423?atlOrigin=eyJpIjoiZjVhNj... ) Re: LazyInitializationException when calling em.refresh() on entity with lazy and eager children ( https://hibernate.atlassian.net/browse/HHH-16423?atlOrigin=eyJpIjoiZjVhNj... ) In the Keycloak project, we’ll changed the code that we don’t need the refresh any more, and that this issue is not blocking us. Still, it might haunt us in other places, therefore we’d like to see a fix eventually. Thanks! ( https://hibernate.atlassian.net/browse/HHH-16423#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16423#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16423) LazyInitializationException when calling em.refresh() on entity with lazy and eager children

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWJjNTdjOWJl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16423?atlOrigin=eyJpIjoiNWJjNT... ) HHH-16423 ( https://hibernate.atlassian.net/browse/HHH-16423?atlOrigin=eyJpIjoiNWJjNT... ) LazyInitializationException when calling em.refresh() on entity with lazy and eager children ( https://hibernate.atlassian.net/browse/HHH-16423?atlOrigin=eyJpIjoiNWJjNT... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 03/Apr/2023 05:13 AM Environment: Linux / H2 (probably independent of from the database) Priority: Major Reporter: Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) The problem can be reproduced as follows: * given: entity with two collections, one lazy, the other eager * fetch an entity * refresh the entity * access the lazy collection → LazyInitializationException as the collection doesn’t contain a session (see below) Reproducer: https://github.com/ahus1/hibernate-test-case-templates/tree/kc-16069-lazy... Chat with the hibernate team: https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topi... Issue from the Keycloak team: https://github.com/keycloak/keycloak/issues/19069#issuecomment-1494185743 org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hibernate.bugs.RealmEntity.components: could not initialize proxy - no Session at org.hibernate.collection.spi.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:635) at org.hibernate.collection.spi.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:218) at org.hibernate.collection.spi.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:148) at org.hibernate.collection.spi.PersistentSet.size(PersistentSet.java:151) at org.hibernate.bugs.ORMUnitTestCase.hhh123Test(ORMUnitTestCase.java:98) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:264) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java) at java.base/java.lang.Thread.run(Thread.java:829) ( https://hibernate.atlassian.net/browse/HHH-16423#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16423#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16422) Backward compatibility issue in 6.2: enum ordinal now mapped to tinyint instead of int

by Bert Roos (JIRA)

Bert Roos ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmY1ZGUzYTZi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16422?atlOrigin=eyJpIjoiZmY1ZG... ) HHH-16422 ( https://hibernate.atlassian.net/browse/HHH-16422?atlOrigin=eyJpIjoiZmY1ZG... ) Backward compatibility issue in 6.2: enum ordinal now mapped to tinyint instead of int ( https://hibernate.atlassian.net/browse/HHH-16422?atlOrigin=eyJpIjoiZmY1ZG... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Created: 03/Apr/2023 04:37 AM Environment: Spring Boot 3.0.5 with Hibernate 6.2.0 and MariaDB Priority: Major Reporter: Bert Roos ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Upon upgrading from 6.1.7 to 6.2.0, I get this error message during schema validation: Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [receiving_status] in table [buddies_anonymized] ; found int (Types#INTEGER) ( #INTEGER) ) , but expecting tinyint (Types#TINYINT) ( #TINYINT) ) The full class BuddyAnonymized can be found here ( https://github.com/yonadev/yona-server/blob/master/core/src/main/java/nu/... ). The attribute receivingStatus is declared as follows (no annotations applied): private Status receivingStatus = Status.NOT_REQUESTED; The type Status is an enum, defined as follows: public enum Status { NOT_REQUESTED, REQUESTED, ACCEPTED, REJECTED } ( https://hibernate.atlassian.net/browse/HHH-16422#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16422#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Davide D'Alto (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2ExNzRkOTAw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiY2ExNz... ) HHH-16365 ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiY2ExNz... ) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiY2ExNz... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Entity example: {code:java} @Entity(name = "Flour") @Table(name = "Flour") public static class Flour { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; ... }{code} and setting {noformat}hibernate.jdbc.use_get_generated_keys = false{noformat} will produce the following invalid query with Sql Server: {code:sql}insert into Flour (description,name,type) values (?,?,?) returning id{code} instead of ( ORM 5.6.14) {code:sql}insert into Flour (description, name, type) values (?, ?, ?) select scope_identity(){code} or I think the correct query should be: {code:sql}insert into Flour (description, name, type) output inserted.id values (?, ?, ?){code} Note that using the output syntax will also fix the issue for Hibernate Reactive ( https://hibernate.atlassian.net/browse/HHH-16365#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16365#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16421) CriteriaBuilder.function() doesn't support PostgresQL native any function

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16421 ( https://hibernate.atlassian.net/browse/HHH-16421?atlOrigin=eyJpIjoiYjZlMm... ) Re: CriteriaBuilder.function() doesn't support PostgresQL native any function ( https://hibernate.atlassian.net/browse/HHH-16421?atlOrigin=eyJpIjoiYjZlMm... ) I believe you’ve misunderstood the purpose of the HQL any() function. It’s not the same as the any quantifier. The argument of the any() aggregate function is supposed to be a boolean value. ( https://hibernate.atlassian.net/browse/HHH-16421#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16421#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#100221- sha1:d541bce )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16421) CriteriaBuilder.function() doesn't support PostgresQL native any function

by 周雁鸣 (JIRA)

1 year, 2 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 April 2023