DTStack / DTStack/chunjun

[Question] oraclecdc到MySQL,已经获取到数据了,还提示表不存在

Open
#1,481 5 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [ ] I had searched in the [issues](https://github.com/DTStack/chunjun/issues) and found no similar question.

- [X] I had googled my question but i didn't get any help.

- [X] I had read the documentation: [ChunJun doc](https://dtstack.github.io/chunjun) but it didn't help me.

### Description

json文件配置如下:
```
{
"job": {
"content": [
{
"reader": {
"parameter": {
"jdbcUrl": "jdbc:oracle:thin:@192.168.10.189:1521:helowin",
"username": "system",
"password": "system",
"supportAutoAddLog": false,
"table": ["TEST.T_CDC_TEST3"],
"cat": "UPDATE,INSERT,DELETE",
"split":true,
"readPosition": "CURRENT",
"queryTimeout": 3000
},
"name": "oraclelogminerreader"
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"username": "root",
"password": "",
"connection": [
{
"jdbcUrl": "jdbc:mysql://192.168.10.128:3306/aaa?useSSL=false&allowPublicKeyRetrieval=true",
"table": [
"t_cdc_test"
]
}
],
"writeMode": "insert",
"column": [
{
"name": "id",
"type": "int"
},
{
"name": "task_name",
"type": "string"
},
{
"name": "task_info",
"type": "string"
},
{
"name": "collect_table",
"type": "string"
}
]
}
}
}
],
"setting": {
"errorLimit": {
"record": 100
},
"speed": {
"bytes": 0,
"channel": 1,
"readerChannel": 1,
"writerChannel": 1
}
}
}
}
```
![微信图片_20230110104416](https://user-images.githubusercontent.com/122013759/211450302-a4d5f48f-1f59-4f2f-ba1c-7ef9f17b44d7.png)
![微信图片_20230110104608](https://user-images.githubusercontent.com/122013759/211450311-29b369a5-5036-4354-94ac-db68393b8f18.png)
![微信图片_20230110104613](https://user-images.githubusercontent.com/122013759/211450313-ddc4cdf3-c6eb-48a0-8661-21735aa2bf22.png)

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.