alibaba / alibaba/DataX

sqlserverWriter为什么会将字段名称自动双引号

Open
#1,687 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

```
"writer":{
"name":"sqlserverwriter",
"parameter":{
"column":[
"`name`"
],
"connection":[
{

```
报错信息:
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:test.test02 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.microsoft.sqlserver.jdbc.SQLServerException: “`”附近有语法错误。
请大佬们指教

Contributor guide

No contributing guide indexed for this repository

Research direction

Start from the sqlserverwriter configuration and the field-metadata lookup that reports the SQLServerException, reproducing it with the `name` column shown in the issue. Determine why the backtick-delimited field reaches SQL Server and document or test the expected handling once the cause is established.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.