zhouhanker opened a new issue, #9390: URL: https://github.com/apache/seatunnel/issues/9390
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened oracle version 19c seatunnel version 2.3.10 I want to read oracle data test, this oracle db is new install ### SeaTunnel Version 2.3.10 ### SeaTunnel Config ```conf env { parallelism = 4 job.mode = "BATCH" } source{ Jdbc { url = "jdbc:oracle:thin:@ipaddr:1521:orcl" driver = "oracle.jdbc.OracleDriver" connection_check_timeout_sec = 100 partition_column = "STAT_DAY" partition_num = 10 user = "system" password = "orcl" query = "select * from SYSTEM.ttt" properties { database.oracle.jdbc.timezoneAsRegion = "false" } } } transform { } sink { Console {} } ``` ### Running Command ```shell seatunnel.sh -c sync_oracle19c_to_xxx.conf ``` ### Error Exception ```log 2025-06-03 11:06:56,414 INFO [o.a.s.c.s.u.ConfigBuilder ] [main] - Parsed config file: { "env" : { "parallelism" : 4, "job.mode" : "BATCH" }, "source" : [ { "url" : "jdbc:oracle:thin:@11.130.70.19:1521:orcl", "driver" : "oracle.jdbc.OracleDriver", "user" : "system", "password" : "******", "query" : "select * from SYSTEM.ttt", "plugin_name" : "Jdbc" } ], "transform" : [], "sink" : [ { "plugin_name" : "Console" } ] } 2025-06-03 11:06:56,419 INFO [p.MultipleTableJobConfigParser] [main] - add common jar in plugins :[] 2025-06-03 11:06:56,434 INFO [.s.p.d.AbstractPluginDiscovery] [main] - Load SeaTunnelSink Plugin from /opt/soft/seatunnel-2.3.10/connectors 2025-06-03 11:06:56,437 INFO [.s.p.d.AbstractPluginDiscovery] [main] - Discovery plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='source', pluginName='Jdbc'} at: file:/opt/soft/seatunnel-2.3.10/connectors/connector-jdbc-2.3.10.jar 2025-06-03 11:06:56,443 INFO [.s.p.d.AbstractPluginDiscovery] [main] - Load SeaTunnelSink Plugin from /opt/soft/seatunnel-2.3.10/connectors 2025-06-03 11:06:56,448 INFO [.s.p.d.AbstractPluginDiscovery] [main] - Load SeaTunnelSink Plugin from /opt/soft/seatunnel-2.3.10/connectors 2025-06-03 11:06:56,449 INFO [.s.p.d.AbstractPluginDiscovery] [main] - Discovery plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='sink', pluginName='Console'} at: file:/opt/soft/seatunnel-2.3.10/connectors/connector-console-2.3.10.jar 2025-06-03 11:06:56,452 INFO [p.MultipleTableJobConfigParser] [main] - start generating all sources. 2025-06-03 11:06:56,498 INFO [o.a.s.c.s.j.u.JdbcCatalogUtils] [main] - Loading catalog tables for catalog : class org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.oracle.OracleCatalog 2025-06-03 11:06:56,513 INFO [.s.c.s.j.c.AbstractJdbcCatalog] [main] - Catalog Oracle closing 2025-06-03 11:06:56,514 INFO [c.h.c.LifecycleService ] [main] - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is SHUTTING_DOWN 2025-06-03 11:06:56,517 INFO [.c.i.c.ClientConnectionManager] [main] - hz.client_1 [seatunnel] [5.1] Removed connection to endpoint: [cdh02]:5802:64ea5dbf-09db-48e5-9952-05d8fe4f4f2e, connection: ClientConnection{alive=false, connectionId=2, channel=NioChannel{/10.160.60.13:54697->cdh02/10.160.60.12:5802}, remoteAddress=[cdh02]:5802, lastReadTime=2025-06-03 11:06:56.278, lastWriteTime=2025-06-03 11:06:56.278, closedTime=2025-06-03 11:06:56.515, connected server version=5.1} 2025-06-03 11:06:56,518 INFO [.c.i.c.ClientConnectionManager] [main] - hz.client_1 [seatunnel] [5.1] Removed connection to endpoint: [cdh03]:5801:ebac6444-d4a1-4a58-b868-29cc99cd23ba, connection: ClientConnection{alive=false, connectionId=1, channel=NioChannel{/127.0.0.1:60837->localhost/127.0.0.1:5801}, remoteAddress=[cdh03]:5801, lastReadTime=2025-06-03 11:06:56.277, lastWriteTime=2025-06-03 11:06:56.277, closedTime=2025-06-03 11:06:56.517, connected server version=5.1} 2025-06-03 11:06:56,519 INFO [.c.i.c.ClientConnectionManager] [main] - hz.client_1 [seatunnel] [5.1] Removed connection to endpoint: [cdh01]:5802:6aab2cf3-76d4-403e-853a-3cfc9abb6324, connection: ClientConnection{alive=false, connectionId=3, channel=NioChannel{/10.160.60.13:56632->cdh01/10.160.60.11:5802}, remoteAddress=[cdh01]:5802, lastReadTime=2025-06-03 11:06:56.156, lastWriteTime=2025-06-03 11:06:56.155, closedTime=2025-06-03 11:06:56.518, connected server version=5.1} 2025-06-03 11:06:56,519 INFO [c.h.c.LifecycleService ] [main] - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is CLIENT_DISCONNECTED 2025-06-03 11:06:56,529 INFO [c.h.c.LifecycleService ] [main] - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is SHUTDOWN 2025-06-03 11:06:56,529 INFO [s.c.s.s.c.ClientExecuteCommand] [main] - Closed SeaTunnel client...... 2025-06-03 11:06:56,529 ERROR [o.a.s.c.s.SeaTunnel ] [main] - =============================================================================== 2025-06-03 11:06:56,529 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Fatal Error, 2025-06-03 11:06:56,529 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Please submit bug report in https://github.com/apache/seatunnel/issues 2025-06-03 11:06:56,529 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Reason:SeaTunnel job executed failed 2025-06-03 11:06:56,530 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Exception StackTrace:org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228) 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 'Jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:168) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:86) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:376) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:227) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: org.apache.seatunnel.api.table.catalog.exception.CatalogException: ErrorCode:[API-03], ErrorDescription:[Catalog initialize failed] - Failed connecting to jdbc:oracle:thin:@10.160.60.19:1521:orcl via JDBC. at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.getConnection(AbstractJdbcCatalog.java:124) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.open(AbstractJdbcCatalog.java:130) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:80) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:180) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:136) ... 8 more Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.160.60.19:1521:orcl at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.getConnection(AbstractJdbcCatalog.java:120) ... 14 more 2025-06-03 11:06:56,531 ERROR [o.a.s.c.s.SeaTunnel ] [main] - =============================================================================== 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:228) 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 'Jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:168) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:86) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:376) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:227) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: org.apache.seatunnel.api.table.catalog.exception.CatalogException: ErrorCode:[API-03], ErrorDescription:[Catalog initialize failed] - Failed connecting to jdbc:oracle:thin:@10.160.60.19:1521:orcl via JDBC. at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.getConnection(AbstractJdbcCatalog.java:124) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.open(AbstractJdbcCatalog.java:130) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:80) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:180) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:136) ... 8 more Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.160.60.19:1521:orcl at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.AbstractJdbcCatalog.getConnection(AbstractJdbcCatalog.java:120) ... 14 more ``` ### Zeta or Flink or Spark Version zata ### Java or Scala Version java 8 ### Screenshots <img width="890" alt="Image" src="https://github.com/user-attachments/assets/f5721055-a14d-4504-9492-8c4fc1c8bc6b"; /> ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
