I have a problem with Boolean properties and null values in these. I want them to remain as null when the class is persisted. What happens now is that they get persisted as "false", which is definitly not what I intended. Anybody had this problem. I am using SQLAnywhere 6.4 as database and the Boolean is mapped to tinyint, which supports null.

Addendum : Looking at the sqlstatement that gets sent to the database, a null boolen value is represented as en empty string ''

You could writ a UserType which takes the null values into acount.

HTH
Ernst

Yeah you could, but i think Hibernate should store it as null, not an empty string. I gor around this, by adding a pre-insert/pre-update trigger in the database.

There are pros and cons, this is the reason for user type: let the user choose what he wants. Note that user types are portable (not triggers)

Yes, I know. But why does Hibernate threat Boolean nulls differently that say Integer nulls ?

Does all DB support tree-state boolean?