问题
最近在学习shardingsphere分库分表,基于springboot框架,但是运行项目的时候,报个错:
Cannot invoke method mod() on null object] with root cause
全部错误信息如下
[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
原因
分片键和分片策略中的字段不一致导致
分片策略是基于分片键进行运算的