I have a database that I can't change It's structure and need to query over tables with composite keys

I'm trying to use the documentation strategy :

I have a fee pojo class named Fee and an Iten pojo class

The last one has a composite key with two atributes: Fee and ItemFee

I created a class named ItemPK and added two atributtes Fee and itemFee

In my Item pojo I added :
@EmbeddedId
private ItemPK id;

When I try to run a query :

select i from Item i where i.id.fee.fee = :x

I get this error :

Caused by: org.hibernate.QueryException: could not resolve property: cobranca of
: item.Item [select i from item.Item
i where i.id.fee.fee = :fee]

Hi,

I had the same problem and I solved it very dirty, with selecting all Rows and selecting all relevant in a while-loop by copying them in a new List. *shiver* ;-)

If someone has got a better solution I'd appreciate it if you could please let me know.

geets

Nico

I think this could be a solution:




but this criteria doesn't delete itself after using and I didn't find a way to unset this. So every Query uses this criteria after setting it.

greets

Nico