求教：example 动态sql 查询抛异常 。感谢：）

[guan25]

Error querying database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_3'. It was either not specified and/or could not be found for the javaType ([Ljava.lang.Integer;) : jdbcType (null) combination.

Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_3'. It was either not specified and/or could not be found for the javaType ([Ljava.lang.Integer;) : jdbcType (null) combination.] with root cause

java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_3'. It was either not specified and/or could not be found for the javaType ([Ljava.lang.Integer;) : jdbcType (null) combination. at org.apache.ibatis.mapping.ParameterMapping$Builder.validate(ParameterMapping.java:119) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.mapping.ParameterMapping$Builder.build(ParameterMapping.java:104) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:123) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:67) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:45) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:44) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292) ~[mybatis-3.4.6.jar:3.4.6] at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:83) ~[pagehelper-5.1.4.jar:na] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.4.6.jar:3.4.6] at com.sun.proxy.$Proxy176.query(Unknown Source) ~[na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar:3.4.6] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar:1.3.2] at com.sun.proxy.$Proxy113.selectList(Unknown Source) ~[na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-1.3.2.jar:1.3.2] at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) ~[mybatis-3.4.6.jar:3.4.6] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.6.jar:3.4.6] at com.sun.proxy.$Proxy122.selectByExample(Unknown Source) ~[na:na]

代码如下：=================================

for(){ ..... //拼接example，动态sql switch (type) { case EQURE: criteria.andEqualTo(columnName, proValue); break; case NOTEQURE: criteria.andNotEqualTo(columnName, proValue); break; case LIKE: if (proValue instanceof String) { criteria.andLike(columnName, "%" + proValue + "%"); } break; case RANGE:

                    Column ca = (Column) poClass.getDeclaredField(proName).getAnnotation(Column.class);
                    //获取表字段名
                    String cn = Optional.ofNullable(ca).map(va -> va.name()).orElse(proName);

                    if (proValue instanceof String) {
                        StringBuilder stringBuilder=new StringBuilder(cn);
                        if(((String) proValue).indexOf(",")!=-1) {
                            String[] s = ((String) proValue).split(",");
                            if (StringUtils.isEmpty(s[0]) && StringUtils.isNotEmpty(s[1])) {
                                stringBuilder.append("<=").append(s[1]);
                            } else if (StringUtils.isNotEmpty(s[0]) && s.length == 1) {
                                stringBuilder.append(">=").append(s[0]);
                            } else {
                                stringBuilder.append(" between ").append(s[0]).append(" and ").append(s[1]);
                            }
                        }
                        criteria.andCondition(stringBuilder.toString());
                    }
                    /*  此处与通用mapper的类型不匹配
                    if (proValue instanceof String) {
                        String[] s = ((String) proValue).split(",");
                        if (StringUtils.isEmpty(s[0]) && StringUtils.isNotEmpty(s[1])) {
                            criteria.andLessThanOrEqualTo(columnName, s[1]);
                            criteria.andCondition()
                        } else if (StringUtils.isNotEmpty(s[0]) && s.length == 1) {
                            criteria.andGreaterThanOrEqualTo(columnName, s[0]);
                        } else {
                            criteria.andBetween(columnName, s[0], s[1]);
                        }
                    }
                    */
                    break;
                case LIST:
                    if (proValue.getClass().isArray()) {
                        criteria.andIn(columnName, Arrays.asList(proValue));
                    } else if (proValue instanceof List) {
                        criteria.andIn(columnName, (List) proValue);
                    }
                    break;

... }

..... if (order.getOrderType().equals(FilterWrapper.ORDER_TYPE_ASC)) { if (Optional.ofNullable(orderBy).isPresent()) { orderBy = orderBy.orderBy(orderName).asc(); } else { orderBy = example.orderBy(orderName).asc(); }

                } else {
                    if (Optional.ofNullable(orderBy).isPresent()) {
                        orderBy = orderBy.orderBy(orderName).desc();
                    } else {
                        orderBy = example.orderBy(orderName).desc();
                    }
                }

..... return secondHouseMapper.selectByExample(example);

[guan25]

追踪到mybatis里面：发现 TypeHandler 为空，对应的过滤条件是List类型（采用通用mapper generator生成的配置） --- 应该如何修改

[abel533]

proValue 是什么值的时候出的问题？

[guan25]

@abel533 是数组的时候出问题，如果是List就不会有问题，难道用Arrays.asList 引起的，但array并没有使用基本类型 谢谢

[fallsea]

有解决方案吗，同样遇到此问题

[fallsea]

我这边测试，只要第一次没有执行Example.Criteria 组装的条件，后面都可以查询成功，没有异常，第一次执行有条件，就可能会失败，不是必然的 @abel533

[fallsea]

已经解决了，参数只传example对象就没问题，传list，有时会有问题，有时正常

[wysnxzm]

WeekendSqls使用andIn()查询存在相同问题,更换为Example andIn()后正常

Error querying database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_4'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.

Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_4'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.

[wysnxzm]

WeekendSqls使用andIn()查询存在相同问题,更换为Example andIn()后正常

Error querying database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_4'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.

Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_listItem_4'. It was either not specified and/or could not be found for the javaType / jdbcType combination specified.

请教@abel533 后,我的问题已解决 是由于int[]被识别为类而不是数组导致的问题,改为Integer[]后解决