Cannot invoke method xxx() on null object

最近在学习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

原因

分片键和分片策略中的字段不一致导致

 

分片策略是基于分片键进行运算的

早年同窗始相知,三载瞬逝情却萌。年少不知愁滋味,犹读红豆生南国。别离方知相思苦,心田红豆根以生。
原文地址:https://www.cnblogs.com/shanheyongmu/p/15540309.html