Erwan Moutymbo (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c...
) *updated* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmU1OTFlODBj...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMmU1OT...
) HHH-16810 (
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMmU1OT...
) Fail to delete entity that contains an embedded with a many to many association as field
(
https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMmU1OT...
)
Change By: Erwan Moutymbo (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c...
)
h5. 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.
h3. Entities
{code:java}@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;
}
}{code}
{code:java}@Entity
@Table(name = "TAGS")
@EqualsAndHashCode
@NoArgsConstructor(access = PROTECTED)
@AllArgsConstructor
@Getter
public class Tag {
@Id
@Column(name = "TAG_NAME", nullable = false)
private String name;
}{code}
{code:java}public enum PolicyType {
ALL,
NONE
}{code}
h3. Tests
{ noformat code:java } @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();
}{ noformat code }
These tests raise an exception when the delete (or deleteAll) is committed.
{noformat}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)
...{noformat}
GitHub repository with sources :
[
https://github.com/emouty/hibernate-L2-cache-issue|https://github.com/emo...]
(
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 )