hello,

One of my mapped classes has a property of type char which is mapped to a char(1) column. This is a status column. The table has a secondary index on this column. As most rows in this table will be in a specific state by which it is not neccessary to locate them, our DBA recommended to store this state as NULL in the database - then it will be left out from the index and speed up index lookups for other statuses.

As I don't want my class to have the status char = 0, I thought a UserType might be a good idea here which maps 'F' to null and just passes through everything else. While it works perfectly on save and load it doesn't seem to use the UserType in queries.

When I do "from Document d where d.owner=? and d.status=?" and then set 'F' to be the value of status, then it actually passes 'F' into the created PreparedStatement. I kind of hoped it used my UserType to convert the 'F' to NULL...

Is this the correct behaviour or am I missing something?

Are you really specifying the Type by for example using query.setParameter(int position, Object val, Type type) ?

well, I am using Session's find(String query, Object[] values, Type[] types) and I specify Hibernate.CHARACTER as the type for that.... I should probably specify something else as the type?

thanks,
erik

Hibernate.custom(Usertype.class)