[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Approach for mappng a properties table

I am looking for advice on how to map a properties table. Assume a schema such as: Objects_Table ObjectID ObjectName ObjectType Properties_Table ObjectID PropertyID PropertyValue Assuming that for OID 12 there are 2 properties (NAME and Description) I would like to map a class which looks like ClassA - getName() - setName() - getDescription() - setDescription() I have looked at two approaches for this, and was curious if there was other: First: Map Objects_Table to ClassA, and give it a relatioship of Properties (@OneToMany). Then, hand craft the getters and setters to manage the properties. This works fine, but searching will be a bit sketchy to code. Second: Map both tables to ClassA using customer @Loader and @SqlInsert commands. These in turn are backed by heavily joined queries and/or stored procedures. This hides the underlieing tables (good) but requires lots of hand crafted SQL code. Are there other approaches to this? -- bk View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4219167#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...