Search code examples
javaormmybatisibatis

How to return columns with null values in a result map in mybatis

<select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map">
SELECT  ID, SUM(VALUE1 + VALUE2) Total
FROM    tableName
GROUP   BY ID
    </select>

Returns below result in sql

ID, Total
1   (null)

But when returned in Map result in myBatis returns {ID=1} where as Total is missing. How to get the column with null into the result set as well something like this {ID=1,Total=null} or something like this {ID=1,Total=""}

Solution

  • Adding 

    <settings>
<setting name="callSettersOnNulls" value="true"/>
</settings>

    mybatis-config.xml fixes the issue if using mybatis 3.2 + version