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

   ### 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
   
   After confirmed, For Spark/Flink Engine, You also must need to ensure that 
the [jdbc driver jar 
package](https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc) 
has been placed in directory ${SEATUNNEL_HOME}/lib/.
   
   Otherwise, if jdbc jar placed in directory ${SEATUNNEL_HOME}/plugins/, there 
will raise error: 
   Unable to create a source for identifier 'SqlServer-CDC'. Caused by: 
java.sql.SQLException: No suitable driver found for jdbc:sqlserver:
   
   ### SeaTunnel Version
   
   2.3.10
   
   ### SeaTunnel Config
   
   ```conf
   source {
     SqlServer-CDC {
       exactly_once = true
       username = "xxx"
       password = "xxx"
       startup.mode = "initial"
       database-names = ["xxx"]
       table-names = ["xxx"]
       table-names-config = [
         {
           table = "xxx"
           primaryKeys = ["id"]
         }
       ]
       base-url = "jdbc:sqlserver://xxx:1433;databaseName=xxx"
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   /opt/seatunnel/bin/start-seatunnel-flink-15-connector-v2.sh -c 
/config/sqlserver2paimon.stream.conf
   ```
   
   ### Error Exception
   
   ```log
   org.apache.flink.client.program.ProgramInvocationException: The main method 
caused an error: ErrorCode:[API-06], ErrorDescription:[Factory initialize 
failed] - Unable to create a source for identifier 'SqlServer-CDC'.
   
   Caused by: java.sql.SQLException: No suitable driver found for 
jdbc:sqlserver://
   ```
   
   ### Zeta or Flink or Spark Version
   
   Flink 1.16.3
   
   ### Java or Scala Version
   
   11.0.27
   
   ### Screenshots
   
   
![Image](https://github.com/user-attachments/assets/4cb95c84-6145-4a2c-8a0b-6d38d56633c9)
   
   ### Are you willing to submit PR?
   
   - [x] 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