alibaba / alibaba/DataX

使用datax读写达梦8时,遇到无法连接数据库的错误

Open
#2,304 3 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

我使用tar -zxvf解压了datax后,在rdbmsreader和rdbmswriter的libs里上传了Dm8JdbcDriver18-8.1.1.49.jar,并编辑了一个简单job:
{
"job": {
"content": [
{
"reader": {
"name": "rdbmsreader",
"parameter": {
"username": "SYSDBA",
"password": "SYSDBA",
"connection": [
{
"jdbcUrl": ["jdbc:dm://192.168.200.1:6236?schema=TEST"],
"table": ["TEST"]
}
],
"column": ["MC"],
"splitPk": ""
}
},
"writer": {
"name": "rdbmswriter",
"parameter": {
"username": "SYSDBA",
"password": "SYSDBA",
"connection": [
{
"jdbcUrl": ["jdbc:dm://192.168.200.1:5236?schema=TEST"],
"table": ["TEST"]
}
],
"column": [
"MC"
],
"preSql": ["DELETE FROM TARGET_TABLE"], // 可选
"postSql": [],
"batchSize": 1024
}
}
}
],
"setting": {
"speed": {
"channel": "1"
}
}
}
}

但是遇到报错:
2025-05-28 11:13:31.716 [job-0] WARN DBUtil - test connection of [jdbc:dm://192.168.200.1:6236?schema=TEST] failed, for Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为:dm.jdbc.driver.DMException: 网络通信异常.
2025-05-28 11:13:31.720 [job-0] ERROR RetryUtil - Exception when calling callable, 异常Msg:DataX无法连接对应的数据库,可能原因是:1) 配置的ip/port/database/jdbc错误,无法连接。2) 配置的username/password错误,鉴权失败。请和DBA确认该数据库的连接信息是否正确。
java.lang.Exception: DataX无法连接对应的数据库,可能原因是:1) 配置的ip/port/database/jdbc错误,无法连接。2) 配置的username/password错误,鉴权失败。请和DBA确认该数据库的连接信息是否正确。

我通过达梦管理工具建立连接,确定服务是没有问题的,账号密码也是复制粘贴过来的。但是就是无法通过datax连接上,请教一下应该怎么配置datax

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the DataX rdbmsreader and rdbmswriter connection configuration and compare both JDBC URLs in the posted job, including their ports, schema, and driver placement under each plugin's libs directory. Reproduce the minimal job and compare its connection settings with the working DM management-tool connection; done means the connection test succeeds and the job can read and write the specified table.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.