Hello,

I have the following queries:

a) If I do not have all the info to construct a composite identifier class, then how can I return a list of possibilities from the database? Do I have to list all and then match them manually? i.e. can i use wildcard values in my classes ;)

b) How do I reference fields of a composite key in HQL? (in my mapping file I have <key-property> and not <property>) My query returns an 'invalid identifier' error...

c) When I have cascade="all-delete-orphan", why is the generated SQL performing an UPDATE to the foreign key to make it null. Why does it not perform a delete on the children?

I am obviously missing something here and need some input from far brainier people than myself...

Many thanks

Cheerio,
Nic.

a) If I do not have all the info to construct a composite identifier class, then how can I return a list of possibilities from the database? Do I have to list all and then match them manually? i.e. can i use wildcard values in my classes ;)

1) could query by example see the hibernate documenation for that
2) from County where id.county = 'harris' and id.state = 'MN'
3) from County where id.county = :county and id.state = :state
4) from County where id = :county (:county is replaced by the CountyId class)

How do I reference fields of a composite key in HQL? (in my mapping file I have <key-property> and not <property>) My query returns an 'invalid identifier' error..

see 2) 3) and 4) above

c) When I have cascade="all-delete-orphan", why is the generated SQL performing an UPDATE to the foreign key to make it null. Why does it not perform a delete on the children?

do not know the answer to this one.