Hibernate version: 3.1

Mapping documents:
<property name="postalCode" column="postal_code" ...>

Code between sessionFactory.openSession() and session.close():

Criteria crit = s.createCriteria(Person.class)
.setProjection( Projections.rowCount())
.add(Restrictions.or(
Restrictions.isNull("b.postalCode"),
Restrictions.sqlRestriction("length({alias}.postalCode)=?",0,Hibernate.INTEGER)
));

I'd like to know if it is considered as expected that the generated sql is :

Hibernate: select count(*) as y0_ from person this_ where (this_.postal_code is null or length(this_.postalCode)=?)

If it is, is there a way to force Hibernate to translate the property to the actual column name ?

BTW, a Criteria.setReadonly(boolean) a la Query would be really appreciated.
Thank you for your help
Richard

Because you have specified SQL restrictions H does not do any magic, H thinks that supplied restriction is SQL.

How would you use hibernate to map the propertyname into the column name?

here is my solution, I created couple new classes to convert property name to column...this can be extended....for now it does the trick...this should be part of the API

Restrictions.sqlRestriction - extract column name from property
http://javarobski.blogspot.com/2010/01/ ... tract.html