DB mapping to Java boolean?

Jeff_dk · **Joined:** Tue Dec 09, 2003 5:15 am **Posts:** 3

Hi,

I have a table where boolean values are represented as VARCHAR (Oracle) fields with "1" for true and "2" for false. How can I map these fields to Java booleans?

I'm pretty new to Hibernate. Please be patient with me if this is a simple question :)

Thanks in advance,

Jeff

thorstenschaefer · **Joined:** Fri Nov 28, 2003 6:57 am **Posts:** 20

Take a look at UserTypes. Examples are shipped with the distribution.

HTH,

Thorsten

stolley · **Posted:** Tue Dec 09, 2003 7:11 pm

If you don't absolutely need to tha values to '1'/'2', you can map Booleans with a Hibernate.TRUE_FALSE, which gives 'T'/'F' in the column. I'm not sure if there's any simple customization you can do to get '1'/'2' instead of 'T'/'F'. Otherwise, yeah, a UserType or CompositeUserType are pretty easy to do anyway.