March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16350) PreLoadEvent listeners might receive PreLoadEvent with null state

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDFkZGI2NGM5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDFkZG... ) HHH-16350 ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDFkZG... ) PreLoadEvent listeners might receive PreLoadEvent with null state ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDFkZG... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Created: 22/Mar/2023 03:55 AM Priority: Major Reporter: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) PreLoadEvent listeners might receive events with null state, which never happened in hibernate 5 @Entity @Table(name = "ENTITY_A" ) public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID" ) Integer id; } public class MyPreLoadEventListener implements PreLoadEventListener { @Override public void onPreLoad(PreLoadEvent event) { assertThat(event.getState()).isNotNull(); } } @Test public void foobarTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); s.persist(entityA1); tx.commit(); } try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select e from org.hibernate.bugs.EntityA e" ; Query<EntityA> query = s.createQuery(hql, EntityA.class); List<EntityA> actual = query.list(); assertThat(actual).hasSize(1); tx.rollback(); } } Test case to be attached ( https://hibernate.atlassian.net/browse/HHH-16350#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16350#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:eb3f1fe )

3 years

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiN2IwND... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiN2IwND... ) I think the problem lies in the problem lies hier: https://github.com/hibernate/hibernate-orm/blob/6.1/hibernate-core/src/ma... ( https://github.com/hibernate/hibernate-orm/blob/6.1/hibernate-core/src/ma... ) When Entity2 gets loaded the fields of Entity1 are already loaded and are not considered to be part of Entity2. In https://github.com/hibernate/hibernate-orm/blob/6.1/hibernate-core/src/ma... ( https://github.com/hibernate/hibernate-orm/blob/6.1/hibernate-core/src/ma... ) are the mappings of Entity1 returned and only the setters of Entity1 are called. That ignores the child class (Entity2) totally. I wonder what the differences are between Overriding Properties and just declaring them ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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:eb3f1fe )

3 years

1
0
0 / 0

[JIRA] (HHH-16349) ORA-00979 not a group by expression when using a polymorphic entity in HQL group by

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=eyJpIjoiYmE5MzkxNGIw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiYmE5Mz... ) HHH-16349 ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiYmE5Mz... ) ORA-00979 not a group by expression when using a polymorphic entity in HQL group by ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiYmE5Mz... ) Change By: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * Polymorphic entities When * HQL with a group by using a polymorphic entity Then * An exception in oracle occurs {{ORA-00979 not a group by expression}} {code:java}@Entity @Table(name = "MY_TABLE") public class MyEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") private Integer id; @Column(name = "amount") private Integer amount; @JoinColumn(name = "REL_ENTITY", foreignKey = @ForeignKey(name = "FK_REL_ENT_01")) @ManyToOne @Fetch(FetchMode.SELECT) private RelatedEntity relatedEntity; }{code} {code:java}@Entity @Table(name = "MY_TABLE") @DiscriminatorColumn(name = "DISC_COL", discriminatorType = DiscriminatorType.INTEGER) @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) public abstract class RelatedEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @Column(name = "RELATED_VALUE") Integer value; }{code} {code:java}@Entity @DiscriminatorValue("1") public class ChildOneEntity extends RelatedEntity { @Column(name = "ONLY_CHILD_ONE") private Integer onlyChildOne; }{code} {code:java}@Entity @DiscriminatorValue("2") public class ChildTwoEntity extends RelatedEntity { @Column(name = "ONLY_CHILD_TWO") private Integer onlyChildTwo; }{code} {code:java}public class MyPojo { Integer amount; RelatedEntity relatedEntity; public MyPojo(Integer amount, RelatedEntity relatedEntity) { this.amount = amount; this.relatedEntity = relatedEntity; } }{code} {code:java} @Test public void failingTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select new org.hibernate.bugs.MyPojo (sum(e.amount), re ) from org.hibernate.bugs.MyEntity e join e.relatedEntity re where 1=1 group by re"; Query<MyPojo> query = s.createQuery(hql, MyPojo.class); List<MyPojo> actual = query.list(); assertThat(actual).isEmpty(); // Verify the generated SQL // In oracle we get ORA-00979 not a group by expression tx.commit(); } }{code} {code:java}Hibernate: select sum(m1_0.amount), r1_0.ID, r1_0.DISC_COL, r1_0.RELATED_VALUE, r1_0.ONLY_CHILD_ONE, r1_0.ONLY_CHILD_TWO from MY_TABLE m1_0 join MY_TABLE r1_0 on r1_0.ID=m1_0.REL_ENTITY where 1=1 group by r1_0.ID, r1_0.DISC_COL, r1_0.RELATED_VALUE{code} The generated group by does not include the {{r1_0.ONLY_CHILD_ONE}} and {{r1_0.ONLY_CHILD_TWO}} which leads to ORA-00979 in oracle Test case to be attached and also available here [https://github.com/ratoaq2/HHH-16349|https://github.com/ratoaq2/HHH-16349...] ( https://hibernate.atlassian.net/browse/HHH-16349#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16349#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:eb3f1fe )

3 years

1
0
0 / 0

[JIRA] (HHH-16349) ORA-00979 not a group by expression when using a polymorphic entity in HQL group by

by Jones (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16349) ORA-00979 not a group by expression when using a polymorphic entity in HQL group by

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDY4OGUxZjgw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiZDY4OG... ) HHH-16349 ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiZDY4OG... ) ORA-00979 not a group by expression when using a polymorphic entity in HQL group by ( https://hibernate.atlassian.net/browse/HHH-16349?atlOrigin=eyJpIjoiZDY4OG... ) Issue Type: Bug Affects Versions: 6.2.0.CR3, 6.2.0.CR4 Assignee: Unassigned Created: 22/Mar/2023 03:26 AM Priority: Major Reporter: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * Polymorphic entities When * HQL with a group by using a polymorphic entity Then * An exception in oracle occurs ORA-00979 not a group by expression @Entity @Table(name = "MY_TABLE" ) public class MyEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID" ) private Integer id; @Column(name = "amount" ) private Integer amount; @JoinColumn(name = "REL_ENTITY" , foreignKey = @ForeignKey(name = "FK_REL_ENT_01" )) @ManyToOne @Fetch(FetchMode.SELECT) private RelatedEntity relatedEntity; } @Entity @Table(name = "MY_TABLE" ) @DiscriminatorColumn(name = "DISC_COL" , discriminatorType = DiscriminatorType.INTEGER) @Cache(usage = CacheConcurrencyStrategy.READ_WRITE) public abstract class RelatedEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID" ) Integer id; @Column(name = "RELATED_VALUE" ) Integer value; } @Entity @DiscriminatorValue( "1" ) public class ChildOneEntity extends RelatedEntity { @Column(name = "ONLY_CHILD_ONE" ) private Integer onlyChildOne; } @Entity @DiscriminatorValue( "2" ) public class ChildTwoEntity extends RelatedEntity { @Column(name = "ONLY_CHILD_TWO" ) private Integer onlyChildTwo; } public class MyPojo { Integer amount; RelatedEntity relatedEntity; public MyPojo( Integer amount, RelatedEntity relatedEntity) { this.amount = amount; this.relatedEntity = relatedEntity; } } @Test public void failingTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select new org.hibernate.bugs.MyPojo (sum(e.amount), re ) from org.hibernate.bugs.MyEntity e join e.relatedEntity re where 1=1 group by re" ; Query<MyPojo> query = s.createQuery(hql, MyPojo.class); List<MyPojo> actual = query.list(); assertThat(actual).isEmpty(); // Verify the generated SQL // In oracle we get ORA-00979 not a group by expression tx.commit(); } } Hibernate: select sum(m1_0.amount), r1_0.ID, r1_0.DISC_COL, r1_0.RELATED_VALUE, r1_0.ONLY_CHILD_ONE, r1_0.ONLY_CHILD_TWO from MY_TABLE m1_0 join MY_TABLE r1_0 on r1_0.ID=m1_0.REL_ENTITY where 1=1 group by r1_0.ID, r1_0.DISC_COL, r1_0.RELATED_VALUE The generated group by does not include the r1_0.ONLY_CHILD_ONE and r1_0.ONLY_CHILD_TWO which leads to ORA-00979 in oracle Test case to be attached ( https://hibernate.atlassian.net/browse/HHH-16349#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16349#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:eb3f1fe )

3 years

1
0
0 / 0

[JIRA] (HHH-16285) Property of on-execution generated embeddable is not generated

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16285) Property of on-execution generated embeddable is not generated

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16285 ( https://hibernate.atlassian.net/browse/HHH-16285?atlOrigin=eyJpIjoiNDE4Yj... ) Re: Property of on-execution generated embeddable is not generated ( https://hibernate.atlassian.net/browse/HHH-16285?atlOrigin=eyJpIjoiNDE4Yj... ) Thanks Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) , I’ll close this issue then and we’re gonna let you know about the new one. ( https://hibernate.atlassian.net/browse/HHH-16285#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16285#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:eb3f1fe )

3 years

1
0
0 / 0

[JIRA] (HHH-16248) Problem with batching and inheritance with @ManyToOne mapped in multiple subclasses

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16305) A problem occurred in the SQL executor : JDBC parameter value not bound

by Marco Belladelli (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-15160) Extend Postgis support to distance operators

by Johannes Ebster (JIRA)

Johannes Ebster ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f5f440... ) *commented* on HHH-15160 ( https://hibernate.atlassian.net/browse/HHH-15160?atlOrigin=eyJpIjoiMjNkNT... ) Re: Extend Postgis support to distance operators ( https://hibernate.atlassian.net/browse/HHH-15160?atlOrigin=eyJpIjoiMjNkNT... ) @Karel Maesen Any update here? Would still love to see this feature. ( https://hibernate.atlassian.net/browse/HHH-15160#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15160#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:eb3f1fe )

3 years

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