January 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15955) Hibernate 6.1.6 Never Uses LimitHandler w/ DB2

by Matt Henry (JIRA)

Matt Henry ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bff329... ) *commented* on HHH-15955 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiM2VkZW... ) Re: Hibernate 6.1.6 Never Uses LimitHandler w/ DB2 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiM2VkZW... ) If: * Database actual version is 12 AND * Compatibility level is set to V11R1 Then this is equivalent to the lowest level outlined in the function level list which is V12R1M100 (which could also be the value returned from the query that checks the level) For the purpose of whether to use the offset keyword or not, that is enabled in V12R1M500 (mentioned here https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-sql-changes-in-db2 ( https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-sql-changes-in-db2 ) , which might also be helpful in determining when other features are turned on in which function level). ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16026) @OrderColumn creating too many (useless) update queries

by Jessy Chenavas (JIRA)

Jessy Chenavas ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGQyNmY2Y2I5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16026?atlOrigin=eyJpIjoiZGQyNm... ) HHH-16026 ( https://hibernate.atlassian.net/browse/HHH-16026?atlOrigin=eyJpIjoiZGQyNm... ) @OrderColumn creating too many (useless) update queries ( https://hibernate.atlassian.net/browse/HHH-16026?atlOrigin=eyJpIjoiZGQyNm... ) Issue Type: Bug Affects Versions: 6.1.6 Assignee: Unassigned Components: hibernate-core Created: 11/Jan/2023 11:01 AM Priority: Minor Reporter: Jessy Chenavas ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hello, recently we started to work with the @OrderColumn feature and found out that by using this the entityManager is creating a lot of update queries where it would not be necessary to have them. Let's take this example: @Entity public class Parent { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @OneToMany(cascade = CascadeType.ALL, mappedBy = "parent", orphanRemoval = true, fetch = FetchType.EAGER) @OrderColumn(name = "pos") private List<Child> childs; ... } @Entity public class Child { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private int pos; @ManyToOne(fetch = FetchType.EAGER) @JoinColumn(name = "parent_id") private Parent parent; ... } We run the following code: SessionFactory sessionFactory = HibernateUtil.getSessionFactory(); Session session = sessionFactory.getCurrentSession(); Transaction tx = session.beginTransaction(); session.save(new Parent(Arrays.asList(new Child(), new Child()))); tx.commit(); sessionFactory.close(); And we can see this output in the logs: Hibernate: insert into Parent (id) values (default) Hibernate: insert into Child (id, parent_id, pos) values (default, ?, ?) Hibernate: insert into Child (id, parent_id, pos) values (default, ?, ?) Hibernate: update Child set pos=? where id=? Hibernate: update Child set pos=? where id=? Why does hibernate need to set the position using a separate query, getting the position is very straightforward (basically just an indexOf on the bag). So why do we have two requests, a first insert with the position set to 0, and then an update to set the right position? In that case it’s not that important, but we end up having performances slowed because of this when saving a lot of entities. ( https://hibernate.atlassian.net/browse/HHH-16026#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16026#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15955) Hibernate 6.1.6 Never Uses LimitHandler w/ DB2

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15955 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiNjFjMz... ) Re: Hibernate 6.1.6 Never Uses LimitHandler w/ DB2 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiNjFjMz... ) Ok, for the purpose of our feature detection, do you think it is ok to treat a database with V11R1 like a DB2 with version 11.0 and so on? ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15949) MetadataBuilderContributor is JPA bootstrap only (isn't discoverable)

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15949 ( https://hibernate.atlassian.net/browse/HHH-15949?atlOrigin=eyJpIjoiNmIyMT... ) Re: MetadataBuilderContributor is JPA bootstrap only (isn't discoverable) ( https://hibernate.atlassian.net/browse/HHH-15949?atlOrigin=eyJpIjoiNmIyMT... ) > > > > I believe they’re loaded as a services, but that does not seem to be > documented anywhere , and it’s not obvious. > > We use Java service loading in lots of places. We probably should collect them in one place for documenting. Not sure what you mean by obvious. Both FunctionContributor and TypeContributor even mention they can be loaded as a Java service ( https://hibernate.atlassian.net/browse/HHH-15949#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15949#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15948) move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15948 ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZWM2NW... ) Re: move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZWM2NW... ) Done. ( https://hibernate.atlassian.net/browse/HHH-15948#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15948#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3910) SPI for integrators to provide their own thread pools

by Automation for Jira (JIRA)

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15948) move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15948 ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZTEyMD... ) Re: move AttributeConverterMutabilityPlanImpl from org.hibernate.type.descriptor.converter to org.hibernate.metamodel.model.convert.internal ( https://hibernate.atlassian.net/browse/HHH-15948?atlOrigin=eyJpIjoiZTEyMD... ) Yep, perfect, that was what I was thinking too. ( https://hibernate.atlassian.net/browse/HHH-15948#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15948#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16025) Using BatchEntitySelectFetchInitializer with caching leads to caching wrong values

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODgxYjg5MWQz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16025?atlOrigin=eyJpIjoiODgxYj... ) HHH-16025 ( https://hibernate.atlassian.net/browse/HHH-16025?atlOrigin=eyJpIjoiODgxYj... ) Using BatchEntitySelectFetchInitializer with caching leads to caching wrong values ( https://hibernate.atlassian.net/browse/HHH-16025?atlOrigin=eyJpIjoiODgxYj... ) Issue Type: Bug Affects Versions: 6.2.0.CR1, 6.1.6 Assignee: Unassigned Components: hibernate-core Created: 11/Jan/2023 07:28 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Coming from this Discourse discussion ( https://discourse.hibernate.org/t/entity-put-into-second-level-cache-with... ) , the problem is when using second level caching along with @BatchSize , because cache entries are put into the cache, before the BatchEntitySelectFetchInitializer for an association set the value on the owning entity, so the cache entry contains null for the association which is wrong. Reading from the cache later leads to materializing wrong data. @Entity @BatchSize(10) @Cacheable @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) class Parent { @Id Long id; @ManyToOne Child c; } @Entity @Cacheable @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) class Child { @Id Long id; String name; } ( https://hibernate.atlassian.net/browse/HHH-16025#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16025#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-15881) Unable to determine TableReference when using QueryBuilder treat

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15881 ( https://hibernate.atlassian.net/browse/HHH-15881?atlOrigin=eyJpIjoiNDJhOW... ) Re: Unable to determine TableReference when using QueryBuilder treat ( https://hibernate.atlassian.net/browse/HHH-15881?atlOrigin=eyJpIjoiNDJhOW... ) Hi Alessandro Moscatelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ad61be... ) , can you please provide a reproducer? You can use this template https://github.com/hibernate/hibernate-test-case-templates ( https://github.com/hibernate/hibernate-test-case-templates ) Thanks ( https://hibernate.atlassian.net/browse/HHH-15881#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15881#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100213- sha1:b01baad )

1 year, 11 months

1
0
0 / 0

[JIRA] (HHH-16024) Change rendering of value parameters in JPA Criteria HQL representation

by Christian Beikov (JIRA)

1 year, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues January 2023