alibaba / alibaba/DataX

请问支持人大金仓数据库么?

Open
#531 12 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

我按说明用rdbmswriter,然后把jdbc驱动丢到 datax\plugin\writer\rdbmswriter\libs 下面
然后plugin.json 改成
{
"name": "rdbmswriter",
"class": "com.alibaba.datax.plugin.reader.rdbmswriter.RdbmsWriter",
"description": "useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.",
"developer": "alibaba",
"drivers":["dm.jdbc.driver.DmDriver", "com.sybase.jdbc3.jdbc.SybDriver", "com.edb.Driver", "com.kingbase.Driver"]
}

我生成的job json如下:
"writer": {
"parameter": {
"password": "1234",
"column": ["Data_Store_Id", "Data_Store_Nm", "Data_Store_Type_Id", "Data_Store_Param", "Data_Srcid", "Tnmtid", "Data_Store_Dev_Id", "Data_Store_Status", "Create_Dt", "Update_Dt"],
"connection": [{
"jdbcUrl": "jdbc:kingbase://127.0.0.1:54321/kingbase",
"table": ["o_bj01_000_data_store"]
}],
"username": "SYSTEM"
},
"name": "rdbmswriter"
}

======================
执行的时候
Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为:java.sql.SQLException: No suitable driver found for jdbc:kingbase://127.0.0.1:54321/kingbase

2019-12-09 10:19:27.108 [job-0] ERROR RetryUtil - Exception when calling callable, 即将尝试执行第1次重试.本次重试计划等待[1000]ms,实际等待[1001]ms, 异常Msg:[Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为:java.sql.SQLException: No suitable driver found for jdbc:kingbase://127.0.0.1:54321/kingbase]

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the rdbmswriter plugin.json and the driver JAR under datax/plugin/writer/rdbmswriter/libs, then inspect how the JDBC driver list is loaded for the job JSON shown. Reproduce the jdbc:kingbase connection and investigate the reported “No suitable driver” error. Done means establishing whether Kingbase is supported and documenting or verifying the required configuration.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.