I've mapped a table with a composite key to ensure that rows are unique, but I often need to search on only one element of the key. How is this possible in hibernate?

ie. I've got a display item and a priceIndex which makes each display price unique, but I need to search for all prices for each display, so I can't search by primary key.

The only other solution is to create an arbitary key, which I'm keen to avoid. How have other people gotten around this problem?

Ok, found out that you can search by doing this

If the key contains two elements called "display" and "index" and the key is called "id", you can search by using the . notation like this baseObject.id.display

so a query looks like this

find("from BaseObject object where object.id.display = ?", display, Hibernate.entity(Display.class).

Simple.