March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16401) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904

by Christoph Aigensberger (JIRA)

Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) *commented* on HHH-16401 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiZTFmNT... ) Re: Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiZTFmNT... ) BooleanToStringTest.java ( https://hibernate.atlassian.net/secure/attachment/50273/50273_BooleanToSt... ) ( https://hibernate.atlassian.net/browse/HHH-16401#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16401#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16401) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904

by Christoph Aigensberger (JIRA)

Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjE0NDk0YTBm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiNjE0ND... ) HHH-16401 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiNjE0ND... ) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiNjE0ND... ) Change By: Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) I have updated to the latest Development Version, and I am now seeing ORA-00904 poping up all over my Spring Boot development environment. JDBC exception executing SQL [… (b1_0.field1!=K or (b1_0.field1!=H …] [ORA-00904: "H": invalid identifier ] [n/a]; SQL [n/a] It seems like HQL Parameters are incorrectly escaped This is how they look in the HQL … test.field1='K' or test.field<>'H' … The same issue arrises when a Boolean with a converter is converted to a String. I.e. lets take a converter that translates true → “Y” and false → “N“ JDBC exception executing SQL [… (b1_0.field1=Y …] [ORA-00904: "Y": invalid identifier ] [n/a]; SQL [n/a] This is how the query looks in the HQL … test.field1= true … Is this a issue caused by Hibernate or should I reach out to Spring Data? I am also unsure how to build a test case for this as it only seems to apply to Oracle, I still attempted it, but was unable to reproduce it on my end with it ( https://hibernate.atlassian.net/browse/HHH-16401#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16401#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16401) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904

by Christoph Aigensberger (JIRA)

Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGIyOGQ2M2Jh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiMGIyOG... ) HHH-16401 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiMGIyOG... ) Hibernate does not escape Parameters correctly when using Oracle which causes ORA-00904 ( https://hibernate.atlassian.net/browse/HHH-16401?atlOrigin=eyJpIjoiMGIyOG... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Created: 30/Mar/2023 02:15 AM Priority: Major Reporter: Christoph Aigensberger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a72294... ) I have updated to the latest Development Version, and I am now seeing ORA-00904 poping up all over my Spring Boot development environment. JDBC exception executing SQL [… (b1_0.field1!=K or (b1_0.field1!=H …] [ORA-00904: "H": invalid identifier ] [n/a] ; SQL [n/a] It seems like HQL Parameters are incorrectly escaped This is how they look in the HQL … test.field1='K' or test.field<>'H' … The same issue arrises when a Boolean with a converter is converted to a String. I.e. lets take a converter that translates true → “Y” and false → “N“ JDBC exception executing SQL [… (b1_0.field1=Y …] [ORA-00904: "Y": invalid identifier ] [n/a] ; SQL [n/a] This is how the query looks in the HQL … test.field1= true … Is this a issue caused by Hibernate or should I reach out to Spring Data? ( https://hibernate.atlassian.net/browse/HHH-16401#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16401#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16340) Duplicate column exception when mapping discriminator column inside an EmbeddedId

by Marco Belladelli (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16400) Avoid reflection for calls to StackWalker

by Yoann Rodière (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16399) Add errorCode for ConstraintViolationException in SqlServerDialect

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTkxNjNjZWMw... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiMTkxNj... ) HHH-16399 ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiMTkxNj... ) Add errorCode for ConstraintViolationException in SqlServerDialect ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiMTkxNj... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In ORM, Sql Server throws an error that’s an instance of {{SQLIntegrityConstraintViolationException}}. In Hibernate Reactive, the error doesn’t extend any know instance known classes , so we need to check the error code to recognize it. ( https://hibernate.atlassian.net/browse/HHH-16399#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16399#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16399) Add errorCode for ConstraintViolationException in SqlServerDialect

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYWMzMDQ1MWM0... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiYWMzMD... ) HHH-16399 ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiYWMzMD... ) Add errorCode for ConstraintViolationException in SqlServerDialect ( https://hibernate.atlassian.net/browse/HHH-16399?atlOrigin=eyJpIjoiYWMzMD... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) In ORM, Sql Server throw throws an error that’s an instance of {{SQLIntegrityConstraintViolationException}}. In Hibernate Reactive, the error doesn’t extend any know instance, so we need to check the error code to recognize it. ( https://hibernate.atlassian.net/browse/HHH-16399#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16399#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16398) PropertyAccessException when lazy loading @OneToMany of polymorphic entity with same attribute mapped with different @Type in child subclass

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzA0OTBmMDY5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16398?atlOrigin=eyJpIjoiMzA0OT... ) HHH-16398 ( https://hibernate.atlassian.net/browse/HHH-16398?atlOrigin=eyJpIjoiMzA0OT... ) PropertyAccessException when lazy loading @OneToMany of polymorphic entity with same attribute mapped with different @Type in child subclass ( https://hibernate.atlassian.net/browse/HHH-16398?atlOrigin=eyJpIjoiMzA0OT... ) Change By: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * An EntityA with OneToMany mapping to an EntityB * EntityB has 2 subclasses which maps the same column to different types and uses @Type annotation When * Loading EntityA and lazy loading EntityB collection Then * PropertyAccessException {code:java}@Entity @Table(name = "ENTITY_A") public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @OneToMany(mappedBy = "entityA") List<AbstractEntityB> entities = new ArrayList<>(); }{code} {code:java}@Entity @Table(name = "ENTITY_B") @DiscriminatorColumn(name = "DISC_COL", discriminatorType = DiscriminatorType.INTEGER) public class AbstractEntityB { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @JoinColumn(name = "ENTITY_A") @ManyToOne EntityA entityA; }{code} {code:java}@Entity @DiscriminatorValue("1") public class EntityBChildOne extends AbstractEntityB { @Column(name = "ACTION") @Type(ChildOneActionUserType.class) private ChildOneAction action; public ChildOneAction getAction() { return action; } public void setAction(ChildOneAction action) { this.action = action; } public static enum ChildOneAction { ACTION_1, ACTION_2 } public static class ChildOneActionUserType extends AbstractUserType<ChildOneAction> { public ChildOneActionUserType() { super(ChildOneAction.class); } } }{code} {code:java}@Entity @DiscriminatorValue("2") public class EntityBChildTwo extends AbstractEntityB { @Column(name = "ACTION") @Type(ChildTwoActionUserType.class) private ChildTwoAction action; public ChildTwoAction getAction() { return action; } public void setAction(ChildTwoAction action) { this.action = action; } static enum ChildTwoAction { ACTION_10, ACTION_20 } public static class ChildTwoActionUserType extends AbstractUserType<ChildTwoAction> { public ChildTwoActionUserType() { super(ChildTwoAction.class); } } }{code} {code:java} @Test public void hhhXXXTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); EntityBChildOne childOne = new EntityBChildOne(); childOne.setAction(EntityBChildOne.ChildOneAction.ACTION_1); childOne.entityA = entityA1; entityA1.entities.add(childOne); EntityA entityA2 = new EntityA(); EntityBChildTwo childTwo = new EntityBChildTwo(); childTwo.setAction(EntityBChildTwo.ChildTwoAction.ACTION_20); childTwo.entityA = entityA2; entityA2.entities.add(childTwo); s.persist(entityA1); s.persist(childOne); s.persist(entityA2); s.persist(childTwo); tx.commit(); } try (Session s = openSession()) { s.getSessionFactory().getCache().evictAllRegions(); Query<EntityA> query = s.createQuery("select c from EntityA c", EntityA.class); List<EntityA> actual = query.list(); assertThat(actual).hasSize(2); assertThat(actual.get(0).entities).hasSize(1); assertThat(actual.get(1).entities).hasSize(1); } }{code} {noformat}bernate.PropertyAccessException: Could not set value of type [org.hibernate.bugs.EntityBChildOne$ChildOneAction] : `org.hibernate.bugs.EntityBChildTwo.action` (setter) at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:81) at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4176) at org.hibernate.sql.results.graph.entity.AbstractEntityInitializer.initializeEntityInstance(AbstractEntityInitializer.java:832) at org.hibernate.sql.results.graph.entity.AbstractEntityInitializer.initializeEntity(AbstractEntityInitializer.java:792) at org.hibernate.sql.results.graph.entity.AbstractEntityInitializer.initializeInstance(AbstractEntityInitializer.java:778) at org.hibernate.sql.results.internal.InitializersList.initializeInstance(InitializersList.java:69) at org.hibernate.sql.results.internal.StandardRowReader.coordinateInitializers(StandardRowReader.java:111) at org.hibernate.sql.results.internal.StandardRowReader.readRow(StandardRowReader.java:87) at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:179) at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:362) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168) at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93) at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) at org.hibernate.loader.ast.internal.CollectionLoaderSingleKey.load(CollectionLoaderSingleKey.java:117) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:702) at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:75) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1697) at org.hibernate.collection.spi.AbstractPersistentCollection.lambda$initialize$3(AbstractPersistentCollection.java:617) at org.hibernate.collection.spi.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:265) at org.hibernate.collection.spi.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:615) at org.hibernate.collection.spi.AbstractPersistentCollection.read(AbstractPersistentCollection.java:136) at org.hibernate.collection.spi.AbstractPersistentCollection.lambda$readSize$0(AbstractPersistentCollection.java:163) at org.hibernate.collection.spi.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:265) at org.hibernate.collection.spi.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:148) at org.hibernate.collection.spi.PersistentBag.size(PersistentBag.java:354) at org.assertj.core.util.IterableUtil.sizeOf(IterableUtil.java:50) at org.assertj.core.internal.Iterables.assertHasSize(Iterables.java:202) at org.assertj.core.api.AbstractIterableAssert.hasSize(AbstractIterableAssert.java:151) at org.hibernate.bugs.ORMUnitTestCase.hhhXXXTest(ORMUnitTestCase.java:91) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.lang.IllegalArgumentException: Can not set org.hibernate.bugs.EntityBChildTwo$ChildTwoAction field org.hibernate.bugs.EntityBChildTwo.action to org.hibernate.bugs.EntityBChildOne$ChildOneAction at java.base/jdk.internal.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167) at java.base/jdk.internal.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171) at java.base/jdk.internal.reflect.UnsafeObjectFieldAccessorImpl.set(UnsafeObjectFieldAccessorImpl.java:81) at java.base/java.lang.reflect.Field.set(Field.java:799) at org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:53) ... 45 more {noformat} Failing test scenario to be attached and also available here [https://github.com/ratoaq2/HHH-16398|https://github.com/ratoaq2/HHH-16398...] ( https://hibernate.atlassian.net/browse/HHH-16398#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16398#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#100219- sha1:6a6077b )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16398) PropertyAccessException when lazy loading @OneToMany of polymorphic entity with same attribute mapped with different @Type in child subclass

by Jones (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-16399) Add errorCode for ConstraintViolationException in SqlServerDialect

by Davide D'Alto (JIRA)

1 year, 1 month

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 March 2023