mapping type one_zero instead of true_false, yes_no

k.o. · **Joined:** Wed Mar 25, 2009 5:59 am **Posts:** 2

I would like to map a CHAR(1) field with possible values of '1'/'0'/null to a java Boolean true/false/null. How to do it?

littypreethkr · **Posted:** Wed Mar 25, 2009 8:18 am

If you are using Oracle I dont think anything spl would be needed for this. Coz by default true and false goes as 1 and 0 to the DB. So putting the sql-type for the column would be enough. like:

Code:

      <property name="testBool">
         <column name="testBool" length="1" sql-type="char"></column>
      </property>

k.o. · **Joined:** Wed Mar 25, 2009 5:59 am **Posts:** 2

thx for the answer. It seems to work now the following way:

@Type(type = "boolean")
public Boolean getField() { ... }