SQL server to Kafka pipeline failed

asked 2017-09-14 05:46:37 -0500

prachi
81 ●4 ●5 ●9

updated 2017-12-18 13:24:14 -0500

metadaddy

5464 ●26 ●41 ●81 https://about.me/patpa...

SQL Server Change Tracking Client 1

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:sqlserver://;servername=<ip-address>;databaseName=<dbname>;integratedSecurity=true;tablename=tablename : hikariConfigBean.connctionString

Is it a driver issue or connection parameters issue?

edit retag flag offensive close merge delete

add a comment

1

answered 2017-09-15 12:31:55 -0500

prachi
81 ●4 ●5 ●9

updated 2017-10-09 18:27:46 -0500

metadaddy

5464 ●26 ●41 ●81 https://about.me/patpa...

It was a driver issue and the issue has now been resolved. The driver was not installed and so the required jar file was missing from the /lib directory.

edit flag offensive delete link

add a comment

0

answered 2017-09-18 12:47:34 -0500

Jisun
116 ●1 ●1

I actually tested out with "sqljdbc42.jar" and it worked with SDC. Can you confirm if the driver is properly installed in SDC? You can also modify the log level to "INFO" to check if the driver is loaded in SDC or not: https://streamsets.com/documentation/...

edit flag offensive delete link

add a comment

0

answered 2017-09-15 12:17:34 -0500

jeff
3120 ●18 ●41 ●70

The most likely case is that the MS SQL server JDBC driver has not been properly installed as per the documentation here. Have you followed those steps? Which specific jar name/version are you using for the JDBC driver?

edit flag offensive delete link

Comments

I am using Microsoft JDBC Driver 4.2 for SQL Server. Earlier the driver was not installed and so the required jar file was missing from the /lib directory. I am using 'sqljdbc42.jar'

prachi ( 2017-09-15 12:31:52 -0500 )edit

add a comment

SQL server to Kafka pipeline failed

3 Answers

Comments

Question Tools

Stats

Related questions

SQL server to Kafka pipeline failed edit

3 Answers

Comments

Question Tools

Stats

Related questions

SQL server to Kafka pipeline failed