I have a field in my database that contains a “Y” if true and a null if false. I have represented it as Boolean in my entity because I want it to appear as a checkbox on my screens. I have modified datatypes.xml in my global module like this:
<datatype class="com.haulmont.chile.core.datatypes.impl.BooleanDatatype" trueString="Y" falseString=""/>
However, when I try to access a record with a “Y” in the field, I get this:
ConversionException: Exception Description: The object [Y], of class [class java.lang.String], from mapping [org.eclipse.persistence.mappings.DirectToFieldMapping[retcheck--> gwtrans.RETCHECK]] with descriptor [RelationalDescriptor(com.paslists.prm.entity.GWTrans --> [DatabaseTable(gwtrans)])], could not be converted to [class java.lang.Boolean].
What am I doing wrong?