Hello,

I'm trying to port some code from OJB over to Hibernate. OJB had an "addSql" method on its Criteria class which enabled one to add an aribtrary filter.

For example,



As you can see, we used this for an instance-level public/private authorization scheme. I looked through the Hibernate reference guide, but the SQL query mechanism (covered in Ch 15) seems to target complete SQL queries, whereas I just want to add a SQL where clause to a Hibernate query.

Is there a way to do this?

TIA,

Alex

You can do this quite easily by creating a custom criterion like this:

[code]
criteria.add(new Criterion() {
public String toSQLString(..) {
return "AND x=y";
}
public TypedValues[] getTypedValues(...) {
return new TypedValues[0];
}
}[code][/code]

Arh, sorry, formating failure

Actually, there is an Expression.sql(), exactly for this purpose. (But probably creating a new Criterion is more elegant.

Thanks for the rapid reply! Implementing it as we speak. Once again, nice API.