异常如下:原因是由于某一个字段由于建表时分心,长度为0;
将其修改后程序运行正常
2021-04-12 16:14:30.951 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
2021-04-12 16:14:30.972 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@412e8fd]
2021-04-12 16:14:31.176 [http-nio-8080-exec-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.jdbc.JDBC4Connection@13c4a657]]] will be managed by Spring
2021-04-12 16:14:31.233 [http-nio-8080-exec-2] DEBUG com.hy.software.mapper.SoftwareMapper.addSoftware - ==> Preparing: insert into t_software ( id, name , tenentid , packet_size , details , sd_version , sd_url , status , sd_order , logo , qr_code , create_date , sd_type ) values ( ? ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2021-04-12 16:14:31.603 [http-nio-8080-exec-2] DEBUG com.hy.software.mapper.SoftwareMapper.addSoftware - ==> Parameters: 8e13b6a9be8d41dcb7cb0af155748df5(String), 小兔1.img(String), th.cmcc.cn(String), 0(Integer), 测试13(String), 1.2.3(String), 1.2.3(String), 1(Integer), 1(String), 123.img(String), IMPerweima(String), 2021-04-12 16:14:23.914(Timestamp), 1(String)
2021-04-12 16:14:31.628 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@412e8fd]
2021-04-12 16:14:31.645 [http-nio-8080-exec-2] INFO o.s.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2021-04-12 16:14:31.880 [http-nio-8080-exec-2] INFO o.s.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
2021-04-12 16:14:34.356 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@412e8fd]
2021-04-12 16:14:34.357 [http-nio-8080-exec-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@412e8fd]