Hi, everyone. I am new to hibernate, so my question may be stupid.
Anyway, I am on a project which using hibernate, and I need to do some kinda column mapping.

Here is an example, let's say I have 2 tables T1, and T2, each of which has 3 columns, all named x1, x2, x3. Then I have a java class JClass with 2 private variables: id and value. I want to map JClass to both T1 and T2.

When I ask hibernate to return a row of T1, a collection of JClass instantces will be returned. Each instance's id is column name and value is the value of that column for a specific row.

Can hibernate do that? If it can, would someone give me the mapping xml file based on above example?

Thank you very much and have a nice day.














Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Well, firstly we do not ask H to return row from TableX as object, we as H to get object of a given type with the given identity. See the difference? When dealing with H it helps to think in terms of objects rather than tables, rows and columns.

iBatis ( http://ibatis.apache.org/ ) is the tool that supports your way of thinking: bring me row from table Z as object JClass, or bring me row from table Y as object of JClass.

That was a long way to say no, H does not allow the thing you have asked for.

Maybe this is called "map properties of one class to several tables"
Can the value variable of JClass be mapped to all 6 columns?

Look at <join> mapping in the H3 docs if you want to map all 6 columns to a single Object.

well, I just tried <join>.
First, it looks like <join> requires <key> which defines foreign key in the joined table.

Second, H throws this exception: "duplicate property mapping: value"

does this mean that a single instance variable cant be mapped to multiple columns?