Ask Your Question
1

SQL server to Kafka pipeline failed

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

prachi gravatar image

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

metadaddy gravatar image

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

3 Answers

Sort by ยป oldest newest most voted
1

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

prachi gravatar image

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

metadaddy gravatar image

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 more
0

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

Jisun gravatar image

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 more
0

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

jeff gravatar image

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 more

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 gravatar imageprachi ( 2017-09-15 12:31:52 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-14 05:46:37 -0600

Seen: 262 times

Last updated: Oct 09 '17