Suppose we have the following object graph:

Nested objects mapped as 'many-to-one'
I have a Filter called 'myFilter' as follows:


Each mapping for each object has the following element:


before running hql, i perform session.enableFilter("myFilter").

Filter is applied to selection, i.e. appropriate where clause prepended, when I'm trying to load object. And it is applied only to that object which is selected.
How can I propagate the filtering for each nested object as well when loading Obj, which contains NestedObj1, NestedObj2, so that only those NestedObj1 and NestedObj2 loaded that meet similar filter criteria. (basicly, I want to load not logically deleted object and its not logically deleted nested objects)



[/code]

Does hibernate apply filter to nested object, if it is configured in its mapping file.
I have a Child, and filter element, this filter is correctly applied to it when i query the Child object.
This Child object is also could be mapped to some Parent object. Parent object may have multiple childs. I want to load Parent and only those its Child objects, that matches the Childs' filter condition.
It doesnt work by default. How to make it work ?

Hi lovkiys !

I seem to have the same (or a similar) problem.
I discovered your post while searching for a solution but unfortunatly nobody
has answered your post yet. I've created a new post today describing my problem under the title "Filter not applied to sub-level elements".
Maybe an answer there will also help you (or vice versa).

Joak

Hi, I have the same problem and the only solution i found was a post load filtering. When I load an object graph I recursivelly using reflection remove (in fact replace by fake objects) objects without a read right. Here's my code which you can inspire on.

protected Object secure(Object object, Vector visitedOids) {
try {
if (object == null) {
return null;
}
if (object instanceof Vertex) {
Vertex vertex = (Vertex) object;

visitedOids.add(vertex.getOid());
BeanInfo beanInfo = Introspector.getBeanInfo(vertex.getClass());

PropertyDescriptor[] propertyDescriptors = beanInfo.getPropertyDescriptors();

for (PropertyDescriptor pDesc: propertyDescriptors) {
if (isOfClass(Vertex.class, pDesc.getPropertyType()) && !isOfClass(FakeVertex.class, pDesc.getPropertyType())) {
Method readMethod = pDesc.getReadMethod();
Vertex innerVertex = (Vertex) readMethod.invoke(vertex, (Object[]) null);
if (innerVertex != null && !visitedOids.contains(innerVertex.getOid())) {
innerVertex = (Vertex) secure(innerVertex, visitedOids);
if (innerVertex instanceof FakeVertex) {
Method writeMethod = pDesc.getWriteMethod();
writeMethod.invoke(vertex, new Object[] {innerVertex});
}
}
} else if (isOfClass(Collection.class, pDesc.getPropertyType())) {
Method readMethod = pDesc.getReadMethod();
Collection collection = (Collection) readMethod.invoke(vertex, (Object[]) null);
if (collection != null && !visitedOids.contains(collection)) {

secure(collection, visitedOids);
}
}
}
if (!isReadGranted(vertex.getAcl())) {
return new FakeVertex(vertex);
}
return vertex;
} else if (object instanceof Collection) {
//doesnt' solve collection in collection
Collection collection = (Collection) object;
visitedOids.add(collection);

for (Iterator iterator = collection.iterator(); iterator.hasNext();) {
Object o = iterator.next();
if (!(o instanceof Vertex)) {
continue;
}
Vertex vertex = (Vertex) o;
Vertex securedVertex = (Vertex) secure(vertex, visitedOids);
if (securedVertex instanceof FakeVertex) {
iterator.remove();
}
}
return collection;
} else {
return object;
}

} catch (Exception e) {
logger.error(e);
throw new RuntimeException("Cannot secure vertex.", e);
}
}