How to convert char(1) column with T/F values into boolean?

djzeel · **Posted:** Tue Apr 19, 2005 8:57 pm

I have a column in Oracle DB, named "ISADMIN", which is defined as CHAR(1) with possible values 'T' and 'F'. My mapping file maps this column to a field of type "boolean".

I tried to rely on auto-conversion of the value into boolean, but I am getting this error:

Code:

An SQLException was provoked by the following failure: java.lang.NumberFormatException: For input string: "F"

Any suggestions on how to convert those values are appreciated.

Thank you,
Konstantin[/code]

djzeel · **Posted:** Tue Apr 19, 2005 9:14 pm

Got it - gotta use "true_false" as the data-type in the mapping file, instead of "boolean".

Thanks,
konstantin