Is it possible to map multiple rows to one object? Here's a sample table:
User_Preference_Value
-----------
user_id
pref_id
value
The combination of (user_id, pref_id) is not unique. A User can have multiple values for some preferences. I'd like to have a single UserPreference value whose compound key is (user_id, pref_id), with a collection of Strings for Value.
Is this possible?
I'd rather not have to create a User_Preference table with user_id/pref_id just to satisfy the mapping needs.
Use the @Basic annotation. It will serialize the Array/List with your values,
Regards
Felix
P.S.: I consider this bad design since you can't modify the data directly using sql.