wewelove commented on issue #6680:
URL: https://github.com/apache/seatunnel/issues/6680#issuecomment-2120032318
已经解决, 新的配置文件如下
```json
{
"env": {
"job.name": "演示任务 Oracle-CDC-openGauss",
"job.mode": "STREAMING",
"parallelism": 1,
"checkpoint.interval": 10000
},
"source": [
{
"plugin_name": "Oracle-CDC",
"base-url": "jdbc:oracle:thin:@192.168.1.113:1521:ORCL",
"username": "system",
"password": "oracle",
"database-names": ["ORCL"],
"schema-names": ["SAKILA"],
"table-names": ["ORCL.SAKILA.CITY"],
"startup.mode": "initial",
"result_table_name": "city"
}
],
"transform": [],
"sink": [
{
"plugin_name": "Jdbc",
"url": "jdbc:postgresql://192.168.1.113:5432/demo",
"driver": "org.postgresql.Driver",
"compatible_mode": "postgresLow",
"user": "gaussdb",
"password": "Qwer@1234",
"generate_sink_sql": true,
"field_ide": "LOWERCASE",
"database": "demo",
"table": "sakila.city",
"schema_save_mode": "CREATE_SCHEMA_WHEN_NOT_EXIST",
"data_save_mode": "DROP_DATA",
"source_table_name": "city"
}
]
}
```
关键是 `source` 中的以下几个字段, 必须按照以下模式配置:
```
"base-url": "jdbc:oracle:thin:@192.168.1.113:1521:ORCL",
"database-names": ["ORCL"],
"schema-names": ["SAKILA"],
"table-names": ["ORCL.SAKILA.CITY"],
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
