Own join for criteria API

e.schava · **Joined:** Wed Apr 26, 2006 5:01 am **Posts:** 3

My accident: I want to calculate summary cost of orders in different currencies. I have to join tables with orders and currency rates. Objects Order and CurrencyRate doesn't have any associations. But Criteria class joins tables only with associations in models.

What can you to advise?

axismundi · **Joined:** Mon Aug 22, 2005 5:45 am **Posts:** 146

e.schava wrote:

My accident: I want to calculate summary cost of orders in different currencies. I have to join tables with orders and currency rates. Objects Order and CurrencyRate doesn't have any associations. But Criteria class joins tables only with associations in models.

What can you to advise?

you can use either Criteria API or HQL and pass entity IDs explicitly:
in HQL something like
select r from Orders o, Rates r where o.id=ORDERID and r.orderid=ORDERID and ....

e.schava · **Joined:** Wed Apr 26, 2006 5:01 am **Posts:** 3

axismundi wrote:

you can use either Criteria API or HQL and pass entity IDs explicitly:
in HQL something like
select r from Orders o, Rates r where o.id=ORDERID and r.orderid=ORDERID and ....

Thanks.. I always can use HQL but it is very complicated when I create query dinamically - criterions from user form

But can I do it using Criteria class?

axismundi · **Joined:** Mon Aug 22, 2005 5:45 am **Posts:** 146

e.schava wrote:

axismundi wrote:

you can use either Criteria API or HQL and pass entity IDs explicitly:
in HQL something like
select r from Orders o, Rates r where o.id=ORDERID and r.orderid=ORDERID and ....

Thanks.. I always can use HQL but it is very complicated when I create query dinamically - criterions from user form

But can I do it using Criteria class?

simply use the normal Criteria API and set the id reference manually

http://www.hibernate.org/hib_docs/v3/re ... teria.html

e.schava · **Joined:** Wed Apr 26, 2006 5:01 am **Posts:** 3

axismundi wrote:

simply use the normal Criteria API and set the id reference manually

http://www.hibernate.org/hib_docs/v3/re ... teria.html

I havn't completely understood you. Can you explain more strictly?