[Bug] [Oracle-CDC] Can not find catalog table with factoryId [Oracle] #6680
Labels
Comments
|
The new configuration after modifying the source code ，It is a table without primary key @hailin0 |
|
Oracle version 12c，not have cdb |
|
I think it is the table name configuration that is wrong, not the code |
|
Would you mind referring to the configuration of oracle cdc e2e |
|
oracle-cdc jdbc url 需要使用 sid的方式配置 |
|
遇到同样的问题，找到解决方案了吗 |
oracle-cdc jdbc url 需要使用 sid的方式配置 |
|
2.3.5版本遇到同样问题, 配置如下 {
"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": ["SAKILA"],
"table-names": ["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"
}
]
}
|
|
已经解决, 新的配置文件如下 {
"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"
}
]
}关键是 |
3 tasks
NeoGitCrt1
pushed a commit
to NeoGitCrt1/seatunnel
that referenced
this issue
Jul 25, 2024
Oracle CDC : Can not find catalog table with factoryId [Oracle]
NeoGitCrt1
pushed a commit
to NeoGitCrt1/seatunnel
that referenced
this issue
Jul 25, 2024
Oracle CDC : Can not find catalog table with factoryId [Oracle]
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Search before asking
What happened
Oracle-CDC sink Doris，
The following exception occurs
I checked the source code and found that there was an issue with the matching rule of TablePath. After modifying the source code and deploying it, a new error occurred，see details [Error Exception]
SeaTunnel Version
2.3.4
SeaTunnel Config
Running Command
Error Exception
Zeta or Flink or Spark Version
Zeta 2.3.4
Java or Scala Version
1.8
Screenshots
No response
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: