关于 shareding jdbc 是否支持 mybatis-plus 的 ge.le,gt.lt 比较

This topic created in 1032 days ago, the information mentioned may be changed or developed.

假如有 2 张表水平分表，且分表算法如下

public class ResultPreciseShardingAlgorithm implements PreciseShardingAlgorithm<Integer> {
    @Override
    public String doSharding(Collection<String> collection, PreciseShardingValue<Integer> preciseShardingValue) {
        try {
            Integer id = preciseShardingValue.getValue();
            if (id < 8000000) {
                return "inspection_result";
            } else {
                return "inspection_result_home";
            }
        } catch (NumberFormatException e) {
            log.error("在分表时 id 转换异常");
            throw new RuntimeException(e);
        }
    }
}

在我想查询某张表中的数据时，首先想到的就是根据 id 比较

public Result<Object> testSj(){
        LambdaQueryWrapper<InspectionResult> wrapper = new LambdaQueryWrapper<>();
        wrapper.ge(InspectionResult::getId, 8000000);
        return Result.ok(inspectionResultMapper.selectList(wrapper));
    }

但是它报错了

Error querying database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :
 SELECT COUNT(1) FROM inspection_result WHERE (id >= ?)

搜了很多都没找到解释，有没有大佬解释下原因？ shareding jdbc 版本 4.1.1

6 replies • 2023-08-18 10:27:18 +08:00

lalawu

Aug 17, 2023

介意贴完整的报错堆栈吗

qinfengge

Aug 17, 2023

@lalawu 当然可以

```java
023-08-17 17:55:23,484 - 请求 /signTest/testSj 出错，请求参数{}，请求地址 127.0.0.1 ，错误信息：
### Error querying database. Cause: java.lang.UnsupportedOperationException: Cannot find range sharding strategy in sharding rule.
### The error may exist in com/jkkj/mapper/user/InspectionResultMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * FROM inspection_result WHERE (id >= ?)
### Cause: java.lang.UnsupportedOperationException: Cannot find range sharding strategy in sharding rule.
2023-08-17 17:55:23,571 - Result(code=201, message=失败, timestamp=1692266123571, data=请求 /signTest/testSj 出错，请求参数{}，错误信息：nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.UnsupportedOperationException: Cannot find range sharding strategy in sharding rule.
### The error may exist in com/jkkj/mapper/user/InspectionResultMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * FROM inspection_result WHERE (id >= ?)
### Cause: java.lang.UnsupportedOperationException: Cannot find range sharding strategy in sharding rule., ok=null)
```

wdlth

Aug 17, 2023

可以自定义一个实现 RangeShardingAlgorithm 接口的范围分片策略

qinfengge

Aug 18, 2023

看到了这个

https://blog.csdn.net/w_t_y_y/article/details/121997911?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-0-121997911-blog-106113983.235^v38^pc_relevant_default_base&spm=1001.2101.3001.4242.1&utm_relevant_index=3

lalawu

Aug 18, 2023

楼上已答，楼主你也自己找到了答案，恭喜。完整的堆栈会详细说明酒精是哪里执行有问题，比如上面堆栈表明没有对应的分片策略 ava.lang.UnsupportedOperationException: Cannot find range sharding strategy in sharding rule.

qinfengge

Aug 18, 2023

@lalawu #5 感谢大佬回答，之前粗心了没看到这个日志🤔