HIbernate update with null on onetomany relation

Question

I have the following tables :

PRODUCT (id_product, name)
PROPERTY (id_property, name)
PRODUCT_PROPERTIES (id_product, id_property)

(all the fields are not nullable)

And the following hibernate mapping :

class Product {
    @Id
    private Integer id;

    @OneToMany(mappedBy="product")
    @Cascade({CascadeType.ALL})
    private Set<ProductProperties> productProperties = new HashSet<ProductProperties)(0);

    (...)    
}

When I update the product class by adding or removing rows from the "productProperties" field, the rows are updated correctly in the PRODUCT_PROPERTIES table.

The problem is that when "productProperties" is null or empty, Hibernate throws a ConstraintViolationException.

Since I need the "productProperties" to be empty sometimes, is there a proper solution to this problem (something like @ZeroToMany annotation) ?

What's the stack trace of the exception, and the code causing it to be thrown? How is the ProductProperties entity defined? — JB Nizet, Aug 10 '13 at 13:20
You have enable orphan deletion. Please refer http://stackoverflow.com/questions/306144/jpa-cascadetype-all-does-not-delete-orphans. — Dev Blanked, Aug 10 '13 at 14:23
@DevBlanked thanks for you answer, "orphanRemoval=true" does indeed the trick :) — Christos Loupassakis, Sep 19 '13 at 20:03

score 1 · Accepted Answer · answered Sep 19 '13 at 20:05

1

The answer is given by Dev Blanked in the comments. This is the solution :

@OneToMany(mappedBy="foo", orphanRemoval=true)

answered Sep 19 '13 at 20:05

Christos Loupassakis

1,112
3
15
23

HIbernate update with null on onetomany relation

1 Answers1