SqlExceptionHelper: String or binary data would be truncated.

sqlserver

SqlExceptionHelper: SQL Error: 8152, SQLState: 22001

SqlExceptionHelper: String or binary data would be truncated.

 

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement

 

Caused by: org.hibernate.exception.DataException: could not execute statement

字符串被截断，日志里却没有显示具体异常字段，打印数据即可看出

解决：

alter table tablename alter column columnname varchar(255)