现象
在使用mybatisplus进行save数据保存时,出现异常。
2022-01-08 16:58:05.849 ERROR 22846 --- [nio-8081-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: Could not set property 'id' of 'class com.liubike.fw.keys.po.SingleKeyPo' with value '1479739173351813122' Cause: java.lang.IllegalArgumentException: argument type mismatch] with root cause
java.lang.IllegalArgumentException: argument type mismatch
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
原因
mybatisplus存储对象时,对象中有id字段,且ip为空时,会自动给id赋上一个long的雪花id,导致存入int类型的id数据表中,表中id为自增序列。
调整方案
增加@TableId(value = "id",type= IdType.AUTO)注解,mybatisplus就不会生成id,而交给数据库自动生成。
@Data
@TableName("lizz_test")
public class LizzTestPo {
@TableId(value = "id",type= IdType.AUTO)
private Integer id;
...
}