All is in the question. How to map a Map with Hibernate using annotations ? And what's the associated database structure ?
Add a comment
|
1 Answer
You are probably looking for a generic key-value database structure where values can have multiple types. This is typically resolved by having some sort of abstract Value class with key attribute and several subclasses, each for every desired type:
Now you use:
Map<String, Value>
Of course this approach has many disadvantages, correctly choosing inheritance strategy being one of them (it depends on how many different types you want to store). But at least it is perfectly type-safe.
I don't have any experience with NHibernate, but with Hibernate (see: How do you map a "Map" in hibernate using annotations?) you can map Map directly.
answered Aug 10, 2011 at 8:00
Tomasz Nurkiewicz
342k72 gold badges713 silver badges680 bronze badges
3 Comments
Jerome Cance
It's what I was thinking of... In my case I would like to add new subclass easily (in fact without creating a new subclass with all hibernate annotations). Actually, to simulate this, I serialize in json the hashtable and save it in one big text field of my class... But this is not very clean ;) Thanks for your answer
Tomasz Nurkiewicz
Of course, you can even rely on Hibernate and simply serialize objects in BLOBs... But suggested approach actually allows you to query the values using SQL (at least primitives). If you need so flexible schema, maybe document oriented database (like MongoDB) would be a better tool?
Jerome Cance
This is just that part which need to be flexible, so using mongodb for only that can be overkill... But no matter, I think I will use the schema you propose.