Hi,

How can I convert the following query into HQL?

select * from m_tran mt inner join m_process mp on mt.id = mp.id where mp.type = 'ABCD' and mp.status = 'EFGH';

Essentially all I'm looking for is a list of objects which represent m_tran table based on the above criteria.

Also, can we use the Criteria* classes for this kind of situation?

Thanks,
Naylak

Well, what is an object? If I go with the supposition that n_tran is an object(lets call the object Tran) and m_process is another object(Process), which Tran holds a collection of, you might do something like this:

select Tran from Tran where Tran.Process.type = "ABCD" and Tran.Process.status = "EFGH"

That would return you a list of Tran objects matching your criteria. You could optimize with joins but Hibernate should be able to get what you have everything appropriately mapped together.

I think this would work fine using a Criteria as well, but I'm not sure of the exact syntax since I'm not sure exactly what you were wanting.

I was probably not clear in explaining the problem earlier.

m_tran is mapped to an Object MTran
m_process is mapped to another Object MProcess

They are two independent sibling tables which are mapped to a parent table via the id column. So, they don't have any direct relationship between themselves.

So, now I want to obtain all the rows from m_tran table which are having the same id as on m_process and are also satisfying the other two conditions. The obtained rows should probably be the MTran objects.

Let me know if that's clear.

Thanks,
Naylak