We just took over code from our consultants and have an issue with one of the screen..sorry i am new and might be a dumb question.

The hibernate maping maps the NUMBER(1) column to java Boolean. When the Boolean is false hibernate writes null and when true it write 1 to database.

My reqt is to have 0 value in column when the Boolean flag is FALSE. where can i do it?

Thanks

Sounds like its already behaving the way you want!

Oops my bad..it was a typo....Currently its writing NULL for FALSE and 1 for TRUE. I want it to write 0 for FALSE instead of NULL.

Are you sure? The hibernate code does this to set boolean values:
preparedStatement.setBoolean( index, ( (Boolean) value ).booleanValue() );
So either you're setting your Boolean property to null in your code or your database/driver is changing false to null. Either way, I don't think hibernate has anything to do with it.

for me , for boolean properties 0 is storing for value false.

Any way you can try this

Add the following configuration property in Hibernate.cfg.xml
<property name="hibernate.query.substitutions">true 1, false 0</property>