You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "suntectec (via GitHub)" <gi...@apache.org> on 2025/06/28 23:18:44 UTC

[I] [Bug] [SQL Server CDC] mssql-jdbc driver jar package placed directory path [seatunnel]

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

   ### 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: commits-unsubscribe@seatunnel.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] [SQL Server CDC] mssql-jdbc driver jar package placed directory path plugins invalid [seatunnel]

Posted by "suntectec (via GitHub)" <gi...@apache.org>.
suntectec commented on issue #9518:
URL: https://github.com/apache/seatunnel/issues/9518#issuecomment-3043763666

   This is a suggestion for website /plugin dir advise incorrect, so closed


-- 
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: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Bug] [SQL Server CDC] mssql-jdbc driver jar package placed directory path plugins invalid [seatunnel]

Posted by "suntectec (via GitHub)" <gi...@apache.org>.
suntectec closed issue #9518: [Bug] [SQL Server CDC] mssql-jdbc driver jar package placed directory path plugins invalid
URL: https://github.com/apache/seatunnel/issues/9518


-- 
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: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org