Hibernate NULL values of map not added (xml mapping)

Question

I mapped following map collection:

<map name="customFields" table="table_name" fetch="select">
    <key column="primary_id" />
    <map-key-many-to-many column="custom_id" class="CustomField" />
    <many-to-many column="other_id" class="AnotherClass" />
</map>

This works great; all records are added to the map if columns 'primary_id', 'custom_id' and 'other_id' are all filled with a value.

But when 'other_id' column is empty, that record is not added to the map. Is there a property or something I can force Hibernate to add these records to the Java Map as well?

Visualisation

+------------+-----------+----------+
| primary_id | custom_id | other_id | Added? 
+------------+-----------+----------+
|          1 |        53 | 124      | YES   
|          2 |        98 | 288      | YES   
|          3 |        18 | NULL     | NO    
+------------+-----------+----------+

Jacob van Lingen · Accepted Answer · 2016-02-24 09:49:04Z

1

After long searching documentations and such, I just found out that Hibernate does not support NULL values in a map:

answered Feb 24, 2016 at 9:49

Jacob van Lingen

9,6878 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Everton Maldonado · Accepted Answer · 2016-02-19 15:59:27Z

0

Try adding the not-null="false" in your mapping

<many-to-many column="other_id" not-null="false" class="AnotherClass" />

answered Feb 19, 2016 at 15:59

Everton Maldonado

11 bronze badge

1 Comment

Jacob van Lingen Over a year ago

I don't think a not-null attribute is allowed. If I add one, i stumble upon a Attribute "not-null" must be declared for element type "many-to-many" error!

Collectives™ on Stack Overflow

Hibernate NULL values of map not added (xml mapping)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related