hi there,

i've read through the annotations and normal documentation, so forgive me if this is a silly question, but i couldn't find an answer.

basically, i have a user object that is working fine, what i'd like to do is add a Map<String, String> called profile to the user object.

is there any way (using annotations) to get hibernate to generate a table called 'user_profile' which has 3 columns, user, key, and value, and map these columns to the key/value pairs of the Map<String, String>? it would be a one-to-many mapping, because a user can have an arbitrary number of profile settings defined, but there is a constraint that a user can only have 1 profile setting for a given key (which is worked out nicely by the map)

any ideas?

thanks in advance

this solution works for me!