-
Notifications
You must be signed in to change notification settings - Fork 291
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: sqlserver writemode 配置 update(id)报错 #1008
Comments
请贴出完整的输出日志 |
是这样的,我这边用的是您这边的sqlserverwriter 的writerMode 逻辑改的原版datax,不知是否是我这边修改的有问题,麻烦大佬给看看,非常感谢,完整日志如下:
|
本地测试无问题,过程如下:
任务执行的完整日志:
我看你的报错是说语法错误,你尝试着把 |
从你日志的输出
来看,是 正确的拼接语句应该是
所以检查你的分析 |
嗯嗯,应该是这个问题,我看一下,多谢大佬,非常感谢 |
What happened?
sqlserver version:
Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64)
Dec 4 2023 14:44:16
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 20.04.6 LTS)
error info:
2024-02-06 16:48:52.498 [0-0-0-writer] ERROR StdoutPluginCollector -
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-9.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632) ~[mssql-jdbc-9.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602) ~[mssql-jdbc-9.2.1.jre8.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) ~[mssql-jdbc-9.2.1.jre8.jar:na]
Version
4.1.3 (Default)
OS Type
No response
Java JDK Version
Oracle JDK 1.8.0
Relevant log output
No response
The text was updated successfully, but these errors were encountered: