I'm using hibernate 3.0.5 and I'm trying to create a 1 to m relationship with the <set tag. My parent class has a 1 column PK and so does my child, but they are different columns, hence the 1 to m. The child table does have an FK back to the parent, but I want to narrow the results more by adding another column to query that is in both table (adding to the join).

Does any one know how to do this?

I add another column to the <key tag but get an error saying that I have 2 columns defined in my key tag but the table only has 1 PK.

Thanks,

I would say it’s not possible to do what you described in the maps. I would solve this programmatically by using Criteria and Restrictions:



This method would return a list of objects, where the key is the property name mapping to the column and the value is the value you are looking for.

I was trying to hide that from the calling class (the main driver) and hide it in the xml definition file for the class in the one to many....

But this will work if I can't find anything else.

Thanks.

An option could be to use named queries, which can be embedded in the map. Take a look at this link:

http://www.hibernate.org/hib_docs/v3/reference/en/html/objectstate.html#objectstate-querying-executing-named