报错123

最新推荐文章于 2025-05-09 16:34:59 发布

Flechazow

最新推荐文章于 2025-05-09 16:34:59 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

文章标签： servlet java 数据库

本文链接：https://blog.youkuaiyun.com/Flechazow/article/details/126252254

在尝试使用pyhdb库执行SQL语句时遇到错误，详细堆栈信息显示为'sql syntax error: incorrect syntax near "%"，同时伴随着类型错误：not all arguments converted during string formatting。这可能是由于SQL语句中的占位符未正确替换导致。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Traceback (most recent call last):
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\cursor.py", line 271, in executemany
statement_id = self.prepare(statement)
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\cursor.py", line 152, in prepare
response = self.connection.send_request(request)
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\connection.py", line 84, in send_request
return self.__send_message_recv_reply(payload.getvalue())
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\connection.py", line 124, in __send_message_recv_reply
return ReplyMessage.unpack_reply(header, payload)
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\protocol\message.py", line 92, in unpack_reply
segments=tuple(ReplySegment.unpack_from(payload, expected_segments=header.num_segments)),
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\protocol\segments.py", line 152, in unpack_from
raise error.parts[0].errors[0]
pyhdb.exceptions.DatabaseError: sql syntax error: incorrect syntax near "%": line 1 col 157 (at pos 157)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\cursor.py", line 35, in format_operation
operation = operation % e_values
TypeError: not all arguments converted during string formatting

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:/users/w/PycharmProjects/pythonProject/insertMysqlAutoOrtData.py", line 48, in <module>
write_item(item)
File "D:/users/w/PycharmProjects/pythonProject/insertMysqlAutoOrtData.py", line 28, in write_item
cursor.executemany(sql, item)
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\cursor.py", line 279, in executemany
operation = format_operation(statement, row_params)
File "D:\users\w\PycharmProjects\pythonProject\venv\lib\site-packages\pyhdb\cursor.py", line 39, in format_operation
raise ProgrammingError(str(msg))
pyhdb.exceptions.ProgrammingError: not all arguments converted during string formatting