Section 7.2 of the Hibernate reference manual says that you can add an arbitrary SQL where clause to control what elements of a collection are returned:



I have a mapping that uses this:



"where" is definitely part of the DTD and is supposed to be valid for a set mapping. And yet when I try this, it appears to have no effect. In my testing it wasn't working and so I started looking at the generated SQL and didn't find the where clause.

Next I added a nonsense condition that doesn't match my table or object structure at all and which should have caused an error (where="foobar=0"). On testing "foobar" doesn't appear in the generated SQL, nor does Hibernate ever throw any errors when this mapping is used.

This behavior happens under the current 3.1 release candidate as well as an older CVS snapshot of 3.1 I had. I can't easily test under 3.0 because my app has 3.1-specific functionality.

Is the documentation incorrect, 3.1 broken, or am I missing some way to turn this functionality on? Thanks.

Regarding my previous post, in part I was a victim of caching. Putting in an invalid where clause will cause an error. However the problem remains for me that a syntactically correct where clause has no effect. I must have the syntax wrong.

I have a standard parent-child relationship on a single entity type, Product.



I want the children set to be filtered by whether the deleted field is false (0). According to the docs, it seems that the above would do it, but it has no effect. I thought that it might need to be specified whether I am checking deleted on the parent or the child, and further, since it's raw SQL, it might need to have the placeholders for Hibernate aliases and thus would need to be something like:



But apparently that isn't legal syntax. Any suggestions?

Hello!

I have the same problem. See my post, maybe it will give you more ideas.

I have also find out, that the documentation does not reflect the current state: for example in <many-to-many> I can use where="", but nothing is said about that in docu.