We use Hibernate 3.2.5 and Spring 2.0 in our project.

I want to limit the maximum number of records that a query can return so I am using a default max results property of hibernate template in conjunction with setting the property on query objects. In specific scenarios this property will be overridden to retrieve/allow more results. I have the following questions:

1 - Is there a generic way of setting a default max results value for all instances of SQLQuery/Query? Can I achieve it using some kind of interceptor or some other way of global initization of properties of queries? I still want to provide developers the ability to override this default value
2 - Is there a generic way of throwing a runtime exception (special behavior) whenever the max results exceed? I am looking for some kind of interceptor or event listener which can know the number of records returned by the HQL/SQL and then throw a runtime exception

I appreciate your help.

Thanks
Rahul