最近在学习shardingsphere分库分表,基于springboot框架,但是运行项目的时候,报个错:
全部错误信息如下
[Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.lang.NullPointerException: Cannot invoke method mod() on null object ### The error may exist in com/yangy/shardingsphere/mapper/UserMapper.java (best guess) ### The error may involve com.yangy.shardingsphere.mapper.UserMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO yang_user ( name, age, sex ) VALUES ( ?, ?, ? ) ### Cause: java.lang.NullPointerException: Cannot invoke method mod() on null object] with root cause
原因
分片键和分片策略中的字段不一致导致
分片策略是基于分片键进行运算的