May 2023 - hibernate-issues - Jboss List Archives

[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

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