Thanks in advance for your help. I am attempting to map data from multiple tables into a single class. Here is the table setup:

Table Foo
column a (pk)
column b

Table Bar
column a (pk)
column c (pk)
column d
column e

There is a one-to-many relationship between Foo and Bar. I have a class that stores values for a, b, and d. I would therefore like to perform the following query:

select a, b, d from Foo, Bar where a=? and e=?

Assume that e is unique. Can I set up a mapping and a corresponding query to do this? Thanks.

AFAIK you can not map multiple tables to one class, unless you are mapping an inheritance hierarchy, which from what you are describing you are not.

[quote="khooke"]AFAIK you can not map multiple tables to one class, unless you are mapping an inheritance hierarchy, which from what you are describing you are not.[/quote]

How about joining the tables and mapping the result to a Bean? Looks like the tables have been normalized and you want a denormalized view. Hmm there for you could also make a DB view (which just looks like a table) and map that to a bean.

Is this u needed?

select new FooBar(f.a,f.b,b.d)
from Foo as f inner join Bar as b on f.a=b.a
where f.a=? and b.e=?

Appropriate constructor - FooBar.java - FooBar(*,*,*)

Refr domnt[select new..]
------------------------------------------------------------------------

The SQL in the last post is indeed the kind of thing I'm looking for, but my question is how to configure a mapping for such a bean. The view idea is a good one, although I'm not sure if I have any control over the datasources. I was trying to isolate my solution to the .xml mapping. I looked at the <join> tag, but I'm under the impression that it accomodates only one-to-one relationships. Am I mistaken in this? Or is there a better way to map the join of tables in a one-to-many relationship? Am I making any sense at all? Is the weekend here yet?