Sometimes sql (like) queries aren’t the optimal way to express what data you want to retrieve from a database. In some cases using Hibernate’s criteria API or Toplink’s Query Expressions will be more powerfull and easier to write. Especially if you can reuse query expressions. DevX has just published an article describing Hibernate’s criteria API: Hibernate Criteria API: Multi-Criteria Search Made Easy java,hibernate