首页 > 其他分享 >数据类型长度问题

数据类型长度问题

时间:2022-11-24 13:33:22浏览次数:55  
标签:src 数据类型 问题 File ._ pymssql 长度 line mssql

正在处理40515行
insert into bzh_datas values('2022-04-12 08:01:32','G202010045',2,'玉溪沃森',4727774,'3416020170012022041101','谯城区观堂镇卫生院','org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExcepti','谯城区观堂镇卫生院',9,0,'23价肺炎球菌疫苗',3)
Traceback (most recent call last):
  File "src\pymssql\_pymssql.pyx", line 459, in pymssql._pymssql.Cursor.execute
  File "src\pymssql\_mssql.pyx", line 1087, in pymssql._mssql.MSSQLConnection.execute_query
  File "src\pymssql\_mssql.pyx", line 1118, in pymssql._mssql.MSSQLConnection.execute_query
  File "src\pymssql\_mssql.pyx", line 1251, in pymssql._mssql.MSSQLConnection.format_and_run_query
  File "src\pymssql\_mssql.pyx", line 1789, in pymssql._mssql.check_cancel_and_raise
  File "src\pymssql\_mssql.pyx", line 1835, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (8152, b'String or binary data would be truncated.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "insertDb.py", line 197, in <module>
    cursorX.execute(sql_insert)
  File "src\pymssql\_pymssql.pyx", line 479, in pymssql._pymssql.Cursor.execute
pymssql._pymssql.OperationalError: (8152, b'String or binary data would be truncated.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')

 

标签:src,数据类型,问题,File,._,pymssql,长度,line,mssql
From: https://www.cnblogs.com/ruiy/p/16921573.html

相关文章