I am just trying to map a boolean value with Mybatis, but I am having a problem. Firstly, I'll show you the parts involved:
XML File:
<resultMap id="destinationTypeMap" type="DestinationTypeDTO">
<result property="destinationTypeId" column="education_destination_type_id" javaType="java.lang.Long" jdbcType="NUMERIC"/>
<result property="description" column="description" javaType="java.lang.String" jdbcType="VARCHAR"/>
<result property="available" column="is_available" javaType="boolean" jdbcType="VARCHAR" typeHandler="BooleanHandler"/>
</resultMap>
Java class:
public class DestinationTypeDTO {
private long destinationTypeId;
private String description;
private boolean available;
public long getDestinationTypeId() {
return destinationTypeId;
}
public void setDestinationTypeId(long destinationTypeId) {
this.destinationTypeId = destinationTypeId;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public boolean isAvailable() {
return available;
}
public void setAvailable(boolean available) {
this.available = available;
}
}
But, I am getting this error log:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: Could not set property 'isAvailable' of '....DestinationTypeDTO@bbd76bf' with value 'true' Cause: org.apache.ibatis.reflection.ReflectionException: There is no setter for property named 'isAvailable' in 'class ....DestinationTypeDTO'
I spent hours trying to find what's going on but without success. Any hint?
Thanks everyone.
Change javaType="boolean"
to java.lang.Boolean
and specify property="available"
<result property="available" column="is_available" property="available" javaType="java.lang.Boolean" jdbcType="VARCHAR" typeHandler="BooleanHandler"/>
In your class change private boolean available;
to private Boolean isAvailable;
and add getter/setter
public void setIsAvailable(Boolean available) {
this.available = available;
}
public Boolean getIsAvailable() {
return available;
}