March 2023 - hibernate-issues - Jboss List Archives

Hinnerk Oetting ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c87511... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTExZjBkYWQx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16277?atlOrigin=eyJpIjoiYTExZj... ) HHH-16277 ( https://hibernate.atlassian.net/browse/HHH-16277?atlOrigin=eyJpIjoiYTExZj... ) LIKE Queries not working anymore in H2database with oracle compatibility mode ( https://hibernate.atlassian.net/browse/HHH-16277?atlOrigin=eyJpIjoiYTExZj... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 09/Mar/2023 07:24 AM Environment: Java 17 Hibernate 6.1.7 spring-data 3.0.4 Priority: Major Reporter: Hinnerk Oetting ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c87511... ) *Problem* We are trying to update to hibernate 6.1.7 and found an issue when running LIKE queries with our h2-database in oracle compatibility mode. Queries do not return any result at all. *Details* Since this change https://github.com/hibernate/hibernate-orm/commit/4d75202f0cff2843ab9b03e... ( https://github.com/hibernate/hibernate-orm/commit/4d75202f0cff2843ab9b03e... ) hibernate renders ESCAPE '' behind each LIKE statement. So what was previously select u1_0.id,u1_0.name from users u1_0 where u1_0.name like ? became select u1_0.id,u1_0.name from users u1_0 where u1_0.name like ? escape '' This works with the h2database in regular mode, but unfortunately it does not work in oracle mode ( SET MODE oracle; ). Every statement that is using {{ escape ''}} will return no result at all. An issue for the h2database was created, but they do not want to fix it (escape '' is invalid for Oracle, see https://github.com/h2database/h2database/issues/3745 ( https://github.com/h2database/h2database/issues/3745 ) ) I understand why it that change in hibernate was made, but it would be great if a change would be made so that we can configure hibernate to not render escape '' in our case. *Workaround* As a workaround we are currently adding ESCAPE ‘ ’ to all LIKE statements but that is quite ugly. For example we are changing @Query("from User where name LIKE %:name% ") to @Query("from User where name LIKE %:name% ESCAPE '\\'") Also since we are using Oracle on production, it slightly changes our queries (Oracle does not use an Escape character by default) but that is probably not the biggest issue. *Reproduce* I created a minimal testcase for this issue here https://github.com/hinnerkoetting/hibernate-h2-like-escape-issue ( https://github.com/hinnerkoetting/hibernate-h2-like-escape-issue ) Run it by calling ./gradlew test It contains two testcases. One testcase runs the h2-database in regular mode, one testcase in oracle mode which is currently failing. ( https://hibernate.atlassian.net/browse/HHH-16277#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16277#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:e5bf00f )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16276) OrderingExpression (ColumnReference) should be made readable when added to thrown Exception

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16276 ( https://hibernate.atlassian.net/browse/HHH-16276?atlOrigin=eyJpIjoiMzFlNj... ) Re: OrderingExpression (ColumnReference) should be made readable when added to thrown Exception ( https://hibernate.atlassian.net/browse/HHH-16276?atlOrigin=eyJpIjoiMzFlNj... ) workaround is to update the persistence.xml with: {{  }} <property name="hibernate.jpa.compliance.orderby" value="false"/> ( https://hibernate.atlassian.net/browse/HHH-16276#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16276#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:e5bf00f )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16276) OrderingExpression (ColumnReference) should be made readable when added to thrown Exception

by Scott Marlow (JIRA)

Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzRjMjAzYWYx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16276?atlOrigin=eyJpIjoiYzRjMj... ) HHH-16276 ( https://hibernate.atlassian.net/browse/HHH-16276?atlOrigin=eyJpIjoiYzRjMj... ) OrderingExpression (ColumnReference) should be made readable when added to thrown Exception ( https://hibernate.atlassian.net/browse/HHH-16276?atlOrigin=eyJpIjoiYzRjMj... ) Issue Type: Improvement Affects Versions: 6.2.0.CR3 Assignee: Unassigned Created: 09/Mar/2023 06:44 AM Fix Versions: 6.2.0 Priority: Major Reporter: Scott Marlow ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) git clone https://github.com/scottmarlow/orm-bootstrap-benchmarks ( https://github.com/scottmarlow/orm-bootstrap-benchmarks ) cd orm-bootstrap-benchmarks git fetch --all git checkout orm6.2 switch to jdk11 mvn clean install cd .. git clone https://github.com/wildfly/wildfly/ ( https://github.com/wildfly/wildfly/ ) cd wildfly ./build.sh clean install -DskipTests=true cd dist/target/wildfly-28.0.0.Beta1-SNAPSHOT cp ../../../../orm-bootstrap-benchmarks/target/orm-boostrap-0.0.1.jar standalone/deployment cd bin to debug, update standalone.conf and add or uncomment line with JAVA_OPTS="$JAVA_OPTS -agentlib:jdwp=transport=dt_socket,address=8787,server=y,suspend=y" ./standalone.sh You should see the following exception: Caused by: org.hibernate.metamodel.mapping.ordering.ast.OrderByComplianceViolation: `@OrderBy` expression (Line) resolved to `org.hibernate.metamodel.mapping.ordering.ast.ColumnReference@1e3f672f` which is not a domain-model reference which violates the JPA specification at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.ordering.ast.ParseTreeVisitor.visitSortSpecification(ParseTreeVisitor.java:71) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.ordering.ast.ParseTreeVisitor.visitOrderByFragment(ParseTreeVisitor.java:47) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.ordering.OrderByFragmentTranslator.translate(OrderByFragmentTranslator.java:60) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.PluralAttributeMappingImpl.finishInitialization(PluralAttributeMappingImpl.java:235) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.MappingModelCreationHelper.lambda$buildPluralAttributeMapping$2(MappingModelCreationHelper.java:647) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess$PostInitCallbackEntry.process(MappingModelCreationProcess.java:246) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess.executePostInitCallbacks(MappingModelCreationProcess.java:106) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess.execute(MappingModelCreationProcess.java:88) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess.process(MappingModelCreationProcess.java:40) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.metamodel.model.domain.internal.MappingMetamodelImpl.finishInitialization(MappingMetamodelImpl.java:201) at org.hibernate(a)6.2.0-SNAPSHOT//org.hibernate.internal.SessionFactoryImpl$1.<init>(SessionFactoryImpl.java:275) at org.hibernate(a)6.2.0-SNAPSHOT//org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:268) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:431) at org.hibernate@6.2.0-SNAPSHOT//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1455) ... 12 more ( https://hibernate.atlassian.net/browse/HHH-16276#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16276#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:e5bf00f )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16215) Composite primary key @IdClass attribute mapping is borrowed from the first OneToMany backref and cannot be set

by Andrea Boriero (JIRA)

1 year, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues March 2023