Hibernate version: 1.2.1 GA
Name and version of the database you are using: MS SQL 2k(5)

I'm wondering if its possible to map a class from a lookup table. I have a table that has a number of system wide settings and options in it (CM_OPTION), and I'd like to be able to pull a number of them out to populate a class. Is there an easy way to do this?


I have a class say,

CM_OPTION contains the CompanyName and Address, where the SECTION_NAME is "CompanyDetails", and the OPTION_NAME and OPTION_VALUE are the property names and values I want to pull out.

I'm not expecting to be able to create a generic mapping for any class from the CM_OPTION table, however mapping the name / value pairs onto the properties just for the CompanyDetails class is hard enough! (unless I'm missing something!)

Thanks for any ideas
Phil

To answer your question:



No. This is orthogonal to the problem NH is designed to solve. Perhaps you could create a pivot view of the values in your table and map to that? Or if this is singleton, read-only info in your DB, you could map directly to the table, load it all once, and then do lookups to a hashtable in your app.