Same problem here...
I use Oracle 8i
Hibernate 3.2.6
Code:
<property name="hibernate.query.substitutions">true 'Y', false 'N'</property>
Then i got this error:
Code:
ava.sql.BatchUpdateException: ORA-02290: check constraint (MYSCHEMA.CK_RESP_FIELD_MANDATORY) violated
When i disable the constraint, hibernate inserts 1 or 0 on that field...
Here's a hbm's snippet:
Code:
<property name="mandatory" type="boolean" generated="never">
<column length="1" name="MANDATORY" not-null="true"/>
</property>
I also tried with: hibernate.query.substitutions=true='Y', false='N' and nothing seems to work...