Got in entity, say X with

@FilterDef(name = "filter", parameters = { @ParamDef(name = "falseVal", type = "integer") })

@Filters({ @Filter(name = "filter", condition = "(:falseVal = rating)") })


I have another entity Y that has a Set of X that is mapped with a
@ManyToMany annotation, a join table is used to the relation.

When i retrieve the entity from a "from X ....." the filter works just fine

But, when i do Y.getX() the collection is initialized without the filter applied !

Any way to apply the filter ?

I've tried setting the filter to the collection mapping but get an SQLException because Hibernate tries to apply the filter to the join table no to the table containing the entity.

Well in the mapping file, you'd do this by attaching the filter to the <many-to-many/> element as opposed to the <set/> element. Not sure if this is available yet in the annotations. Emmanuel?

Yes thereis a @Filter annotation but as i said Hibernate tries to apply the "where filerColumn=?" on the join table, not on the table that contains the actual entity.

you miss the point. For many-to-many collections, in the mapping files you can attach the filter in two different places. One affects the association table; the other affects the "target table".

I dont use ANY mapping files, only annotations.

right, hence my comments in my initial response. So really, then, this is a question/post that belongs in the "EJB 3.0 Persistence (JSR-220)" forum.