Hi,
I'm new to hibernate and I've run into a problem trying switch over an old project to use hibernate. In this project we have a table named 'Config' which consists of two varchar rows 'Parameter' and 'Value'. The table simply stores a key and a value for various configuration properties. The problem is that within the system the table is not mapped as a collection of Config items, but instead it is mapped explicitly to properties, eg:

In the Table we have:
-------------------------
(PK) Parameter | Value
-------------------------
key1 | valueOfKey1
key2 | valueOfKey2
...

And in the POJO we have:



The values for the Parameter column should never change. Is there anyway in Hibernate to map this?
I know a workaround whereby I map the rows as child elements inside a collection and then explicitly extract the values I need and assign them via the accessors, but I would rather avoid this if I have to in order to keep my data as dumb as possible.

Thanks in advance[/code]

Why cant you assemble the One object you want with all the variables from a DAO object, your DAO method may look like this:

Trust me to not to think about querying for the data! I got so wrapped up in 'having' to use mappings for everything I forgot that I could do more stuff in the DAO. Thanks, this solution would be ideal.

Why can't you have a Config class with a Collection of properties.



You could map this type of config. An entity with only a collection.

What would the map look like ? Can you have the collection and class in one table ?

That is the class containing the collection (class Config).
And the class which is the collection (class ConfigValues).

but now you have two classes and two tables, which is not how the data currently exists for this user.