Help with HQL

[stanislav bashkirtsev]

1. I have Customer. It has many Accounts.
2. I have Payment, that has one Account.
Question: how can I fetch all payments where customer=?
The SQL is something like this:

SELECT payments.* 
FROM payments 
  INNER JOIN accounts ON payments.account = accounts.id 
  INNER JOIN customers ON accounts.customerId = customers.id
WHERE customers.id = 1

What it will be look like in HQL?

[Bhavesh Dak]

Probable Solution,

Please ignore syntax related flaws.

    

Query query = "from Customer c where c.id = cid";
sqlQuery.setLong("cid", customer.getCustomerId());

List<Account> acctList = ((Account)query.list().get(0)).getAccounts();

Criteria crit = session.createCriteria(Payment.class);
crit.add(Restrictions.in("account",acctList);

List<Payment> paymentList = crit.list();

Cheers,
Bhavesh.

[stanislav bashkirtsev]

There are two of "select"((( It's very bad for performance(

[Bhavesh Dak]

Yeah that is interesting,

I am also curious if we can achieve this in a single HQL.

[stanislav bashkirtsev]

Maybe the only way is to create bidirectional relationships...