yinshaohua77 commented on PR #5196:
URL: https://github.com/apache/seatunnel/pull/5196#issuecomment-1854952687
thinks a lot ， here is my config, I give user roma_logminer dba and any
other right， please help me
env {
execution.parallelism = 1
job.mode = "STREAMING"
}
source {
Oracle-CDC {
result_table_name = "stock_mysql"
catalog = {
factory = Oracle
}
username = "roma_logminer"
password = "xxxxxx"
database-names = ["DB220"]
schema-names = ["ORACLE"]
table-names = ["ORACLE.ACC_USER_BIND"]
base-url = "jdbc:oracle:thin:roma_logminer/[email protected]:1521:db220"
source.reader.close.timeout = 120000
connection.pool.size = 5
debezium {
database.oracle.jdbc.timezoneAsRegion = "false"
}
}
}
sink {
Console {
}
}
report error
Exception in thread "main"
org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel
job executed failed
at
org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:192)
at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
at
org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34)
Caused by: org.apache.seatunnel.api.table.factory.FactoryException:
ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to
create a source for identifier 'Oracle-CDC'.
at
org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:100)
at
org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:312)
at
org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:180)
at
org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:88)
at
org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:161)
at
org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:144)
... 2 more
Caused by: org.apache.seatunnel.common.utils.SeaTunnelException: Can not
find catalog table with factoryId [Oracle]
at
org.apache.seatunnel.api.table.catalog.CatalogTableUtil.lambda$getCatalogTables$0(CatalogTableUtil.java:129)
at java.util.Optional.map(Optional.java:215)
at
org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:116)
at
org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:96)
at
org.apache.seatunnel.connectors.seatunnel.cdc.oracle.source.OracleIncrementalSourceFactory.lambda$createSource$0(OracleIncrementalSourceFactory.java:103)
at
org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:112)
at
org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:73)
--
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]
