springboot 集成mybatis-plus异常 MybatisPlusException: can not find lambda cache for this property [*]

旧城等待， 2022-12-08 05:29 754阅读 0赞

# 当前mybatis-plus 版本为3.3.2 #

<dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.3.2</version>
            </dependency>

## 1.执行方法代码，多表关联分页查询 ##

@RequestMapping(value ="/selectPageByPressLambdaWrapper" , method = RequestMethod.GET,produces = {"application/json;charset=UTF-8"})
        public IPage<PressInfoEntity> selectPageByPressLambdaWrapper(){
            LambdaQueryWrapper<PressInfoEntity> queryWrapper = new QueryWrapper<PressInfoEntity>().lambda();
            queryWrapper.like(PressInfoEntity::getShortPress,"版");
            //使用非当前表内字段做查询
            //异常  can not find lambda cache for this property [name] of entity[com.test.mybatisplus.entity.PressInfoEntity]
            queryWrapper.like(PressInfoEntity::getName,"测试");
    
            Page<PressInfoEntity> page=new Page<>(1,5);
            IPage<PressInfoEntity> iPage=   pressInfoService.selectPageByPressLambdaWrapper(page,queryWrapper);
            return  iPage;
        }

![2020091815590012.png][]中name不在t\_press\_info的表中,使用

@TableField(exist = false)  
        private String name;

## 2. Entity ##

@Data
    @Builder
    @NoArgsConstructor
    @AllArgsConstructor
    @TableName(value="t_press_info")
    public class PressInfoEntity {
            @TableId
            private int id;
    
            @TableField(value = "short_press")
            private String shortPress;
    
            @TableField(value = "press")
            private String press;
    
            @TableField(value = "create_time")
            private Date createTime;
    
            @TableField(value = "update_time")
            private Date updateTime;
    
            /**非当前表字段*/
            /*@Builder  若有非当前表字段，得注意类构造函数
            @NoArgsConstructor
            @AllArgsConstructor*/
            @TableField(exist = false)
            private String name;
    }

## 3、异常 ##

com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: can not find lambda cache for this property [name] of entity [com.test.mybatisplus.entity.PressInfoEntity]
    	at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:49) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.toolkit.Assert.isTrue(Assert.java:38) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.toolkit.Assert.notNull(Assert.java:72) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.conditions.AbstractLambdaWrapper.getColumn(AbstractLambdaWrapper.java:87) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.conditions.AbstractLambdaWrapper.columnToString(AbstractLambdaWrapper.java:63) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.conditions.AbstractLambdaWrapper.columnToString(AbstractLambdaWrapper.java:59) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.conditions.AbstractLambdaWrapper.columnToString(AbstractLambdaWrapper.java:39) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at com.baomidou.mybatisplus.core.conditions.AbstractWrapper.lambda$likeValue$17384082$1(AbstractWrapper.java:344) ~[mybatis-plus-core-3.3.2.jar:3.3.2]
    	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) ~[na:1.8.0_211]
    	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) ~[na:1.8.0_211]
    	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[na:1.8.0_211]
    	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[na:1.8.0_211]
    	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[na:1.8.0_211]
    	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:1.8.0_211]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70][]

## 4、原因 ##

## 根据异常debug定位到 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1][]

### 根据获取到的columnMap，定位何处初始化的这个map， ###

### 在LambdaUtils.java初始化map数据逇时候只会把存在表中的字段丢进去。 ###

![20200918162213297.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2][]

private static Map<String, ColumnCache> createColumnCacheMap(TableInfo info) {
            Map<String, ColumnCache> map = new HashMap();
            String kp = info.getKeyProperty();
            if (StringUtils.isNotBlank(kp)) {
                map.put(formatKey(kp), new ColumnCache(info.getKeyColumn(), info.getKeySqlSelect()));
            }
    
            info.getFieldList().forEach((i) -> {
                ColumnCache var10000 = (ColumnCache)map.put(formatKey(i.getProperty()), new ColumnCache(i.getColumn(), i.getSqlSelect()));
            });
            return map;
        }

## 5、解决方案  ##

1. 不使用LambdaQueryWrapper

使用QueryWrapper

QueryWrapper<PressInfoEntity> queryWrapper = new QueryWrapper<PressInfoEntity>();
     queryWrapper.like("t.short_press","版");
     queryWrapper.like("t1.name","测试");
     IPage<PressInfoEntity> iPage=   pressInfoService.selectPageByPressWrapper(page,queryWrapper);

推荐常规写法

PressInfoEntity pressInfoEntity = PressInfoEntity.builder().press(press).build();       
     Page<PressInfoEntity> page=new Page<>(1,5);
     IPage<PressInfoEntity> iPage=   pressInfoService.selectPageByEntity(page,pressInfoEntity); 
     #sql和mybatis一样就好
      select t.*,t1.name from t_press_info t
            left join t_press t1 on t.id=t1.press_info_id
            <where> t.short_press like CONCAT('%',#{et.shortPress},'%')  </where>

[2020091815590012.png]: /images/20221123/1544686a858240abb2889eab023b0cf9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70]: /images/20221123/ff3a6ad421234188a5e32a253ce1a629.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1]: /images/20221123/323dae3bcebb4254a7e1a643c40d1737.png
[20200918162213297.png]: /images/20221123/27f81c32b9e24984ac2cc1588159e4a8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2]: /images/20221123/c699ec3923c0482ea47cfa0b5706bbe9.png