Hello,

I got the following question.

I have a table A where I got an ID column and some more.
In another table B I got a FK column to A.

I can define relationships in hibernate as I want but I got stuck as I want to use filters.
I want to select objects from A but the filter criteria is in table B.
As it seems, the filter can only be defined for columns in an entity and can't follow a relationship.

So is it possible to define an entity AB where I got the columns from A
and some columns from B?

in SQL I would do it with a query on A and an inner join on B.


thanx
Vulpo

try using formula queries?????

Thanx for you help.

Well, formulas are used to compute something, I thought.

I thought more of this expression:




If I do this that way, hibernate tells me, that the secondary table "table_b" couldn't be found. This is NOT during runtime - it's during the initialization of hibernate.
I don't know how to tell hibernate how to join table_a and table_b.

Any ideas how to do this?

Thanx
Matthias

The following is missing, aleast at the code that you posted.



This works for me.

cheers
Projyal