Hey,

I have a situation when there are 2 tables that are already exist and related to each other using one-to-many relation.
I want to merge them under the same class so when our programmers will work with the tables they could refer to them using one class and not 2 different classes.

For example, if I have these 2 tables under our system:

Table 1: Person_Private_Information

full_name
birthday

Table 2: Person_Public_Information

nickname
resume

I would like to create one class:



that will work in front of the tables as if it was only one table.

What is the best solution possible for this situation?

Can this solution be implemented using a View (so the class will work over the view instead of working in front of the tables)?

The database that we want to work under is Oracle 10g database.

Thank you,
Tal.

u can use <join> element - http://www.hibernate.org/hib_docs/v3/re ... ation-join

also u can use a view, but i doubt u can do any ddl operation or with limitation (save, update ...)