错误排查：Caused by: org.apache.ibatis.exceptions.PersistenceException

淡淡的烟草味﹌ 2022-12-28 04:13 88阅读 0赞

### 错误提示： ###

[aad8bbfc419f1d20]Caused by: org.apache.ibatis.exceptions.PersistenceException: 
    [aad8bbfc419f1d20]### Error querying database.  Cause: java.lang.NullPointerException: target is null for method size
    [aad8bbfc419f1d20]### Cause: java.lang.NullPointerException: target is null for method size

### 排查： ###

空指针肯定是某个属性没绑定上

<select id="findRepertoryDayTotal" resultType="int">
            select
            count(*)
            from cluster_sams.app_sams_cloud_item_inventory_days_d
            <where>
                
                <if test="(repertoryDateStart == null or repertoryDateStart == '') or (repertoryDateEnd == null or repertoryDateEnd == '')">
                    and event_date between yesterday() and today()
                </if>
                
                <if test="(repertoryDateStart != null and repertoryDateStart != '') and (repertoryDateEnd != null and repertoryDateEnd != '')">
                    and event_date between #{repertoryDateStart} and #{repertoryDateEnd}
                </if>
                
                <if test="itemNumber != null and itemNumber.size() != 0">
                    and item_nbr in
                    <foreach collection="itemNumber" item="item" open="(" close=")" separator="," index="index">
                        #{item}
                    </foreach>
                </if>
                
                <if test="cities != null and cities.size() != 0">
                    and storage_city_cn in
                    <foreach collection="cities" item="city" open="(" close=")" separator="," index="index">
                        #{city}
                    </foreach>
                </if>
                
                <if test="stores != null and stores.size() != 0">
                    and store_id in
                    <foreach collection="stores" item="storeId" open="(" close=")" separator="," index="index">
                        #{storeId}
                    </foreach>
                </if>
                
                <if test="positions != null and position.size() != 0">
                    and position in
                    <foreach collection="position" item="pos" open="(" close=")" separator="," index="index">
                        #{pos}
                    </foreach>
                </if>
                
                <if test="divisions != null and divisions.size() != 0">
                    and division in
                    <foreach collection="divisions" item="div" open="(" close=")" separator="," index="index">
                        #{div}
                    </foreach>
                </if>
                
                <if test="category != null and category.size() != 0">
                    and category in
                    <foreach collection="category" item="cate" open="(" close=")" separator="," index="index">
                        #{cate}
                    </foreach>
                </if>
            </where>
        </select>

排查了一下 postions漏了一个s

### 解决 ###

仔细排查一下，是不是某个属性，写错了或者某个条件写错了，导致无法获取绑定属性。