I've looked at the help and searched the forums, and I'm sure I'm just missing something so I hate asking but I can't find the answer.

Let's say I've got a mapping like this:



It is a one-way (not bidirectional) mapping from A->B, and I have an instance of B. I want to retrieve the object of type A that contains my instance of type B. Is there an HQL or ICriteria way of doing this?

Thanks!

Is there really no way to do this, or is my question just too stupid to deserve an answer(like I said, I might have missed something very basic)? It's simple to do in SQL and would probably work on any platform I care about, but I'd really like to avoid using any SQL if I could.

What about "from A a join fetch a.Bees b where b.Name = 'x'" (or b.Id or any other unique way to identify your B instance).

Sure enough, that works. For some reason it wasn't clear that you could do a join like that on a collection. Thanks for the help.