Hi,

I have a requirement to map two tables by table name. Example:

First table:

Table name: CUSTOMER
Fields: CUSTOMER_ID etc. etc.
....

The second table has a unique structure:

Table name: METADATA
Fields: METADATA_ID
TABLE_NAME
MODIFIED
CONTENT etc. etc.

A row from METADATA might look like

21, 'CUSTOMER', 1/1/2008, 'this is content'

Can I do a mapping so that when I get a row from CUSTOMER I can fetch from METADATA too? Silly db design, I know, but it's what I've got to work with, any help appreciated.

Hibernate version: 3.2.6GA

Name and version of the database you are using: Oracle 10g

I don't believe there's a mechanism for grabbing the metadata.