Instead of building a query, can I just query with an object that has the properties set that I'm looking for? Similiar to how OJB does it?

Thanks for any ideas you have!

Hibernate 2.1 has Example queries.

And done incredibly cool, if I don't say so myself ;-)

Could you point me to a url with that documentation/examples? I seem to be running into older documentation.

I'm not sure if I found the documentation on what you mentioned, what I did find was Criteria queries. I still did not find any examples on the following:

I want to pass just the object(who's properties are set to match my criteria) and have the criteria built for me. This would be better than having to build the criteria by calling add(Expression.like()), when all I want is to fetch the object that has matching properties.

Thanks again.

The hibernate 2.1 documentation is in the hibernate 2.1 download, of course.




It is much more powerful than that, however:





etc...


Thus, the Hibernate example query API is unified with the criteria query API, making it MUCH more powerful than other implementations I've seen. I am very proud of this. :)

Is there any reason why properties in a class that are mapped as database IDs are not included when you use Criteria with Examples?

For example, I have a simple bean with an "id" property (mapped as a db ID) and a "name" property - if I set both of the properties and then create an Example object from this bean, when the select occurs it quietly ignores the id property.

If you then continue this, and then map the "name" property as a db ID as well, then the select reverts to a "where 1=1".

sure. it makes absolutely no sense to include the PK in an example query. If the PK is included, then the Example identifies exactly one row by definition. So you don't need an Example at all.

Could be different however if you use like ...

uuuhh I *suppose*...

I can understand that point :)

I'm trying to refactor some code which used to build up the SQL manually depending upon the properties set (it doesn't necessarily have the PK set in the bean) - using an Example seemed like the perfect replacement.

However, if the PK is always left out, then it's not exactly hard to code around that!

Cheers again for the fast response.