I am trying to implement a custom type handler in my project using the documentation found here:
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId= 422 Here is my type converter class: <><><><><><> public class CharBoolHandlerCallback : ITypeHandlerCallback { private const string DB_TRUE_VAL = @"Y"; private const string DB_FALSE_VAL = @"N"; public object ValueOf(string nullValue) { if (DB_TRUE_VAL.Equals(nullValue, StringComparison.OrdinalIgnoreCase)) return true; else if (DB_FALSE_VAL.Equals(nullValue, StringComparison.OrdinalIgnoreCase)) return false; else throw new DataMapperException(); } public object GetResult(IResultGetter getter) { if (getter.Value == null || getter.Value == DBNull.Value) throw new DataMapperException(); string dbVal = Convert.ToString(getter.Value); if (DB_TRUE_VAL.Equals(dbVal, StringComparison.OrdinalIgnoreCase)) return true; else if (DB_FALSE_VAL.Equals(dbVal, StringComparison.OrdinalIgnoreCase)) return false; else throw new DataMapperException(); } public void SetParameter(IParameterSetter setter, object parameter) { setter.Value = Convert.ToBoolean(parameter) ? DB_TRUE_VAL : DB_FALSE_VAL; } public object NullValue { get { throw new InvalidCastException(); } } } <><><><><><> I have the following in my main sqlmap.config: <><><><><><> <alias> <typeAlias alias="YesNoToBool" type="Namespace.CharBoolHandlerCallback, AssemblyName" /> </alias> <typeHandlers> <typeHandler type="System.Boolean" dbType="varchar(1)" callback="YesNoToBool"/> </typeHandlers> <><><><><><> And my result map looks like: <><><><><><> <resultMaps> <resultMap id="EquipmentTypeResult" class="EquipmentTypeClass"> <constructor> <argument argumentName="equipmentTypeId" column="EQUIPMENT_TYPE_ID" /> <argument argumentName="description" column="DESCRIPTION" /> <argument argumentName="createdUser" column="CREATED_USERNAME" select="GetUserByName"/> <argument argumentName="createdDate" column="CREATED_DATE" /> <argument argumentName="updatedUser" column="UPDATED_USERNAME" select="GetUserByName"/> <argument argumentName="updatedDate" column="UPDATED_DATE" /> <argument argumentName="active" column="ACTIVE" type="System.Boolean" dbType="varchar(1)"/> <argument argumentName="legacy" column="LEGACY" type="System.Boolean" dbType="varchar(1)"/> </constructor> </resultMap> </resultMaps> <><><><><><> All of my iBATIS configuration loads. However, when I try to get an object instance, iBATIS throws a SqlDataException trying to do the conversion and the call stack has no indication that my custom type converter was ever called. This same configuration works fine if I just bring those fields over as strings and don't try to use the custom type converter. Anyone know what I am doing wrong here? Tony
