hi (from a newbie),

Can someone help me as to how to construct a HQL query when there is a composite key involved.

It is a simple table with the following 2 fields as primary keys:

table = Auction

pkey 1 = auction_number
pkey 2 = lot_number

i used hibernate console to generate POJOs.

The 2 keys become part of a class generated.

snapshot of the CreateQuery i did:

"from Auction auction where auction.id = :auction_id"

.setParameter("auction_id", auction_id).

it returned a exception.

2 questions:

1. how do i query just using only pkey "auction_number" to return only those records having this "auction_number" ?

2. how to set the values in the 2 pkeys before executing the query ?

Thanks for helping

1. String query="from Auction auction where auction.comp_id.auction_number=:auction_number and auction.comp_id.lot_number =:lot_number";

comp_id this is member in Auction and instance of AuctionPk class

2. session.createQuery(query)
.setParameter("comp_id.auction_number", an)
.setParameter("comp_id.lot_number", ln)
.list();[/code]

hi Dimka,

Thanks ... u gave me a hint as to how to solve the problem. The .setParam created a 'named parameter not found' error.
It should be just:

.setParameter("an",an);
.setParameter("ln",ln);

That made it work ... unless i am missing something else from your response. Nevertheless, thanks it helped me work it out.