June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16810) Fail to delete entity that contains an embedded with a many to many association as field

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGE2NjUwNzVk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMGE2Nj... ) HHH-16810 ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMGE2Nj... ) Fail to delete entity that contains an embedded with a many to many association as field ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiMGE2Nj... ) 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 = "TAG_OPERATORS") @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @org.hibernate.annotations.Cache(usage = READ_WRITE) public class TagOperator { public TagOperator(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; @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")) @org.hibernate.annotations.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. Test {code:java} @Test void shouldDeleteTagOperator() { String operatorID = "tagOperatorID"; TagOperator operator = new TagOperator(operatorID); tagOperatorService.addTagOperator(operator); tagOperatorService.deleteTagOperator(operatorID); Optional<TagOperator> byId2 = tagOperatorService.getTagOperator(operatorID); assertThat(byId2).isEmpty(); }{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} h3. Be aware that the right attachment archive is the latest uploaded (I cannot delete attachment that were already uploaded). GitHub repository with sources : [https://github.com/emouty/hibernate- L2-cache-issue issues |https://github.com/emouty/hibernate- L2-cache-issue issues |smart-link] ( 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4867) Support AWS OpenSearch Serverless

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4867 ( https://hibernate.atlassian.net/browse/HSEARCH-4867?atlOrigin=eyJpIjoiYjk... ) Re: Support AWS OpenSearch Serverless ( https://hibernate.atlassian.net/browse/HSEARCH-4867?atlOrigin=eyJpIjoiYjk... ) Okay, I’m sorry but I’m going to have to pull the plug on this experiment. Just letting an Amazon OpenSearch Serverless collection run *without even using it* cost us $46.66 for search + $14.00 for indexing *per day*. This is not sustainable. Before we make another attempt, we will have to come up with something to reduce the costs, because without testing we can’t be sure it works, and we can’t afford to spend such a budget on testing (much higher budget than every other platform combined!). ( https://hibernate.atlassian.net/browse/HSEARCH-4867#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4867#add-comment?atlOrigin... ) 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#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjkxZTFjOTgy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiNjkxZT... ) HHH-16821 ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiNjkxZT... ) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiNjkxZT... ) Change By: Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) h3. 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 have a compositeId with one of its id field part of a @ManyToOne association. h3. Entities {code:java}@Getter @IdClass(ProductPK.class) @EqualsAndHashCode(onlyExplicitlyIncluded = true) @ToString(onlyExplicitlyIncluded = true) @NoArgsConstructor(access = PROTECTED) @Entity @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) @Table(name = "PRODUCTS") public class Product { public Product(String productId, Operator operator) { this.productId = productId; this.operator = operator; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "PRODUCT_ID", nullable = false) private String productId; @Id @EqualsAndHashCode.Include @ToString.Include @Getter @Setter @Cache(usage = READ_WRITE) @ManyToOne(fetch = LAZY, optional = false) @JoinColumn(nullable = false) private Operator operator; @Column(name = "DESCRIPTION") @Setter private String description; @AllArgsConstructor @EqualsAndHashCode @ToString @NoArgsConstructor(access = PUBLIC) public static class ProductPK implements Serializable { private String productId; private String operator; } } {code} {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; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "OPERATOR_ID", nullable = false) private String operatorId; @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; } }{code} h3. Test {code:java} @Test void shouldDeleteProduct() { // Given String string = "ID2"; String operatorID = "operatorID2"; String test = "test"; Operator operator = new Operator(operatorID); operatorService.addOperator(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // When ProductPK productPK = new ProductPK(string, operatorID); productService.deleteProduct(productPK); // Then Optional<Product> byId2 = productService.getProduct(productPK); assertThat(byId2).isEmpty(); }{code} I get the following exception : {noformat}org.springframework.orm.ObjectOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from products where operator_operator_id=? and product_id=? and operator_operator_id is null and product_id is null and description=? at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:307) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:232){noformat} GitHub repository with sources : [https://github.com/emouty/hibernate-L2-cache-issue|https://github.com/emo...] ( https://hibernate.atlassian.net/browse/HHH-16821#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16821#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#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDIxNjg3NjMx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiMDIxNj... ) HHH-16821 ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiMDIxNj... ) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiMDIxNj... ) Change By: Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) h3. 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 have a compositeId with one of its id field part of a @ManyToOne association. h3. Entities {code:java}@Getter @IdClass(ProductPK.class) @EqualsAndHashCode(onlyExplicitlyIncluded = true) @ToString(onlyExplicitlyIncluded = true) @NoArgsConstructor(access = PROTECTED) @Entity @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) @Table(name = "PRODUCTS") public class Product { public Product(String productId, Operator operator) { this.productId = productId; this.operator = operator; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "PRODUCT_ID", nullable = false) private String productId; @Id @EqualsAndHashCode.Include @ToString.Include @Getter @Setter @Cache(usage = READ_WRITE) @ManyToOne(fetch = LAZY, optional = false) @JoinColumn(nullable = false) private Operator operator; @Column(name = "DESCRIPTION") @Setter private String description; @AllArgsConstructor @EqualsAndHashCode @ToString @NoArgsConstructor(access = PUBLIC) public static class ProductPK implements Serializable { private String productId; private String operator; } } {code} {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; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "OPERATOR_ID", nullable = false) private String operatorId; @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; } }{code} h3. Test { noformat code:java } @Test void shouldDeleteProduct() { // Given String string = "ID2"; String operatorID = "operatorID2"; String test = "test"; Operator operator = new Operator(operatorID); operatorService.addOperator(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // When ProductPK productPK = new ProductPK(string, operatorID); productService.deleteProduct(productPK); // Then Optional<Product> byId2 = productService.getProduct(productPK); assertThat(byId2).isEmpty(); }{ noformat code } I get the following exception : {noformat}org.springframework.orm.ObjectOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from products where operator_operator_id=? and product_id=? and operator_operator_id is null and product_id is null and description=? at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:307) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:232){noformat} ( https://hibernate.atlassian.net/browse/HHH-16821#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16821#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#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZWIyZDQ4NWQ2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiZWIyZD... ) HHH-16821 ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiZWIyZD... ) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiZWIyZD... ) Change By: Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) h3. 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 have a compositeId with one of its id field part of a @ManyToOne association. h3. Entities {code:java}@Getter @IdClass(ProductPK.class) @EqualsAndHashCode(onlyExplicitlyIncluded = true) @ToString(onlyExplicitlyIncluded = true) @NoArgsConstructor(access = PROTECTED) @Entity @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) @Table(name = "PRODUCTS") public class Product { public Product(String productId, Operator operator) { this.productId = productId; this.operator = operator; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "PRODUCT_ID", nullable = false) private String productId; @Id @EqualsAndHashCode.Include @ToString.Include @Getter @Setter @Cache(usage = READ_WRITE) @ManyToOne(fetch = LAZY, optional = false) @JoinColumn(nullable = false) private Operator operator; @Column(name = "DESCRIPTION") @Setter private String description; @AllArgsConstructor @EqualsAndHashCode @ToString @NoArgsConstructor(access = PUBLIC) public static class ProductPK implements Serializable { private String productId; private String operator; } } {code} {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; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "OPERATOR_ID", nullable = false) private String operatorId; @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; } }{code} h3. Test {noformat} @Test void shouldDeleteProduct() { // Given String string = "ID2"; String operatorID = "operatorID2"; String test = "test"; Operator operator = new Operator(operatorID); operatorService.addOperator(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // When ProductPK productPK = new ProductPK(string, operatorID); productService.deleteProduct(productPK); // Then Optional<Product> byId2 = productService.getProduct(productPK); assertThat(byId2).isEmpty(); }{noformat} I get the following exception : {noformat}org.springframework.orm.ObjectOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from products where operator_operator_id=? and product_id=? and operator_operator_id is null and product_id is null and description=? at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:307) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:232){noformat} ( https://hibernate.atlassian.net/browse/HHH-16821#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16821#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#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using an @IdClass with one of its fields mapped from the id of a @ManyToOne association

by Erwan Moutymbo (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using an `@IdClass` with one of its fields mapped from the id of a `@ManyToOne` association`

by Erwan Moutymbo (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16821) Fail to delete enty with a composite id using (an `@IdClass`) with one of its fields mapped from the id of a `@ManyToOne` association`

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTQxZmQxMmFh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiYTQxZm... ) HHH-16821 ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiYTQxZm... ) Fail to delete enty with a composite id using (an `@IdClass`) with one of its fields mapped from the id of a `@ManyToOne` association` ( https://hibernate.atlassian.net/browse/HHH-16821?atlOrigin=eyJpIjoiYTQxZm... ) Issue Type: Bug Affects Versions: 6.2.2, 6.2.3, 6.2.4, 6.2.5 Assignee: Unassigned Components: hibernate-core Created: 19/Jun/2023 05:17 AM Environment: Hibernate: tried 6.2.2.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 have a compositeId with one of its id field part of a @ManyToOne association. Entities -------- @Getter @IdClass(ProductPK.class) @EqualsAndHashCode(onlyExplicitlyIncluded = true ) @ToString(onlyExplicitlyIncluded = true ) @NoArgsConstructor(access = PROTECTED) @Entity @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) @Table(name = "PRODUCTS" ) public class Product { public Product( String productId, Operator operator ) { this.productId = productId; this. operator = operator ; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "PRODUCT_ID" , nullable = false ) private String productId; @Id @EqualsAndHashCode.Include @ToString.Include @Getter @Setter @Cache(usage = READ_WRITE) @ManyToOne(fetch = LAZY, optional = false ) @JoinColumn(nullable = false ) private Operator operator ; @Column(name = "DESCRIPTION" ) @Setter private String description; @AllArgsConstructor @EqualsAndHashCode @ToString @NoArgsConstructor(access = PUBLIC) public static class ProductPK implements Serializable { private String productId; private String operator ; } } @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; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "OPERATOR_ID" , nullable = false ) private String operatorId; @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; } } Test ---- @Test void shouldDeleteProduct() { // Given String string = "ID2"; String operatorID = "operatorID2"; String test = "test"; Operator operator = new Operator(operatorID); operatorService.addOperator(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // When ProductPK productPK = new ProductPK(string, operatorID); productService.deleteProduct(productPK); // Then Optional<Product> byId2 = productService.getProduct(productPK); assertThat(byId2).isEmpty(); } I get the following exception : org.springframework.orm.ObjectOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from products where operator_operator_id=? and product_id=? and operator_operator_id is null and product_id is null and description=? at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:307) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:232) ( https://hibernate.atlassian.net/browse/HHH-16821#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16821#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#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16810) Fail to delete entity that contains an embedded with a many to many association as field

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmFkYjE5NDll... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiYmFkYj... ) HHH-16810 ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiYmFkYj... ) Fail to delete entity that contains an embedded with a many to many association as field ( https://hibernate.atlassian.net/browse/HHH-16810?atlOrigin=eyJpIjoiYmFkYj... ) 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 = "TAG_OPERATORS") @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @org.hibernate.annotations.Cache(usage = READ_WRITE) public class TagOperator { public TagOperator(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; @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")) @org.hibernate.annotations.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. Test {code:java} @Test void shouldDeleteTagOperator() { String operatorID = "tagOperatorID"; TagOperator operator = new TagOperator(operatorID); tagOperatorService.addTagOperator(operator); tagOperatorService.deleteTagOperator(operatorID); Optional<TagOperator> byId2 = tagOperatorService.getTagOperator(operatorID); assertThat(byId2).isEmpty(); }{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} h3. Be aware that the right attachment archive is the latest uploaded (I cannot delete attachment that were already uploaded). 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100227- sha1:8ffa416 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16810) Fail to delete entity that contains an embedded with a many to many association as field

by Erwan Moutymbo (JIRA)

1 year, 3 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 June 2023