Help on associations

Axen · **Joined:** Fri Dec 12, 2003 7:38 am **Posts:** 5

Hi,

I've got the following data model

Train<------------->* train_rame *<--------------->rame

where tables look like that

train
---------
- cpt_train
-label_train

rame
-------
- cpt_rame
power

train_rame
-------------
- cpt_train
- cpt_rame

Could you post an example using HQL and another using criteria queries similar to the following sql query:

Code:

SELECT * FROM train , train_rame , rame where train.cpt_train = train_rame.cpt_train AND train_rame.cpt_rame = rame.cpt_rame AND rame.power > 10 and train.labeltrain = 'test';

Thanks ;)
Axen

emmanuel · **Posted:** Fri Dec 12, 2003 8:45 am

Would say the proper answer is RTFM. But it's almost Chrismas.

Code:

select train from Train as train inner join fetch train.rames as rame where rame.power > ? and train.lavenTrain = ?

Axen · **Joined:** Fri Dec 12, 2003 7:38 am **Posts:** 5

Of course I read the manual, but it is not clear....