Hibernate Query By Example

http://nhibernate.sourceforge.net/h2.0.3-docs/reference/html/query-language.html
http://nhibernate.sourceforge.net/h2.0.3-docs/reference/html/worked-example.html

http://www.eli.sdsu.edu/courses/fall04/cs683/notes/hibernate/hibernate.html

Hey,

      Its not HQL i am asking about. Its Hibernate QBE ( a part of hibernate QBC).  I found documentation on QBC, but not QBE... thats what i am looking for.

Thank you.

Or do you mean this: http://www.hibernate.org/5.html?

nope

Or this http://www.hibernate.org/hib_docs/api/net/sf/hibernate/Query.html

User exampleUser = new User();
 exampleUser.setFirstname("Max");
 Criteria criteria = session.createCriteria(User.class);
 criteria.add( Example.create(exampleUser) );
 List result = criteria.list();
 

Thank you.,

  what if the exampleUser has a mapping to Office object.  (many to one). and now i want to get all users within the office of "Experts Exchange" having a name "mike"

??

Thank you.

u will find your solution here

http://nhibernate.sourceforge.net/h2.0.3-docs/reference/html/query-language.html

I dont want to use HQL.

i want to use the hibernates capability of retrieving records by criteria  /  example.

Where do you specify the {alias} name ??

{alias} will be replaced with the name of the table (hibernta does it for you)
see: http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Restrictions.html#sqlRestriction(java.lang.String)

:-)

Good luck!