May 2023 - hibernate-issues - Jboss List Archives

Joshua Bonn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ce2c27... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTFjMmVlYThl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16602?atlOrigin=eyJpIjoiMTFjMm... ) HHH-16602 ( https://hibernate.atlassian.net/browse/HHH-16602?atlOrigin=eyJpIjoiMTFjMm... ) EntityUpdateAction for deleted Entity ( https://hibernate.atlassian.net/browse/HHH-16602?atlOrigin=eyJpIjoiMTFjMm... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Attachments: hibernate-orm-6.zip Components: hibernate-core Created: 15/May/2023 03:48 AM Environment: Eclipse Adoptium 17.0.2+8 Priority: Major Reporter: Joshua Bonn ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ce2c27... ) Reproducible with attached test case. We have two entities in our domain model which are related similar to the TreeNode and ReferencedEntity classes. @Entity public static class TreeNode { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @ManyToOne(optional = true) @JoinColumn(name = "parent_id") private TreeNode parent; @OneToMany private Set<ReferencedEntity> someSet = new HashSet<>(); } @Entity public static class ReferencedEntity { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; } TreeNodes have a reference to their parents and a set of references to some ReferencedEntities. In our production code we have several custom validations that access the someSet property of TreeNode. After upgrading to Hibernate 6.2.2.Final (from Version 5.6.14.Final) these validations failed when deleting TreeNode entities (through the deleteAll method of a CrudRepository). The stack trace was similar to the one generated by the attached test case: java.lang.NullPointerException: Cannot invoke "org.hibernate.persister.collection.CollectionPersister.hasCache()" because "persister" is null at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.initializeCollectionFromCache(DefaultInitializeCollectionEventListener.java:131) at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:59) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1697) at org.hibernate.collection.spi.AbstractPersistentCollection.lambda$initialize$3(AbstractPersistentCollection.java:617) at org.hibernate.collection.spi.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:265) at org.hibernate.collection.spi.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:615) at org.hibernate.collection.spi.AbstractPersistentCollection.read(AbstractPersistentCollection.java:136) ... By debugging the (hibnerate) code we found that a UpdateEntityAction was generated on flush because the parent property was different. As far as we could see, this happened because parent was set to null in the DefaultDeleteEventListener using ForeignKeys.Nullifier. The test case simulates the validation using a PreUpdateEventListener that accesses the someSet property. ( https://hibernate.atlassian.net/browse/HHH-16602#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16602#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16433) “Locking with ORDER BY is not supported” error in a “select for update” query (Oracle DB)

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16433) “Locking with ORDER BY is not supported” error in a “select for update” query (Oracle DB)

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16433) “Locking with ORDER BY is not supported” error in a “select for update” query (Oracle DB)

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-12981) Join alias is miscalculated when two descendant entities have same attribute name

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15726) Disjunction with treat results in too restrictive query

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) Problem in query involving union on MySQL 5.7, MariaDB and Oracle

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) Problem in query involving union on MySQL 5.7, MariaDB and Oracle

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16576 ( https://hibernate.atlassian.net/browse/HHH-16576?atlOrigin=eyJpIjoiOGFhNW... ) Re: Problem in query involving union on MySQL 5.7, MariaDB and Oracle ( https://hibernate.atlassian.net/browse/HHH-16576?atlOrigin=eyJpIjoiOGFhNW... ) Looks like this dialects use AbstractSqlAstTranslator#emulateQueryPartTableReferenceColumnAliasing but that’s not working properly, proposed a changed that should fix it. ( https://hibernate.atlassian.net/browse/HHH-16576#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16576#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) Problem in query involving union on MySQL 5.7, MariaDB and Oracle

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) problem in query involving union on MySql 5.7, MariaDB and Oracle

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16601) no confirmation that second-level cache is enabled at startup

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYWE1N2VmM2Ux... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16601?atlOrigin=eyJpIjoiYWE1N2... ) HHH-16601 ( https://hibernate.atlassian.net/browse/HHH-16601?atlOrigin=eyJpIjoiYWE1N2... ) no confirmation that second-level cache is enabled at startup ( https://hibernate.atlassian.net/browse/HHH-16601?atlOrigin=eyJpIjoiYWE1N2... ) Issue Type: Improvement Assignee: Unassigned Components: hibernate-core Created: 15/May/2023 02:40 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There is now essentially no logging of events that happen with respect to initializing the second-level cache at startup. There are messages related to the second-level cache defined on CoreMessageLogger but they are no longer called. This makes it very difficult to confirm that the whole subsystem is actually being initialized. Now, I’m not a fan of lots of verbose logging at startup, but this one seems pretty important. I also have a sort-of similar complaint about connection pools. There’s no confirmation that Agroal is actually being used. ( https://hibernate.atlassian.net/browse/HHH-16601#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16601#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16581) in 6.2 I start getting Multiple '@FilterDef' annotations define a filter named error on startup

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16491) SQM could not correct resolve Generics Embeddable ids

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16491) SQM could not correct resolve Generics Embeddable ids

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-11686) Improve TREAT handling

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-11686 ( https://hibernate.atlassian.net/browse/HHH-11686?atlOrigin=eyJpIjoiZDU3M2... ) Re: Improve TREAT handling ( https://hibernate.atlassian.net/browse/HHH-11686?atlOrigin=eyJpIjoiZDU3M2... ) Tests which were added with this issue key have been fixed through HHH-15726 ( https://hibernate.atlassian.net/browse/HHH-15726 ) In Progress ( https://hibernate.atlassian.net/browse/HHH-11686#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-11686#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16600) @Basic(optional=false) on embeddable held by subclass in single table inheritance

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjY4YTRmZmMw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16600?atlOrigin=eyJpIjoiZjY4YT... ) HHH-16600 ( https://hibernate.atlassian.net/browse/HHH-16600?atlOrigin=eyJpIjoiZjY4YT... ) @Basic(optional=false) on embeddable held by subclass in single table inheritance ( https://hibernate.atlassian.net/browse/HHH-16600?atlOrigin=eyJpIjoiZjY4YT... ) Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 15/May/2023 00:59 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) If I have a subclass entity in a single table inheritance hierarchy, and it has an embeddable with an attribute annotated @Basic(optional=false) , then optional=false should not lead to a not null constraint. It should still result in a constraint in all other inheritance mappings. ( https://hibernate.atlassian.net/browse/HHH-16600#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16600#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16593) mappedBy non-association

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNTI3NG... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNTI3NG... ) I didn’t look into this yet, and this also has no priority for me right now. For those Kotlin users who care a lot about this, please step up and do the analysis of what changed between 5 and 6. ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16560) Nested @Embedded within an @EmbeddedId fails assertion in 6.2.2

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) problem in query involving union on MariaDB and Oracle

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) problem in query involving union on MariaDB and Oracle

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Thomas Bosch (JIRA)

Thomas Bosch ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c19f84... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODYzOT... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODYzOT... ) @Gavin King Like @Guillaume said please check my Github repo. JPAUnitTestCase#hhh15929Test This example has NO dependencies to Spring. It’s plain Hibernate. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:a5851ae )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Rafael Winterhalter (JIRA)

Rafael Winterhalter ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16572 ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiNWJhZm... ) Re: Incorrect enhancement for PROPERTY attributes with mismatched field and method names ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiNWJhZm... ) If you want to discuss it through, feel free to invite me for a video session, im sure it's solvable. ( https://hibernate.atlassian.net/browse/HHH-16572#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16572#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16599) No way to make attributes of record annotated @Struct not-null

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16599) No way to make attributes of record annotated @Struct not-null

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjE5ZmNhYmE3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiNjE5Zm... ) HHH-16599 ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiNjE5Zm... ) No way to make attributes of record annotated @Struct not-null ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiNjE5Zm... ) Issue Type: Bug Assignee: Unassigned Created: 14/May/2023 14:12 PM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For this mapping: @Embeddable @Struct(name= "PersonName" ) record Name(@Basic(optional = false ) String firstName, String middleName, @Basic(optional = false ) String lastName){} The generated DDL is missing not-null constraints: create type PersonName as (firstName varchar (255), middleName varchar (255), lastName varchar (255)) ( https://hibernate.atlassian.net/browse/HHH-16599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16599#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Guillaume (JIRA)

Guillaume ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiMzI1Yj... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiMzI1Yj... ) Please check Thomas Bosch’s answer and his repo : https://github.com/dickerpulli/hibernate-test-case-templates (hibernate-orm-6 test cases). I reproduce the bug with his repo and I made it works with Hibernate 5. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODJlYj... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODJlYj... ) *Current status: waiting for a reproducer in plain Hibernate with no dependency to Spring.* ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiYWExNT... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiYWExNT... ) FTR, here is my test code: In import.sql : INSERT INTO table_test(id, type, property) VALUES('1','A','{"propertyA": "valueA"}'::jsonb) INSERT INTO table_test(id, type, property) VALUES('2','B','{"propertyB": "valueB"}'::jsonb) In Main.java : public class Main { public static void main( String [] args) { var sessionFactory = new Configuration() .addAnnotatedClass(CommonEntity.class) .addAnnotatedClass(EntityA.class) .addAnnotatedClass(EntityB.class) // use Postgres .setProperty(URL, "jdbc:postgresql: //localhost/hreact" ) .setProperty(USER, "hreact" ) .setProperty(PASS, "hreact" ) // display SQL in console .setProperty(SHOW_SQL, TRUE.toString()) .setProperty(FORMAT_SQL, TRUE.toString()) .setProperty(HIGHLIGHT_SQL, TRUE.toString()) .buildSessionFactory(); // export the inferred database schema sessionFactory.getSchemaManager().dropMappedObjects( false ); sessionFactory.getSchemaManager().exportMappedObjects( true ); sessionFactory.inSession(session -> { var ea = session.find(EntityA. class, 1); var eb = session.find(EntityB. class, 2); }); } } Executed SQL: [Hibernate] drop table if exists table_test cascade [Hibernate] create table table_test ( type varchar (31) not null , id bigint not null , property jsonb, primary key (id) ) [INFO] HHH000476: Executing script ' file :/Users/gavin/Downloads/test/untitled/build/resources/main/import. sql ' [Hibernate] INSERT INTO table_test(id, type , property) VALUES ( '1' , ' A ' , '{ "propertyA" : "valueA" }' ::jsonb) [Hibernate] INSERT INTO table_test(id, type , property) VALUES ( '2' , 'B' , '{ "propertyB" : "valueB" }' ::jsonb) [Hibernate] select e1_0.id, e1_0.property from table_test e1_0 where e1_0. type = ' A ' and e1_0.id=? [Hibernate] select e1_0.id, e1_0.property from table_test e1_0 where e1_0. type = 'B' and e1_0.id=? ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiNmQ0ZD... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiNmQ0ZD... ) I just tested this code again Hibernate 6.3 {{main}}branch and it worked perfectly. Note that I’m using Hibernate on its own with no Spring Repository nonsense. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16572 ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMjlhMz... ) Re: Incorrect enhancement for PROPERTY attributes with mismatched field and method names ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMjlhMz... ) That’s the purpose of org.hibernate.bytecode.enhance.internal.bytebuddy.FieldAccessEnhancer#FieldAccessEnhancer as far as I can tell (as a `AsmVisitorWrapper.ForDeclaredMethods.MethodVisitorWrapper`) . I’ll look through that code as a starting point ( https://hibernate.atlassian.net/browse/HHH-16572#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16572#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16560) Nested @Embedded within an @EmbeddedId fails assertion in 6.2.2

by Steve Storey (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16523) hibernate.cache.use_minimal_puts appears to be missing from H6

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16523 ( https://hibernate.atlassian.net/browse/HHH-16523?atlOrigin=eyJpIjoiNTFjOW... ) Re: hibernate.cache.use_minimal_puts appears to be missing from H6 ( https://hibernate.atlassian.net/browse/HHH-16523?atlOrigin=eyJpIjoiNTFjOW... ) So, if we are not going to implement use_minimal_puts in H6 (which I’m still not convinced is the right decision) then this setting needs to be removed and the documentation updated. But also, it’s even more impactful than that because the only difference between CacheMode.PUT and CacheMode.REFRESH or between CacheStoreMode.USE and CacheStoreMode. REFRESH is that REFRESH bypasses the effect of use_minimal_puts. So, I dunno, I guess we should also deprecate CacheMode.REFRESH ? ( https://hibernate.atlassian.net/browse/HHH-16523#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16523#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Jonathan (JIRA)

Jonathan ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad46b6... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiM2ZiMT... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiM2ZiMT... ) Hey guys, I tried also with: * Kotlin + SpringBoot 3.0.6 * Hibernate-6.2.2-Final and still having issues. Here ( repository ( https://github.com/JonathanSarco/jpa-demo ) ) is an example of what the issue is (at least for me). It might be helpful! ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16598) add Introduction to Hibernate 6 to the website

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16576) problem in query involving union on MariaDB and Oracle

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16576 ( https://hibernate.atlassian.net/browse/HHH-16576?atlOrigin=eyJpIjoiNjA5Mj... ) Re: problem in query involving union on MariaDB and Oracle ( https://hibernate.atlassian.net/browse/HHH-16576?atlOrigin=eyJpIjoiNjA5Mj... ) There are several PR’s that passed all checks, only to fail on “continuous-integration/jenkins/pr-merge” because of failed tests in FunctionTests ( https://hibernate.atlassian.net/browse/HHH-16576#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16576#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16591) @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16591 ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYmM4Nj... ) Re: @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYmM4Nj... ) … or, maybe, not. I’ve changed test case as described earlier, fixed existing test case that has been failing due to assumption that default JDBC type code for Duration is INTERVAL_SECOND and documentation. Finally changed code to work on similar way as now is working for Instance. Suggested patch is now in PR 6562 ( https://github.com/hibernate/hibernate-orm/pull/6562 ) ( https://hibernate.atlassian.net/browse/HHH-16591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16591#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16572 ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMWIyYz... ) Re: Incorrect enhancement for PROPERTY attributes with mismatched field and method names ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMWIyYz... ) Hm, I’ll have to look into how this all does extended enhancement then. Extended enhancement is all about this. Anyway, without this I just don’t see (yet) how we can support this. Anyone have ideas? ( https://hibernate.atlassian.net/browse/HHH-16572#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16572#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16591) @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16591 ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiOTZjMT... ) Re: @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiOTZjMT... ) … and I guess that I am, most likely, completely wrong ( https://hibernate.atlassian.net/browse/HHH-16591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16591#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16560) Nested @Embedded within an @EmbeddedId fails assertion in 6.2.2

by Steve Storey (JIRA)

Steve Storey ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16560 ( https://hibernate.atlassian.net/browse/HHH-16560?atlOrigin=eyJpIjoiN2E1MG... ) Re: Nested @Embedded within an @EmbeddedId fails assertion in 6.2.2 ( https://hibernate.atlassian.net/browse/HHH-16560?atlOrigin=eyJpIjoiN2E1MG... ) Bisecting shows that the failure was introduced with https://github.com/hibernate/hibernate-orm/commit/995aa53fc0bae734324c16b... ( https://hibernate.atlassian.net/browse/HHH-16560#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16560#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16591) @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16591 ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYzNmND... ) Re: @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYzNmND... ) Please, correct me if I am worng … In present implementation you first and last assertions are contradictory. If registered JdbcType for SqlTypes.INTERVAL_SECOND is NumericJdbcType (first assertion), then sam JdbcType will be used for property annotated with @JdbcType(SqlTypes.INTERVAL_SECOND) (as is checked with last assertion). My understanding (again, please, correct me if I am wrong) is that JdbcType for INTERVAL_SECOND should not be replaced when preferred duration JDBC type is set to NUMERIC. What should be changed is JavaType used, by default, for java.time.Duration properties. It seems to me that it your test case line > > > > final JdbcType intervalType = jdbcTypeRegistry.getDescriptor( > SqlTypes.INTERVAL_SECOND ); > > should be replaced with: > > > > final JdbcType intervalType = > mappingMetamodel.getTypeConfiguration().getBasicTypeForJavaType( > Duration.class ).getJdbcType(); > > My understanding is that, whatever is preferred JDBC type for Duration is, JDBC type 3100 (= SqlTypes.INTERVAL_SECOND) should be handled by same JdbcType implementation. In this case this is PostgreSQLIntervalSecondJdbcType. To check that I wil add line: > > > > assertThat( jdbcTypeRegistry.getDescriptor( SqlTypes.INTERVAL_SECOND ) ) > > > > .isOfAnyClassIn( PostgreSQLIntervalSecondJdbcType.class ); > > This assertion is equivalent to last one and it will fail in current implementation. My guess is that source of the problem is in MetadataBuildingProcess class when JdbcType for INTERVAL_SECOND is replaced with one for NUMERIC. If this is fixed, your (slightly changed) test will pass, but another one will now fail. Also, my guess is that this is more general problem, not limited only to Duration’s, but for other types where there is preferred JDBC type. ( https://hibernate.atlassian.net/browse/HHH-16591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16591#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Rafael Winterhalter (JIRA)

Rafael Winterhalter ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16572 ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMjRhYj... ) Re: Incorrect enhancement for PROPERTY attributes with mismatched field and method names ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiMjRhYj... ) Unfortunately no. For this, you would need to use ASM to see if a field is read or written. ( https://hibernate.atlassian.net/browse/HHH-16572#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16572#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Guillaume (JIRA)

Guillaume ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiMzFhMD... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiMzFhMD... ) Exactly same kind of problems here with Hibernate 6.1 and Spring Boot 3.0.6. I can confirm Dan Spangenberger’s comment : we can notice lot’s of duplicate because of one of subclass is already registered… Look’s like it’s not possible to use JSON in subclasses… ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16572 ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiYTg1YW... ) Re: Incorrect enhancement for PROPERTY attributes with mismatched field and method names ( https://hibernate.atlassian.net/browse/HHH-16572?atlOrigin=eyJpIjoiYTg1YW... ) Maybe a better way to ask… Given a net.bytebuddy.description.method.MethodDescription , is there a way to access the instructions? E.g. to find the return instruction to see what field is returned. ( https://hibernate.atlassian.net/browse/HHH-16572#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16572#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16597) Allow parameters for @CompositeType

by Timon Zilles (JIRA)

Timon Zilles ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2Q0OGEzOGE4... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16597?atlOrigin=eyJpIjoiN2Q0OG... ) HHH-16597 ( https://hibernate.atlassian.net/browse/HHH-16597?atlOrigin=eyJpIjoiN2Q0OG... ) Allow parameters for @CompositeType ( https://hibernate.atlassian.net/browse/HHH-16597?atlOrigin=eyJpIjoiN2Q0OG... ) Issue Type: Improvement Affects Versions: 6.2.1 Assignee: Unassigned Components: hibernate-core Created: 12/May/2023 05:31 AM Priority: Blocker Reporter: Timon Zilles ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In Hibernate 5 it was possible to create a CompositeUserType , which was used in the org.hibernate.annotations.Type annotation. This allowed (and does it also in Hibernate 6) to provided parameters. In Hibernate 6 we have to use the new CompositeType annotation, but this does not allow the definition of parameters. Unfortunately this is a blocker for us. We have hundreds of properties where each one has an own parameter value that has to be provided for the composite user type. Please add the parameters to the CompositeType annotation and use them like in a “normal” user types that implements ParameterizedType. ( https://hibernate.atlassian.net/browse/HHH-16597#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16597#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (WEBSITE-646) Broken link: https://hibernate.org/orm/releases/%20in%20browserhttps://hibernate.org/orm/releases/%20in%20browser

by Yoann Rodière (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16596) HQL queries which place restrictions in 'join fetch'ed collection

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjExNzFhYTMz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16596?atlOrigin=eyJpIjoiZjExNz... ) HHH-16596 ( https://hibernate.atlassian.net/browse/HHH-16596?atlOrigin=eyJpIjoiZjExNz... ) HQL queries which place restrictions in 'join fetch'ed collection ( https://hibernate.atlassian.net/browse/HHH-16596?atlOrigin=eyJpIjoiZjExNz... ) Issue Type: Bug Assignee: Unassigned Components: query-hql Created: 12/May/2023 04:32 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hibernate accepts this query: from Loan l join fetch extensions e where e.exNo = 999 I’m pretty sure it should reject it, since it could result in a partially-initialized collection. ( https://hibernate.atlassian.net/browse/HHH-16596#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16596#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16595) Different SQL queries for @ManyToMany relationships in Hibernate 5 and 6

by Lubos Mikusiak (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16595) Different SQL queries for @ManyToMany relatinships in Hibernate 5 and 6

by Lubos Mikusiak (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16595) Different SQL queries for @ManyToMany relatinships in Hibernate 5 and 6

by Lubos Mikusiak (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16595) Different SQL queries for @ManyToMany relatinships in Hibernate 5 and 6

by Lubos Mikusiak (JIRA)

Lubos Mikusiak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTk1OWM4MWQz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16595?atlOrigin=eyJpIjoiOTk1OW... ) HHH-16595 ( https://hibernate.atlassian.net/browse/HHH-16595?atlOrigin=eyJpIjoiOTk1OW... ) Different SQL queries for @ManyToMany relatinships in Hibernate 5 and 6 ( https://hibernate.atlassian.net/browse/HHH-16595?atlOrigin=eyJpIjoiOTk1OW... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: query-sql Created: 12/May/2023 02:55 AM Priority: Major Reporter: Lubos Mikusiak ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In Hibernate 5, two “cascading“ joins are generated for many-to-many relationships. In Hibernate 6, a join with a nested join is generated instead. I observed much longer response times for some queries generated by Hibernate 6. In Postgres, the execution plans are different. Here is an example that illustrates this @Entity @Table(name = "entity_1" ) public class Entity1 { @Id private Long id; @ManyToMany @JoinTable(name = "join_table" , joinColumns = @JoinColumn(name = "entity_1_id" , referencedColumnName = "id" ), inverseJoinColumns = @JoinColumn(name = "entity_2_id" , referencedColumnName = "id" )) private Set<Entity2> relatedEntities2; } @Entity @Table(name = "entity_2" ) public class Entity2 { @Id private Long id; private String naturalId; } When executing @Query( "select entity1" + " from Entity1 entity1" + " inner join entity1.relatedEntities2 as relatedEntities2" + " where relatedEntities2.naturalId = :naturalId" ) List<Entity1> findAllByEntity2NaturalId( String naturalId); Hibernate 5 generates select entity1x0_.id as id1_0_ from entity_1 entity1x0_ inner join join_table relatedent1_ on entity1x0_.id=relatedent1_.entity_1_id inner join entity_2 entity2x2_ on relatedent1_.entity_2_id=entity2x2_.id where entity2x2_.natural_id=? Hibernate 6 generates select e1_0.id from entity_1 e1_0 join (join_table r1_0 join entity_2 r1_1 on r1_1.id=r1_0.entity_2_id) on e1_0.id=r1_0.entity_1_id where r1_1.natural_id=? In dataset that work with, the Hibernate 6 version of the queries results often in full table scans while Hibernate 5 versions use indices. The queries on that dataset are much more complex though than this simple example. *Questions* * Was it a conscious decision to use different structure of the join clauses or a side effect of introducing SQM? * If conscious decision, is it possible to use a hint with Hibernate 6 that results in a query with two “cascading“ joins? ( https://hibernate.atlassian.net/browse/HHH-16595#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16595#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Brian Forkan (JIRA)

Brian Forkan ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOWZkND... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOWZkND... ) Have you had a chance to look at this one ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-12145) Example criteria doesn't include Id-Fields

by Sven Herbold (JIRA)

Sven Herbold ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-12145 ( https://hibernate.atlassian.net/browse/HHH-12145?atlOrigin=eyJpIjoiZTViMD... ) Re: Example criteria doesn't include Id-Fields ( https://hibernate.atlassian.net/browse/HHH-12145?atlOrigin=eyJpIjoiZTViMD... ) Hi, while updating to Spring Boot 3 I came across this issue in our code working around the described problem. I was successfully able to migrate it using JPA Criteria Query and Query By Example. Everything works as expected. From my point of view this issue can be closed. Sorry for the late answer and thanks for your patience. 😉 ( https://hibernate.atlassian.net/browse/HHH-12145#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-12145#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiODhlNT... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiODhlNT... ) Well, if integer and tinyint should be considered equivalent, then solution is very simple. Just uncomment line 1530 in org.hibernate.dialect.Dialect. > > > > // || isIntegral(typeCode1) && isIntegral(typeCode2) > > It has been commented-out in commit 736dfac693ae56a854e620ee0ee02be31f88a4fe and replaced with > > > > isSmallOrTinyInt(typeCode1) && isSmallOrTinyInt(typeCode2) //special case > for HHH-15288 ( https://hibernate.atlassian.net/browse/HHH-15288 ) Closed migration > > > > and six days later in commit 5089df203676657f51603d387fb55a65a916ac54 this added line has been removed. After uncommenting this line, test case will not fail. ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:e4eb869 )

2 years, 11 months

1
0
0 / 0

[JIRA] (WEBSITE-646) Broken link: https://hibernate.org/orm/releases/%20in%20browserhttps://hibernate.org/orm/releases/%20in%20browser

by Website Form collector (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16594) Query cache miss when query contains multiple parameters

by Yunus Evren (JIRA)

Yunus Evren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTJkODIyMDY3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZTJkOD... ) HHH-16594 ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZTJkOD... ) Query cache miss when query contains multiple parameters ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZTJkOD... ) Change By: Yunus Evren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When query caching is enabled on a query that contains multiple query parameters, subsequent queries with the exact same parameters run into cache misses. This seems to be caused because {{QueryKey.ParameterBindingsMementoImpl}} is constructed with a random order of parameter bindings in each different transaction. See {{generateQueryKeyMemento()}} method: [https://github.com/hibernate/hibernate-orm/blob/6.2.2/hibernate-core/src/...] {{parameterBindingMap}} is a {{ConcurrentHashMap}} that will have an unpredictable order in each session. This method iterates over the values of this map and alters the {{hashCode}} of the cache key on each {{addToCacheKey()}} call. Different order of parameters result in {{ParameterBindingsMemento}} objects with different {{hashCode}} values even though they consist of exact identical parameters. This eventually results in a cache miss because the cache key object ({{QueryKey}}) equals method will return false when comparing the inner ParameterBindingsMemento objects that have different {{hashCode}}s: [https://github.com/hibernate/hibernate-orm/blob/6.2.2/hibernate-core/src/...] The issue does not occur when query contains only 1 parameter because the order will be unchanged. If the query contains 2 parameters, then you have 50% chance for miss. If it has more parameters the possibility to miss increases exponentially. This is impacting the performance of the application quite severely because queries that have e.g. 7 parameters have 1/5040 (7 factorial) chance to do a cache hit the second time. So in practice, query cache is more or less not working at all for these queries. Reproducer test case to be added , work in progress…. ( https://hibernate.atlassian.net/browse/HHH-16594#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16594#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16589) In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000

by Adrodoc (JIRA)

Adrodoc ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b2a4a0... ) *commented* on HHH-16589 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiOTNhZT... ) Re: In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiOTNhZT... ) I added fixes for all the bugs i mentioned in https://github.com/hibernate/hibernate-orm/pull/6555 ( https://hibernate.atlassian.net/browse/HHH-16589#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16589#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16594) Query cache miss when query contains multiple parameters

by Yunus Evren (JIRA)

Yunus Evren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjRkNmVhNGUw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZjRkNm... ) HHH-16594 ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZjRkNm... ) Query cache miss when query contains multiple parameters ( https://hibernate.atlassian.net/browse/HHH-16594?atlOrigin=eyJpIjoiZjRkNm... ) Issue Type: Bug Affects Versions: 6.1.5, 6.2.2 Assignee: Unassigned Created: 11/May/2023 13:00 PM Priority: Major Reporter: Yunus Evren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) When query caching is enabled on a query that contains multiple query parameters, subsequent queries with the exact same parameters run into cache misses. This seems to be caused because QueryKey.ParameterBindingsMementoImpl is constructed with a random order of parameter bindings in each different transaction. See generateQueryKeyMemento() method: https://github.com/hibernate/hibernate-orm/blob/6.2.2/hibernate-core/src/... parameterBindingMap is a ConcurrentHashMap that will have an unpredictable order in each session. This method iterates over the values of this map and alters the hashCode of the cache key on each addToCacheKey() call. Different order of parameters result in ParameterBindingsMemento objects with different hashCode values even though they consist of exact identical parameters. This eventually results in a cache miss because the cache key object ( QueryKey ) equals method will return false when comparing the inner ParameterBindingsMemento objects that have different {{hashCode}}s: https://github.com/hibernate/hibernate-orm/blob/6.2.2/hibernate-core/src/... The issue does not occur when query contains only 1 parameter because the order will be unchanged. If the query contains 2 parameters, then you have 50% chance for miss. If it has more parameters the possibility to miss increases exponentially. This is impacting the performance of the application quite severely because queries that have e.g. 7 parameters have 1/5040 (7 factorial) chance to do a cache hit the second time. So in practice, query cache is more or less not working at all for these queries. Reproducer test case to be added, work in progress… ( https://hibernate.atlassian.net/browse/HHH-16594#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16594#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16593) mappedBy non-association

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16593 ( https://hibernate.atlassian.net/browse/HHH-16593?atlOrigin=eyJpIjoiODZhMW... ) Re: mappedBy non-association ( https://hibernate.atlassian.net/browse/HHH-16593?atlOrigin=eyJpIjoiODZhMW... ) This can be closed. ( https://hibernate.atlassian.net/browse/HHH-16593#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16593#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16593) mappedBy non-association

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16593) mappedBy non-association

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2QyY2IzNjVk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16593?atlOrigin=eyJpIjoiY2QyY2... ) HHH-16593 ( https://hibernate.atlassian.net/browse/HHH-16593?atlOrigin=eyJpIjoiY2QyY2... ) mappedBy non-association ( https://hibernate.atlassian.net/browse/HHH-16593?atlOrigin=eyJpIjoiY2QyY2... ) Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 11/May/2023 12:07 PM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The following mapping resulted in a CCE: @Entity static class Loan { @Id @Column(name = "LOAN_ID" ) private Long id; @OneToMany(cascade = PERSIST, mappedBy = "exLoanId" ) private List<Extensions> extensions = new ArrayList<>(); } @Entity static class Extensions { @Id @Column(name = "EX_LOAN_ID" ) private Long exLoanId; @Id @Column(name = "EX_NO" ) private Long exNo; @Column(name = "EX_EXTENSION_DAYS" ) private Long exExtensionDays; } I have fixed this, because it was easy. ( https://hibernate.atlassian.net/browse/HHH-16593#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16593#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16592) @MapsId and @ManyToOne

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWQxMzhiNWM1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiOWQxMz... ) HHH-16592 ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiOWQxMz... ) @MapsId and @ManyToOne ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiOWQxMz... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It seems very clear that the JPA spec expects the following mapping to work: { noformat code:java }@Entity static class Loan { @Id @Column(name = "LOAN_ID") private Long id; @OneToMany(cascade = CascadeType.ALL, mappedBy = "loan") private List<Extension> extensions = new ArrayList<>(); } @Entity static class Extension { @Id @Column(name = "EX_LOAN_ID") private Long exLoanId; @Id @Column(name = "EX_NO") private Long exNo; @Column(name = "EX_EXTENSION_DAYS") private Long exExtensionDays; @ManyToOne @MapsId @JoinColumn(name = "EX_LOAN_ID") private Loan loan; }{ noformat code } The workaround is to use {{insertable=false, updateable=false}} instead of {{@MapsId}}. { noformat code:java }@Entity static class Loan { @Id @Column(name = "LOAN_ID") private Long id; @OneToMany(cascade = CascadeType.ALL, mappedBy = "loan") private List<Extension> extensions = new ArrayList<>(); } @Entity static class Extension { @Id @Column(name = "EX_LOAN_ID") private Long exLoanId; @Id @Column(name = "EX_NO") private Long exNo; @Column(name = "EX_EXTENSION_DAYS") private Long exExtensionDays; @ManyToOne @JoinColumn(name = "EX_LOAN_ID", insertable = false, updatable = false) private Loan loan; }{ noformat code } ( https://hibernate.atlassian.net/browse/HHH-16592#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16592#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16592) @MapsId and @ManyToOne

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2M0MjI3ZmM3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiN2M0Mj... ) HHH-16592 ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiN2M0Mj... ) @MapsId and @ManyToOne ( https://hibernate.atlassian.net/browse/HHH-16592?atlOrigin=eyJpIjoiN2M0Mj... ) Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 11/May/2023 12:03 PM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It seems very clear that the JPA spec expects the following mapping to work: @Entity static class Loan { @Id @Column(name = "LOAN_ID") private Long id; @OneToMany(cascade = CascadeType.ALL, mappedBy = "loan") private List<Extension> extensions = new ArrayList<>(); } @Entity static class Extension { @Id @Column(name = "EX_LOAN_ID") private Long exLoanId; @Id @Column(name = "EX_NO") private Long exNo; @Column(name = "EX_EXTENSION_DAYS") private Long exExtensionDays; @ManyToOne @MapsId @JoinColumn(name = "EX_LOAN_ID") private Loan loan; } The workaround is to use insertable=false, updateable=false instead of @MapsId. @Entity static class Loan { @Id @Column(name = "LOAN_ID") private Long id; @OneToMany(cascade = CascadeType.ALL, mappedBy = "loan") private List<Extension> extensions = new ArrayList<>(); } @Entity static class Extension { @Id @Column(name = "EX_LOAN_ID") private Long exLoanId; @Id @Column(name = "EX_NO") private Long exNo; @Column(name = "EX_EXTENSION_DAYS") private Long exExtensionDays; @ManyToOne @JoinColumn(name = "EX_LOAN_ID", insertable = false, updatable = false) private Loan loan; } ( https://hibernate.atlassian.net/browse/HHH-16592#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16592#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16552) Add new CockroachDB version (v23.1) to CI

by Karel Maesen (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16589) In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000

by Adrodoc (JIRA)

Adrodoc ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b2a4a0... ) *commented* on HHH-16589 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiYWY3NG... ) Re: In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiYWY3NG... ) While coding a fix I noticed two additional Bugs in this code: * For a NOT-IN-Clause you would have to use AND instead of OR. Currently Hibernate generates a query like ID not in(?,?,?,?,...) or ID not in }}which is incorrect. It should be {{ID not in(?,?,?,?,...) and ID not in. * No braces are added around multiple in clauses. For example if you have an additional where clause like ID < ? Hibernate generates ID < ? and id in(?,?,...) or id in. This query ignores the first predicate for all IDs in the second in clause. ( https://hibernate.atlassian.net/browse/HHH-16589#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16589#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiZWI3YW... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiZWI3YW... ) Coercing an integral type into a certain db type is not per sé an error (unless potentially when you put values in it that don’t fit), but the validation shouldn’t fail because unsigned is added to the definition, so this is prob. a legitimate issue, although I still have to look into it to be sure what is going on. ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16591) @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjUwOTZmZDVk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYjUwOT... ) HHH-16591 ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYjUwOT... ) @org.hibernate.annotations.JdbcType does not override the `hibernate.type.preferred_duration_jdbc_type` type ( https://hibernate.atlassian.net/browse/HHH-16591?atlOrigin=eyJpIjoiYjUwOT... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 11/May/2023 09:49 AM Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) According to the docs, the config property: PREFERRED_DURATION_JDBC_TYPE = "hibernate.type.preferred_duration_jdbc_type" Can be overridden on a property level by using annotations: > > > > Can be overridden locally using org.hibernate.annotations.JdbcType, > org.hibernate.annotations.JdbcTypeCode, and friends. > > While specifying a particular JdbcType class works as expected: // will result in using the `PostgreSQLIntervalSecondJdbcType` @Column(precision = 10, scale = 6) @org.hibernate.annotations.JdbcType(PostgreSQLIntervalSecondJdbcType.class) private Duration durationJdbcType; Specifying a JdbcType code - has no effect: // still uses the JdbcType configured by the `PREFERRED_DURATION_JDBC_TYPE` property @Column(precision = 10, scale = 6) @JdbcTypeCode(SqlTypes.INTERVAL_SECOND) private Duration durationJdbcTypeCode; I will submit a test case for this one soon. ( https://hibernate.atlassian.net/browse/HHH-16591#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16591#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16590) Schema update: PostgreSQL byte array does not accept length as parameter

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16590 ( https://hibernate.atlassian.net/browse/HHH-16590?atlOrigin=eyJpIjoiMTkzMj... ) Re: Schema update: PostgreSQL byte array does not accept length as parameter ( https://hibernate.atlassian.net/browse/HHH-16590?atlOrigin=eyJpIjoiMTkzMj... ) Test case and suggested solution in PR 6553 ( https://github.com/hibernate/hibernate-orm/pull/6553 ) ( https://hibernate.atlassian.net/browse/HHH-16590#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16590#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16572) Incorrect enhancement for PROPERTY attributes with mismatched field and method names

by Steve Ebersole (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16590) Schema update: PostgreSQL byte array does not accept length as parameter

by Čedomir Igaly (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16590) Schema update: PostgreSQL byte array does not accept length as parameter

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjM0NDhlOTZj... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16590?atlOrigin=eyJpIjoiNjM0ND... ) HHH-16590 ( https://hibernate.atlassian.net/browse/HHH-16590?atlOrigin=eyJpIjoiNjM0ND... ) Schema update: PostgreSQL byte array does not accept length as parameter ( https://hibernate.atlassian.net/browse/HHH-16590?atlOrigin=eyJpIjoiNjM0ND... ) Issue Type: Improvement Assignee: Unassigned Components: hibernate-core Created: 11/May/2023 08:43 AM Priority: Minor Reporter: Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In PostgreSQL byte array column (bytea) does not have length parameter. When schema is automatically generaed, it will be correctly generated as bytea. However, during schema update length value from column metadata will be compared with either default value or value from @Column annotation (if present). This will, most likely rhan not, cause alter SQL command to be executed. Data type in this generated command will be exactly the same as one use for table creation. In most cases this will have no effect (except waste of time if PostgreSQL is not “smart” enough to ignore column data type change) but in some situations can cause problems. For example when column is used in view definition. ( https://hibernate.atlassian.net/browse/HHH-16590#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16590#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-1851) relax special handling of 'id' property

by Steve Ebersole (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16555) Join fetch query in combination with the inheritance pattern not working in hibernate 6

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiYjc2M2... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiYjc2M2... ) > > > > private int level; > > > > private String deleteDate; > > ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Max (JIRA)

Max ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiMjVjNj... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiMjVjNj... ) Not quite. Only level and delete_date are the problem. Let’s focus on the level. Here is the validation issue: *Property/column* *Database* *Entity (* columnDefinition = *)* level tinyint unsigned tinyint OK level tinyint unsigned tinyint unsigned Not OK ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16589) In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000

by Adrodoc (JIRA)

Adrodoc ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b2a4a0... ) *commented* on HHH-16589 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiMTMzNz... ) Re: In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiMTMzNz... ) To be honest I find it odd, that the power of two padding only applies per inclause. I feel like a better approach would be to just always use a power of two many bind variables, even if that means generating one or more inclause with only null parameters. I mean why should inExprLimit}}affect the number of bind variables used. That doesn’t make any sense to me. The padding is supposed to avoid statement cache polution in the database, so i would expect a statement with 10001 values to use the same number of bind variables as a statement with 10002 parameters, regardless of whether {{inExprLimit is set to 0 or 1000. I would want 16384 bind variables in both cases. So in my opinion the calculation should really be as simple as this: private static int calculateLastInClauseSize( int bindValueCount, int inExprLimit) { int lastInClauseSize = ceilingPowerOfTwoFixed(bindValueCount); if (inExprLimit > 0) { lastInClauseSize %= inExprLimit; } return lastInClauseSize; } ( https://hibernate.atlassian.net/browse/HHH-16589#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16589#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiYThiMT... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiYThiMT... ) Validation is comparing structure of database table (one you have created using “create table” command) and entity class. *Property/column* *Database* *Entity* id int int OK level tinyint int not OK delete_date datetime String not OK ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16589) In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000

by Adrodoc (JIRA)

Adrodoc ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b2a4a0... ) *commented* on HHH-16589 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiYmQ1Yj... ) Re: In-Clause Parameter Padding mistreats Dilect.getInExpressionCountLimit which can cause ORA-01795: maximum number of expressions in a list is 1000 ( https://hibernate.atlassian.net/browse/HHH-16589?atlOrigin=eyJpIjoiYmQ1Yj... ) I analyzed the code further. It took me a while to figure out exactly what it was trying to do. From my understanding bindValueMaxCount is supposed to be the number of bind variables that should be used in the last IN-Clause. Here is a small program that fixes the calculation of bindValueMaxCount and compares it to the current hibernate implementation. The fix not only makes it so that inExprList is properly respected, but also fixes the calculation for values greater that 1073741824 (probably not that important, but the current implementation fails horribly for such large numbers) and personally I find it much easier to understand: package de.sanacorp.security.persistence.base.inclause; import java.util.function.IntBinaryOperator; import org.hibernate.internal.util.MathHelper; public class HHH_16589 { public static void main( String [] args) { System.out.println( "| bindValueCount | inExprLimit | originalResult | proposalResult |" ); System.out.println( "|----------------|-------------|----------------|----------------|" ); IntBinaryOperator original = HHH_16589::hibernate_6_2_2_Final; IntBinaryOperator proposal = HHH_16589::calculateLastInClauseSize; compare(1, 0, original, proposal); compare(2, 0, original, proposal); compare(3, 0, original, proposal); compare(4, 0, original, proposal); compare(5, 0, original, proposal); compare(1000, 0, original, proposal); compare((1 << 30) - 1, 0, original, proposal); compare(1 << 30, 0, original, proposal); compare((1 << 30) + 1, 0, original, proposal); compare( Integer.MAX_VALUE - 1, 0, original, proposal); compare( Integer.MAX_VALUE, 0, original, proposal); compare(1, 1000, original, proposal); compare(7, 1000, original, proposal); compare(8, 1000, original, proposal); compare(511, 1000, original, proposal); compare(512, 1000, original, proposal); compare(513, 1000, original, proposal); compare(999, 1000, original, proposal); compare(1000, 1000, original, proposal); compare(1001, 1000, original, proposal); compare(1008, 1000, original, proposal); compare(1023, 1000, original, proposal); compare(1024, 1000, original, proposal); compare(1025, 1000, original, proposal); compare(1511, 1000, original, proposal); compare(1512, 1000, original, proposal); compare(1513, 1000, original, proposal); compare(1999, 1000, original, proposal); compare(2000, 1000, original, proposal); compare(2001, 1000, original, proposal); compare(2511, 1000, original, proposal); compare(2512, 1000, original, proposal); compare(2513, 1000, original, proposal); compare(2999, 1000, original, proposal); compare(3000, 1000, original, proposal); compare(3001, 1000, original, proposal); compare( Integer.MAX_VALUE - 1, 1000, original, proposal); compare( Integer.MAX_VALUE, 1000, original, proposal); } public static void compare( int bindValueCount, int inExprLimit, IntBinaryOperator original, IntBinaryOperator proposal) { int originalResult = original.applyAsInt(bindValueCount, inExprLimit); int proposalResult = proposal.applyAsInt(bindValueCount, inExprLimit); System.out .println( "| " + bindValueCount + " | " + inExprLimit + " | " + originalResult + " | " + proposalResult + " |" ); } private static int hibernate_6_2_2_Final( int bindValueCount, int inExprLimit) { int bindValueMaxCount = bindValueCount; // bindValueCount: 1005 // bindValuePaddingCount: 1024 int bindValuePaddingCount = MathHelper.ceilingPowerOfTwo(bindValueCount); // inExprLimit: 1000 if (inExprLimit > 0) { if (bindValuePaddingCount > inExprLimit) { // bindValueCount % inExprLimit: 5 // bindValuePaddingCount: 8 if (bindValueCount < inExprLimit) { bindValueMaxCount = inExprLimit; } else { bindValueMaxCount = MathHelper.ceilingPowerOfTwo(bindValueCount % inExprLimit); } } else if (bindValueCount < bindValuePaddingCount) { bindValueMaxCount = bindValuePaddingCount; } } else if (bindValueCount < bindValuePaddingCount) { bindValueMaxCount = bindValuePaddingCount; } return bindValueMaxCount; } private static int calculateLastInClauseSize( int bindValueCount, int inExprLimit) { if (inExprLimit > 0) { int lastInClauseSize = bindValueCount % inExprLimit; int lastInClauseSizeWithPadding = ceilingPowerOfTwoFixed(lastInClauseSize); return Math.min(inExprLimit, lastInClauseSizeWithPadding); } else { return ceilingPowerOfTwoFixed(bindValueCount); } } // This should probably be done in MathHelper already. // If values above 1073741824 (2^30) are not of a concern we could just use MathHelper directly. private static int ceilingPowerOfTwoFixed( int value) { int result = MathHelper.ceilingPowerOfTwo(value); if (result < value) { // Overflow return Integer.MAX_VALUE; } return result; } } When executed the Program prints this Table (as Markdown): bindValueCount inExprLimit originalResult proposalResult 1 0 1 1 2 0 2 2 3 0 4 4 4 0 4 4 5 0 8 8 1000 0 1024 1024 1073741823 0 1073741824 1073741824 1073741824 0 1073741824 1073741824 1073741825 0 1073741825 2147483647 2147483646 0 2147483646 2147483647 2147483647 0 2147483647 2147483647 1 1000 1 1 7 1000 8 8 8 1000 8 8 511 1000 512 512 512 1000 512 512 513 1000 1000 1000 999 1000 1000 1000 1000 1000 1 1 1001 1000 1 1 1008 1000 8 8 1023 1000 32 32 1024 1000 32 32 1025 1000 32 32 1511 1000 512 512 1512 1000 512 512 1513 1000 1024 1000 1999 1000 1024 1000 2000 1000 1 1 2001 1000 1 1 2511 1000 512 512 2512 1000 512 512 2513 1000 1024 1000 2999 1000 1024 1000 3000 1000 1 1 3001 1000 1 1 2147483646 1000 2147483646 1000 2147483647 1000 2147483647 1000 ( https://hibernate.atlassian.net/browse/HHH-16589#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16589#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Max (JIRA)

Max ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiNWMyYz... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiNWMyYz... ) > > > > Validation is ignoring columnDefinition which may or may not be correct > > It’s clearly not ignoring it and that’s the whole problem? Are you looking at the correct line of code? Should be // exception thrown: @Column(name = "level" , columnDefinition = "tinyint UNSIGNED default 0" ) // no exeption thrown: @Column(name = "level" , columnDefinition = "tinyint" ) columnDefinition is the only difference! ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4854) Work around build errors caused by the Maven Pipeline Integration Plugin on Jenkins CI

by Automation for Jira (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4854) Work around build errors caused by the Maven Pipeline Integration Plugin on Jenkins CI

by Yoann Rodière (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4854) Work around build errors caused by the Maven Pipeline Integration Plugin on Jenkins CI

by Yoann Rodière (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16578 ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiMmFlMW... ) Re: Incorrect validation error for tinyint, but and datetime ( https://hibernate.atlassian.net/browse/HHH-16578?atlOrigin=eyJpIjoiMmFlMW... ) From create table statement: > > > > `id` int unsigned NOT NULL AUTO_INCREMENT, > > id is Java primitive int and in table is of type integer and this is OK for validator. Validation is ignoring columnDefinition which may or may not be correct. And for unsigned … Java does not have OOTB unsigned typesand I did not found single occurence of word “unsigned” in Hibernate documentation. Again, it is question if columnDefinition can be ignore or not. ( https://hibernate.atlassian.net/browse/HHH-16578#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16578#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#100225- sha1:84d3b45 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16559) Batch fetch does not initialize bi-directional entity in HQL

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-12981) Join alias is miscalculated when two descendant entities have same attribute name

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-12981) Join alias is miscalculated when two descendant entities have same attribute name

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16553) StackOverflowError when loading entities chained together

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-12981) Join alias is miscalculated when two descendant entities have same attribute name

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16578) Incorrect validation error for tinyint, but and datetime

by Jan Schatteman (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-13235) Java exception when using @CreationTimestamp or @UpdateTimestamp annotation in Embeddable

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-11607) Transient doesn't work with MappedSuperclass values

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues May 2023