<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=""}
Re: How to return columns with null values in a result map in mybatis 80 80

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.