August 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-17031) HQL - DELETE does not delete child entity.

by Satish (JIRA)

Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) *commented* on HHH-17031 ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiNDk2Yj... ) Re: HQL - DELETE does not delete child entity. ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiNDk2Yj... ) package com.example; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.Table; import java.io.Serializable; @Entity @Table(name = "TEST_CHILD_TABLE", schema = "CRISOP") public class ChildEntity implements Serializable { private Integer id; private String name; @Id @Column(name = "ID") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @Column(name = "NAME") public String getName() { return name; } public void setName(String name) { this.name = name; } } ( https://hibernate.atlassian.net/browse/HHH-17031#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17031#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-17031) HQL - DELETE does not delete child entity.

by Satish (JIRA)

Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) *commented* on HHH-17031 ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiN2U2MD... ) Re: HQL - DELETE does not delete child entity. ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiN2U2MD... ) package com.example; import jakarta.persistence.*; import java.io.Serializable; import org.hibernate.annotations.NotFound; import org.hibernate.annotations.NotFoundAction; @Entity @Table(name = "TEST_PARENT_TABLE", schema = "TEST") public class ParentEntity implements Serializable { private Integer id; private String name; private ChildEntity childEntity; @Id @Column(name = "ID") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.EAGER, orphanRemoval = true) @PrimaryKeyJoinColumn(name = "ID") @NotFound(action = NotFoundAction.IGNORE) public ChildEntity getChildEntity() { return childEntity; } public void setChildEntity(ChildEntity childEntity) { this.childEntity = childEntity; } } ( https://hibernate.atlassian.net/browse/HHH-17031#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17031#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-17031) HQL - DELETE does not delete child entity.

by Satish (JIRA)

Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmFhNDVkZWE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiYmFhND... ) HHH-17031 ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiYmFhND... ) HQL - DELETE does not delete child entity. ( https://hibernate.atlassian.net/browse/HHH-17031?atlOrigin=eyJpIjoiYmFhND... ) Issue Type: Bug Affects Versions: 6.2.7 Assignee: Unassigned Components: hibernate-entitymanager, hibernate-orm-modules, query-hql Created: 03/Aug/2023 13:36 PM Priority: Major Reporter: Satish ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f990cf... ) When using HQL to DELETE a parent entity, the delete is not cascaded to child entity. Here is a snippet of code that has the issues, detailed test case is below. transaction.begin(); // Use HQL to delete the parent. With CASCADE.ALL, the child should be deleted. Query query = em.createQuery("DELETE FROM ParentEntity WHERE id = :parentId"); query.setParameter("parentId", parentId); query.executeUpdate(); transaction.commit(); -- Database tables. create table TEST.TEST_PARENT_TABLE ( ID INTEGER not null primary key, NAME VARCHAR(256) ); create table TEST.TEST_CHILD_TABLE ( ID INTEGER not null primary key, NAME VARCHAR(256) ); ( https://hibernate.atlassian.net/browse/HHH-17031#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17031#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-16737) Interpretation of numeric literals without explicit type suffix

by Christian Beikov (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-17012) Using CriteriaBuilder not method mutates original predicate in SQL

by Andrea Boriero (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16879) Inconsistent @Parent behavior if cache is enabled

by Marco Belladelli (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16919) Bidirectional mapping with @Any causes infinite loop on fetch

by Marco Belladelli (JIRA)

11 months

1
0
0 / 0

[JIRA] (HHH-16919) Bidirectional mapping with @Any causes infinite loop on fetch

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16919 ( https://hibernate.atlassian.net/browse/HHH-16919?atlOrigin=eyJpIjoiMTc3Nm... ) Re: Bidirectional mapping with @Any causes infinite loop on fetch ( https://hibernate.atlassian.net/browse/HHH-16919?atlOrigin=eyJpIjoiMTc3Nm... ) Hello Kaushal Niraula ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , I’m starting to investigate the problem. From early testing, looks like Hibernate can’t detect the circularity when loading the @Any association since all loads are EAGER , triggering an infinite loop between the PropertyHolder and its Property backref. A valid workaround, for the moment, would be setting the association as LAZY , i.e. something like: @Any(fetch = FetchType.LAZY) @AnyKeyJavaClass( Long.class) @AnyDiscriminator(DiscriminatorType.STRING) @AnyDiscriminatorValues({ @AnyDiscriminatorValue(discriminator = "I" , entity = IntegerProperty.class), @AnyDiscriminatorValue(discriminator = "S" , entity = StringProperty.class) }) @Column(name = "property_type" , insertable = false , updatable = false ) @JoinColumn(name = "idtemp" , updatable = false , insertable = false ) @Cascade(CascadeType.ALL) private Property property; This way the load works correctly. Note that the LAZY association could be the @OneToOne side, but in that case you would need to specify that on all entities implementing Property. ( https://hibernate.atlassian.net/browse/HHH-16919#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16919#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-16986) CoercionException caused by attempted coercion of query param to entity field type

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16986 ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiNjQyMW... ) Re: CoercionException caused by attempted coercion of query param to entity field type ( https://hibernate.atlassian.net/browse/HHH-16986?atlOrigin=eyJpIjoiNjQyMW... ) Just a quick idea, how about we always resolve to BigDecimal for parameters in arithmetic expressions when * no type inference info is available * other operands have exact types (i.e. no Float , Double ) If other operands are of the types Float or Double , then we resolve to Double. I think this could work because thanks to coercion, we can coerce all numbers to BigDecimal. One effect of that would simply be that the result type of queries like select 1 * ?1 will be BigDecimal. ( https://hibernate.atlassian.net/browse/HHH-16986#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16986#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#100233- sha1:3ea1a2a )

11 months

1
0
0 / 0

[JIRA] (HHH-17028) Unrelated left join fails when query has multiple roots

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17028 ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiMjk1MW... ) Re: Unrelated left join fails when query has multiple roots ( https://hibernate.atlassian.net/browse/HHH-17028?atlOrigin=eyJpIjoiMjk1MW... ) ORM 5 was simply not capable to validate this correctly and it only worked by accident. ( https://hibernate.atlassian.net/browse/HHH-17028#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17028#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#100233- sha1:3ea1a2a )

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