February 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16236) Cannot use lists and Enums in where clause

by Svetliokapralov (JIRA)

Svetliokapralov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWQwN2NhODI4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiNWQwN2... ) HHH-16236 ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiNWQwN2... ) Cannot use lists and Enums in where clause ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiNWQwN2... ) Change By: Svetliokapralov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) This is a sample project demonstrating several Hibernate 6 problems related to using 'IN (:list)' and Enums (for example select i from ItemEntity where i.status = :status) in where clause: [https://github.com/svkap/hibernate-6-bug-sample|https://github.com/svkap/...] The project uses docker-compose for spinning up PostgreSQL + Flyway for db initialization. It uses spring-data and lombok. It seems there are problems when lists are used in queries and with coalesce. The Entities are fairly simple but have different column types. There are 3 different entity definition: 1. Using PostgreSQL enum + @Enumerated(EnumType.STRING) 2. Using varchar column + @Convert(...) 3. Using int column + @Convert(...) — The sample project tests several different queries and scenarios. Result summary: 1. Entity creation work for all scenarios. 2. Entity update work for all scenarios. 3. Return entity, use SpEl ( (:#{#list == null} = true) OR (i.list IN (:list)) ) works in JPQL 4. Pass Integer/String to native query works for coalesce and SpEl only when projection is returned — The exceptions seem the same when using PostgreSQL enum, Converter + String and Converter + Integer: 1. Return entity, native query + pass enums to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 2. Return entity, native query + pass strings to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 3. Return entity, native query + pass null to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 4. Return entity, native query + pass enums to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 5. Return entity, native query + pass null to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 6. Return entity, native query + pass enum to repository method java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 7. Return entity, native query + pass string to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 8. Return entity, JPQL query + pass enum to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) java.lang.ClassCastException: class java.util.ImmutableCollections$List12 cannot be cast to class java.lang.Enum (java.util.ImmutableCollections$List12 and java.lang.Enum are in module java.base of loader 'bootstrap') 9. Return projection, native query + pass enum to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null ( https://hibernate.atlassian.net/browse/HHH-16236#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16236#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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16236) Cannot use lists and Enums in where clause

by Svetliokapralov (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-4042) StatelessSession does not flush when using jdbc batch_size > 1

by Felix König (JIRA)

Felix König ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a4bad5... ) *commented* on HHH-4042 ( https://hibernate.atlassian.net/browse/HHH-4042?atlOrigin=eyJpIjoiOTY1MTI... ) Re: StatelessSession does not flush when using jdbc batch_size > 1 ( https://hibernate.atlassian.net/browse/HHH-4042?atlOrigin=eyJpIjoiOTY1MTI... ) This is still a problem and source of potential data loss in hibernate 6.1.7. For my case, which is Spring Boot, I’ve implemented this workaround: @Service public class StatelessSessionRunner { private final Session session; public StatelessSessionRunner(Session session) { this.session = session; } public <T> T runWithStatelessSession(Function<StatelessSession, T> func) { return session.doReturningWork(connection -> { try (StatelessSession statelessSession = session.getSessionFactory().openStatelessSession(connection)) { var result = func.apply(statelessSession); // workaround for https://hibernate.atlassian.net/browse/HHH-4042 ((SharedSessionContractImplementor) statelessSession).getJdbcCoordinator().executeBatch(); return result; } }); } } Which allows you to perform some operations using a stateless session within a larger transaction. ( https://hibernate.atlassian.net/browse/HHH-4042#add-comment?atlOrigin=eyJ... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-4042#add-comment?atlOrigin=eyJ... ) 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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4808) Add configuration option for Elasticsearch connection keep-alive

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiNjlmN2My... ) / New Feature ( https://hibernate.atlassian.net/browse/HSEARCH-4808?atlOrigin=eyJpIjoiNjl... ) HSEARCH-4808 ( https://hibernate.atlassian.net/browse/HSEARCH-4808?atlOrigin=eyJpIjoiNjl... ) Add configuration option for Elasticsearch connection keep-alive ( https://hibernate.atlassian.net/browse/HSEARCH-4808?atlOrigin=eyJpIjoiNjl... ) Issue Type: New Feature Assignee: Unassigned Components: backend-elasticsearch Created: 28/Feb/2023 05:01 AM Fix Versions: 6.2-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Seems like this problem ( https://stackoverflow.com/questions/52997697/how-to-get-around-connection... ) is relatively widespread. It would be nice to provide a configuration property to limit the keep-alive, e.g.: hibernate.search.backend.max_keep_alive See com.amazonaws.http.conn.SdkConnectionKeepAliveStrategy for a nice implementation of what we need, and the link above for how to set that strategy. ( https://hibernate.atlassian.net/browse/HSEARCH-4808#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4808#add-comment?atlOrigin... ) 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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16239) Queries with LIKE-filters always return empty results with H2 database in Oracle Compatibility Mode

by Felix König (JIRA)

Felix König ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a4bad5... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGVhZTFlMzVj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16239?atlOrigin=eyJpIjoiNGVhZT... ) HHH-16239 ( https://hibernate.atlassian.net/browse/HHH-16239?atlOrigin=eyJpIjoiNGVhZT... ) Queries with LIKE-filters always return empty results with H2 database in Oracle Compatibility Mode ( https://hibernate.atlassian.net/browse/HHH-16239?atlOrigin=eyJpIjoiNGVhZT... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 28/Feb/2023 04:43 AM Labels: H2 Priority: Major Reporter: Felix König ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a4bad5... ) https://hibernate.atlassian.net/browse/HHH-15736 ( https://hibernate.atlassian.net/browse/HHH-15736 ) (merge request https://github.com/hibernate/hibernate-orm/pull/5746 ( https://github.com/hibernate/hibernate-orm/pull/5746 ) ) introduced a regression for LIKE-queries in H2 databases running in ORACLE-compatibility mode. Setting escape '' successfully disables the escape character if running H2 in its default configuration. However, when running H2 in Oracle compatibility mode, H2 fails to return any results. I opened an issue with H2 ( https://github.com/h2database/h2database/issues/3745 ( https://github.com/h2database/h2database/issues/3745 ) ), and it seems users are advised against attempting to use escape ‘' in Oracle-compatibility mode. But starting with hibernate 6.1.7, this possibly illegal use of escape '' is now the default behaviour. *Workaround* : Explicitly set a non-null escape character for LIKE-expressions, so the newly introduced special case does not get executed. *Possible solution* : Detect whether H2 is running in Oracle Compatibility Mode, and skip the newly introduced special case then. ( https://hibernate.atlassian.net/browse/HHH-16239#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16239#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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16236) Cannot use lists in where clause

by Svetliokapralov (JIRA)

Svetliokapralov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDc0NTk2Mzg1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiZDc0NT... ) HHH-16236 ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiZDc0NT... ) Cannot use lists in where clause ( https://hibernate.atlassian.net/browse/HHH-16236?atlOrigin=eyJpIjoiZDc0NT... ) Change By: Svetliokapralov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) This is a sample project demonstrating several Hibernate 6 problems related to using 'IN (:list)' in where clause: [ https://github.com/svkap/hibernate-6-bug-sample |https://github.com/svkap/hibernate-6-bug-sample] The project uses docker-compose for spinning up PostgreSQL + Flyway for db initialization. It uses spring-data and lombok. It seems there are problems when lists are used in queries and with coalesce. The Entities are fairly simple but have different column types. There are 3 different entity definition: 1. Using PostgreSQL enum + @Enumerated(EnumType.STRING) 2. Using varchar column + @Convert(...) 3. Using int column + @Convert(...) --- — The sample project tests several different queries and scenarios. Result summary: 1. Entity creation work for all scenarios. 2. Entity update work for all scenarios. 3. Return entity, use SpEl ( (:#{#list == null} = true) OR (i.list IN (:list)) ) works in JPQL 4. Pass Integer/String to native query works for coalesce and SpEl only when projection is returned --- — The exceptions seem the same when using PostgreSQL enum, Converter + String and Converter + Integer: 1. Return entity, native query + pass enums to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) 1. java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 2. Return entity, native query + pass strings to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) 1. org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 3. Return entity, native query + pass null to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) 1. org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 4. Return entity, native query + pass enums to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) 1. java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 5. Return entity, native query + pass null to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) 1. org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 6. Return entity, native query + pass enum to repository method 1. java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null 7. Return entity, native query + pass string to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) 1. org.springframework.dao.InvalidDataAccessResourceUsageException: Unable to find column position by name: id; SQL [n/a] 7 8. Return entity, JPQL query + pass enum to repository method + ( (coalesce(:list, null) is null) OR (i.list IN (:list)) ) 1. java.lang.ClassCastException: class java.util.ImmutableCollections$List12 cannot be cast to class java.lang.Enum (java.util.ImmutableCollections$List12 and java.lang.Enum are in module java.base of loader 'bootstrap') 7 9. Return projection, native query + pass enum to repository method + ( (:#{#list == null} = true) OR (i.list IN (:list)) ) 1. java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because "jdbcMapping" is null ( https://hibernate.atlassian.net/browse/HHH-16236#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16236#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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-16238) Add support for mulitple generic embeddable properties in MappedSuperclass

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGM5M2YwZDZm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16238?atlOrigin=eyJpIjoiNGM5M2... ) HHH-16238 ( https://hibernate.atlassian.net/browse/HHH-16238?atlOrigin=eyJpIjoiNGM5M2... ) Add support for mulitple generic embeddable properties in MappedSuperclass ( https://hibernate.atlassian.net/browse/HHH-16238?atlOrigin=eyJpIjoiNGM5M2... ) Change By: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) At the moment an {{@Entity}} can extend a {{@MappedSuperclass}} which has two or more generic embeddable properties. This will work, but when trying to query the actual properties inside the *concrete* embeddable types (as opposed to the generic ones) an error will be thrown because we have no way of retrieving them. [https://hibernate.atlassian.net/browse/HHH-16195|https://hibernate.atlass... embeddable-typed _declaredProperties_ registration for generic embeddables on the superclass, and [https://hibernate.atlassian.net/browse/HHH-16188|https://hibernate.atlass... prepared a foundation to register the actual concrete embeddable types that for now is only used for identifiers: * {{org.hibernate.metamodel.model.domain.AbstractManagedType.InFlightAccessImpl# applyGenericEmbeddableAttribute addGenericEmbeddableAttribute }} * {{org.hibernate.metamodel.model.domain.AbstractManagedType#findGenericEmbeddableAttribute}} This issue should address resolving concrete embeddable types for non-identifier properties. ( https://hibernate.atlassian.net/browse/HHH-16238#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16238#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#100217- sha1:65be9f2 )

1 year, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4721) Re-enable tests disabled because of HHH-15606/HHH-15967

by Automation for Jira (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4721) Re-enable tests disabled because of HHH-15606/HHH-15967

by Yoann Rodière (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4721) Re-enable tests disabled because of HHH-15606/HHH-15967/HHH-16219

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4721 ( https://hibernate.atlassian.net/browse/HSEARCH-4721?atlOrigin=eyJpIjoiNTA... ) Re: Re-enable tests disabled because of HHH-15606/HHH-15967/HHH-16219 ( https://hibernate.atlassian.net/browse/HSEARCH-4721?atlOrigin=eyJpIjoiNTA... ) https://hibernate.atlassian.net/browse/HHH-16219 ( https://hibernate.atlassian.net/browse/HHH-16219 ) has been rejected; the problem apparently comes from our model (which is obviously suboptimal, but for good reasons) leading to crazy lazy loading. Hibernate ORM 5 was executing many more queries than necessary, and ORM 6 bundles them into one, but unfortunately that means many joins. I’ll submit a PR to fix that. ( https://hibernate.atlassian.net/browse/HSEARCH-4721#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4721#add-comment?atlOrigin... ) 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#100217- sha1:65be9f2 )

1 year, 9 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 February 2023