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

### 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