suntectec opened a new issue, #9346:
URL: https://github.com/apache/seatunnel/issues/9346

   ### 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
   
   Under docker env, for reading SqlServer CDC Table Data, submmit seatunnel 
config with command:
   bin/seatunnel.sh -m local -c config/sqlserver2console.zeta.conf
   
   no matter what mssql-jdbc versions, always got result of Seatunnel job 
executed failed Exception and Caused by: java.sql.SQLException: No suitable 
driver found for jdbc:sqlserver://localhost:1433;databaseName=inventory
   
   
   ### SeaTunnel Version
   
   2.3.10
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 1
     job.name = "Seatunnel From SqlServer To Console"
     job.mode = "STREAMING"
     checkpoint.interval = 5000
   }
   
   source {
     SqlServer-CDC {
       plugin_output = "customers"
       username = "sa"
       password = "xxx"
       startup.mode="latest"
       database-names = ["inventory"]
       table-names = ["inventory.INV.orders"]
       base-url = "jdbc:sqlserver://localhost:1433;databaseName=inventory"
     }
   }
   
   transform {
   }
   
   sink {
     console {
       plugin_input = "customers"
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   bin/seatunnel.sh -m local -c config/sqlserver2paimon.zeta.conf
   ```
   
   ### Error Exception
   
   ```log
   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:sqlserver://localhost:1433;databaseName=inventory 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:sqlserver://localhost:1433;databaseName=inventory
           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
   
   Seatunnel 2.3.10 Zeta Engine
   
   ### Java or Scala Version
   
   mssql-jdbc-12.10.0.jre11.jar 
   
   ### Screenshots
   
   
![Image](https://github.com/user-attachments/assets/82cee020-0953-4111-9b8c-ae685ded9055)
   
   
![Image](https://github.com/user-attachments/assets/d165e158-5ba1-4ccf-8616-dbc9201de619)
   
   ### 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]

Reply via email to