spring boot项目报错:Cannot determine value type from string 'xxxxxx’
完整报错信如下:
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception
[Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
Error attempting to get column 'name' from result set.
Cause: java.sql.SQLDataException: Cannot determine value type from string '张三';
Cannot determine value type from string '张三';
nested exception is java.sql.SQLDataException:
Cannot determine value type from string '张三'] with root cause
原因分析:
经测试:
当如下情况:实体类创建了一个参数不完整 的构造方法(具有完整参数 的构造方法不会报错!),而没有为此创建一个无参的构造方法时,就会报次错误。
@Data
public class User {
private int id;
private String name;
private int age;
public User( String name, int age) {
this.name = name;
this.age = age;
}
}
解决问题:
再添加一个无参的构造方法,问题解决。代码修改为:
@Data
public class User {
private int id;
private String name;
private int age;
//Cannot determine value type from string '张三'] with root cause
public User() {
}
public User(String name, int age) {
this.name = name;
this.age = age;
}
}