How do I manuplate the named query at run time?

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

I am using EJB 3.0 entity beans and I have a specific requirement. I need to modify the named query at the run time like add some extra search criteria just before the actual execution. This needs to be done at the framework lavel so that developer do not care about it.

Can any body help?

Thanks in advance

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Use criteria.

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

Can you explain exactly how to use it?

jolinar13 · **Joined:** Wed May 16, 2007 6:16 am **Posts:** 3

rahulbhirud wrote:

Can you explain exactly how to use it?

Code:

List cats = session.createCriteria(Cat.class)
     .add( Restrictions.like("name", "Iz%") )
     .add( Restrictions.gt( "weight", new Float(minWeight) ) )
     .addOrder( Order.asc("age") )
     .list();

http://www.hibernate.org/hib_docs/v3/api/org/hibernate/Criteria.html

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

hey thanks for the reply... but sorry this is to create the new query itself. I want to modify the existing named query to add more conditions. The existing query can be complex query.

any suggestions would be appreciated...

Thanks in advance...