Hibernate version: 3.2.6

I am using an hibernate event listener (SaveOrUpdateEventListener) to transparently setting properties of an object before saving it into the databse. This is working perfectly fine.

But I am having problems with implementing the second requirement:
I want to intercept the loading of objects from the database, change the query (read: adding a new contraint) and then letting the database load the objects with the modified query.

I checked the existing hibernate event listener, but I didn't find a way to manipulate the query.

Does anybody has a tip how to implement this? Is there a certain point where I can intercept and change the query?

Thanks for your help and if something is unclear with my description, please ask

stefon

I found out that I can use the EmptyInterceptor to implement an Interceptor which uses the
String onPrepareStatement(String sql)
method.

But this only allows me to manipulate the Query in the form of an SQL string.

Is there a point where I can manipulate the Query in the form of an Object Query tree?