I have several DB columns in an Oracle schema that are of type NUMBER(1). The contents of this column can be either "1" or "0" (i.e true|false or yes|no). Can I map these directly to a boolean type in my Java class via the *.hbm.xml file?

Thanks.

A.

try filter objects (tables/views) with http://opensource.atlassian.com/project ... se/HBX-250

regards

i'm sorry.wrong tread
You have to use hibernate type (it is easy with hibernate3)

1 and 0 is the default behavior for the boolean type. Just make your properties boolean or Boolean (if you have tri-state behavior).

If you're silly like us then you would have to specifically set the type if you wanted to use something like Y/N. Or you could write your own type and map to Bob and Doug ;)

There are also the true_false and yes_no Hibernate types to support 'T'/'F' and 'Y'/'N' CHAR fields, respectively.

- Jesse