Open YohLee opened 4 years ago
spring.datasource.url=jdbc:mysql://localhost:3306/conweb?sessionVariables=sql_mode='NO_ENGINE_SUBSTITUTION'&jdbcCompliantTruncation=false
---添加jdbcCompliantTruncation=false后不报错,但是插入数据库中内容不完整,需要 alter table tb_task modify column TASK_PARAM MediumText;
参考:https://stackoverflow.com/questions/13567155/com-mysql-jdbc-mysqldatatruncation-data-truncation-data-too-long-for-column-c
spring.datasource.url=jdbc:mysql://localhost:3306/conweb?sessionVariables=sql_mode='NO_ENGINE_SUBSTITUTION'&jdbcCompliantTruncation=false
---添加jdbcCompliantTruncation=false后不报错,但是插入数据库中内容不完整,需要 alter table tb_task modify column TASK_PARAM MediumText;
参考:https://stackoverflow.com/questions/13567155/com-mysql-jdbc-mysqldatatruncation-data-truncation-data-too-long-for-column-c