I am using hibernate 2.1 with oracle 8i.

I cant yet post the mapping documents because this is a design issue.

I have Table A & Table B.
Table B can contain 1 or more rows per row in Table A (FK/PK association)

I would like to fetch the list of all rows in A as ObjA that match a certain criteria (This was easy to do with the criteria API).

But I also want for EACH ObjA from the set of associated ObjBs I want to fetch ONLY the ObjB that has the max primary key. PrimaryKeys of type long are generated from a sequence.

I saw that there was a where clause on the one-to-many mapping & I was hoping I could use this to restrict the set of B's associated with each A to the one with max primaryKey using a where clause. This leads me to 2 issues:

(a) is it possible for the where clause on the one-to-many mapping to use the properties of A? if so does this follow the standard HQL syntax? (I think I saw a post that said this might not be possible...)

(b) if (a) is not possible are there any work around that anyone knows of?

Thanks
Pratima