Erwan Moutymbo (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTM0OTQ5Yzgx...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiZTM0OT...
) HHH-16810 (
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiZTM0OT...
) Fail to delete all enti (
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiZTM0OT...
)
Issue Type: Bug Affects Versions: 6.2.0, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5 Assignee:
Unassigned Components: hibernate-core Created: 16/Jun/2023 09:10 AM Environment:
Hibernate: tried 6.2.0.Final to 6.2.5.Final
initially found with Postgresql: 14.5
reproduced with h2 2.1.214
Spring Data JPA: 3.0.6
Spring Boot: 3.0.7
ehcache 3.10.8
JDK: OpenJDK 64-Bit Server VM Temurin-17.0.6
OS: Fedora 38 Priority: Major Reporter: Erwan Moutymbo (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c...
)
Description
I'm migrating from hibernate 5.6.15 to hibernate 6.2.5 and I have noticed some issues
when I try to delete an entity that contains an embedded which contain itself a field
describing a many to many association.
Entities
--------
@Getter
@Entity
@ToString(onlyExplicitlyIncluded = true )
@EqualsAndHashCode(onlyExplicitlyIncluded = true )
@NoArgsConstructor(access = PROTECTED)
@Table(name = "OPERATORS" )
@OptimisticLocking(type = OptimisticLockType.DIRTY)
@DynamicUpdate
@Cacheable
@Cache(usage = READ_WRITE)
public class Operator {
public Operator( String operatorId) {
this.operatorId = operatorId;
this.tagPolicy = new OperatorTagPolicy(Set.of(), ALL);
}
@EqualsAndHashCode.Include
@ToString.Include
@Id
@Column(name = "OPERATOR_ID" , nullable = false )
private String operatorId;
@Embedded
private OperatorTagPolicy tagPolicy;
@OneToMany(mappedBy = " operator " , cascade = {CascadeType.ALL},
orphanRemoval = true , fetch = FetchType.LAZY)
private List<Product> products = new ArrayList<>();
public void setProducts(List<Product> products) {
this.products = products;
}
@Value
@AllArgsConstructor
@NoArgsConstructor(access = PROTECTED)
@Embeddable
public static class OperatorTagPolicy {
@NonFinal
@ManyToMany(fetch = LAZY)
@JoinTable(
name = "OPERATOR_TO_TAG" ,
joinColumns = {
@JoinColumn(name = "OPERATOR_ID" , referencedColumnName =
"OPERATOR_ID" )
},
inverseJoinColumns = @JoinColumn(name = "TAG_NAME" ))
@Cache(usage = READ_WRITE)
Set<Tag> exceptions;
@NonFinal
@Column(name = "TAG_POLICY_TYPE" , nullable = false )
@Enumerated(EnumType.STRING)
PolicyType type;
}
}
@Entity
@Table(name = "TAGS" )
@EqualsAndHashCode
@NoArgsConstructor(access = PROTECTED)
@AllArgsConstructor
@Getter
public class Tag {
@Id
@Column(name = "TAG_NAME" , nullable = false )
private String name;
}
public enum PolicyType {
ALL,
NONE
}
Tests
-----
@Test
@Order(2)
void shouldDeleteOperator() {
String string = "ID2";
String operatorID = "operatorID2";
String test = "test";
Operator operator = new Operator(operatorID);
operatorDao.save(operator);
Product product = new Product(string, operator);
product.setDescription(test);
productService.addProduct(product);
operatorService.deleteOperator(operatorID);
Optional<Operator> byId2 = operatorService.getOperator(operatorID);
assertThat(byId2).isEmpty();
}
@Test
@Order(3)
void shouldDeleteAllOperators() {
String string = "ID3";
String operatorID = "operatorID3";
String test = "test";
Operator operator = new Operator(operatorID);
operatorDao.save(operator);
Product product = new Product(string, operator);
product.setDescription(test);
productService.addProduct(product);
operatorService.deleteAllOperators();
Optional<Operator> byId2 = operatorService.getOperator(operatorID);
assertThat(byId2).isEmpty();
}
These tests raise an exception when the delete (or deleteAll) is committed.
org.springframework.transaction.TransactionSystemException: Could not commit JPA
transaction
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:570)
...
Caused by: jakarta.persistence.RollbackException: Error while committing the transaction
...
Caused by: java.lang.UnsupportedOperationException
at
org.hibernate.metamodel.mapping.internal.PluralAttributeMappingImpl.breakDownJdbcValues(PluralAttributeMappingImpl.java:975)
at
org.hibernate.metamodel.mapping.internal.EmbeddableMappingTypeImpl.breakDownJdbcValues(EmbeddableMappingTypeImpl.java:655)
...
GitHub repository with sources :
https://github.com/emouty/hibernate-L2-cache-issue
(
https://hibernate.atlassian.net/browse/HHH-16810#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-16810#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=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100227- sha1:5147d46 )