is there a way to create criteria from the Named query?

rahulbhirud · **Joined:** Tue May 15, 2007 5:02 pm **Posts:** 12

is there a way to create friteria from named query in Hibernate?

kochcp · **Posted:** Mon May 21, 2007 8:42 am

rahulbhirud · **Joined:** Tue May 15, 2007 5:02 pm **Posts:** 12

thanks for the reply...

I just want to put a global filter on all the named queries being executed.. is there a efficient way to do that in hibernate?

again your help is appreciated..

thanks

kochcp · **Posted:** Mon May 21, 2007 8:58 am

well. you have the Query object after the getNamedQuery call. So, you can modify it right there.

or have your own method called automatically whenever getNamedQuery is called (AoP, or some other way)

rahulbhirud · **Joined:** Tue May 15, 2007 5:02 pm **Posts:** 12

I cannot modify the query object to put more restrictions right..? like I want to add a where clause, which is more generic and is applicable to almost all the queries in the application...

thanks in advance..

kochcp · **Posted:** Mon May 21, 2007 9:20 am

you could try something like:

Code:

Query q = session.getNamedQuery("asf");

Query q1 = new Query(q.getQueryString()+"where ...");

rahulbhirud · **Joined:** Tue May 15, 2007 5:02 pm **Posts:** 12

yes I tried something like this... which works for the simple queries but not sure about the complex queries. I am looking for something that keep a filter at the session level that is applied for each query executed for that session.

but still this discussion was helpful.. Thanks again... and let me know if have any further ideas...

kochcp · **Posted:** Mon May 21, 2007 9:57 am

check the Interceptor API. EmptyInterceptor is one of the interfaces you might want to look at. I think you can implement filters in there.

I just don't do much with interceptors so I'm not totally sure