mybatis关联查询,发送额外sql时,出现的bug及解决分析(SSM项目)

进行关联查询,发送额外sql时,报错如下:

org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [mvc] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.http.converter.HttpMessageConversionException: Type definition error: [simple type, class org.apache.ibatis.executor.loader.javassist.JavassistProxyFactory$EnhancedResultObjectProxyImpl]; nested exception is com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class org.apache.ibatis.executor.loader.javassist.JavassistProxyFactory$EnhancedResultObjectProxyImpl and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: java.util.ArrayList[0]->cn.czw.trip.core.domain.Destination_$$_jvst598_0["children"]->java.util.ArrayList[0]->cn.czw.trip.core.domain.Destination_$$_jvst598_0["handler"])] with root cause

com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class org.apache.ibatis.executor.loader.javassist.JavassistProxyFactory$EnhancedResultObjectProxyImpl and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: java.util.ArrayList[0]->cn.czw.trip.core.domain.Destination_$$_jvst598_0["children"]->java.util.ArrayList[0]->cn.czw.trip.core.domain.Destination_$$_jvst598_0["handler"])

at com.fasterxml.jackson.databind.exc.InvalidDefinitionException.from(InvalidDefinitionException.java:77)

通过分析报错信息,发现使用mybatis的延时加载功能时,对应实体类会被mybatis动态代理,代理之后会在动态代理类加多handler字段(属性),无法转为json

解决方案:1.关闭mybatis延时加载功(懒加载)2.在实体类上贴注解@JsonIgnoreProperties("handler"),忽略掉handler字段