Ask Your Question
0

JDBC Consumer [closed]

asked 2019-06-03 05:11:52 -0500

Gaur gravatar image

updated 2019-06-03 08:27:41 -0500

Hello, I'm trying to connect to SQL DB using JDBC Consumer but getting error:

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://<sqlservername>:1433;databaseName=XYZ;integratedSecurity=true;

I have tried couple of JDBC strings but no one worked. I followed: https://docs.microsoft.com/en-us/sql/...

SDC VM is on Azure and SQL Server on premise. Valid network interface has been established and is working for other databases (Not on same server). I would appreciate any guidance that I could get.

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Gaur
close date 2019-06-04 06:06:27.748631

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-06-04 06:05:25 -0500

Gaur gravatar image

It was JDBC driver issue.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2019-06-03 05:11:52 -0500

Seen: 26 times

Last updated: Jun 04