Hibernate Filters

marcelpanse · **Posted:** Wed Sep 27, 2006 7:02 am

First of i want to say that the hibernate filters in generall work perfect and i think they are really usefull! So keep up the good work hibernate team ;)

There is one question i have about this @Filter:

I get this error:

"@Filter not allowed on subclasses (ignored): com.nefli.camelot.data.domain.Region"

this is my code;

Region.java (region is the domain class POJO)

Code:

@Entity
@FilterDef(name="disabledFilter") @Filter(name="disabledFilter", condition="disabled = 0")
public class Region extends Asset
{ ... not important 

Asset.java (asset is a POJO with the common asset info)

Code:

@Entity
@Inheritance(strategy=InheritanceType.JOINED)
public class Asset extends AbstractRecordImpl
{ ... not important

AbstractRecordImpl.java (the abstract record with stuff like id, hashcode, equals etc.)

Code:

@MappedSuperclass
public abstract class AbstractRecordImpl implements Record, Serializable
{ .. not important

So why o why can't i create a filter on a subclass?

marcelpanse · **Posted:** Thu Sep 28, 2006 2:56 am

Anyone? Its a relatively simple question?

marcelpanse · **Posted:** Mon Oct 02, 2006 2:56 am

Probebly not so simple :\

assaf27 · **Joined:** Sun Jan 22, 2006 6:56 am **Posts:** 29

I'm just guessing but...
You're using iheritance by joining. This means the hierarchy will be fetched in a single query which joins all the hierarchy tables. The filter stuff is added in the where clause of this query, verbatim. So it will apply to everything retunred by the query. There's no difference if you put it in the base class then.

marcelpanse · **Posted:** Mon Oct 02, 2006 4:38 am

Yes, but, I have the filter at the subclass because the subclass is the only entity with knowledge about his properties.
ie. Region has a property Country... This is defined in the region class, so i want my filter to say something like 'where region.country = :country'..

And there might be other subclasses on the same baseclass, like a Resort, but the filter i want to add on a Resort is different then the filter i'd like to add on the Region, but they have to same baseclass.

But when i add the filter to a subclass i get this error:

"@Filter not allowed on subclasses (ignored): com.nefli.camelot.data.domain.Region"