Boolean properties and iBatis SqlMaps

[luxaeterna]

Hi all,

Does anyone know whether it is possible to map a char column in the database which has values of 'Y' and 'N' to a boolean value in a JavaBean using Spring and iBatis SqlMaps? Currently it is failing and giving me a NumberFormatException, which I assume means that it expects boolean fields to be stored as 1 or 0 in the database. Is there some way that I can interpose some code to do this conversion?

Oh, and changing the database isn't an option, I'm afraid.

Thanks.

Geoff

[luxaeterna]

Never mind, I've figured this out. iBatis has custom type handler support which i can use to do this.