May 2023 - hibernate-issues - Jboss List Archives

[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

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