Ask Your Question
0

StreamSets over HDInsight - Error on JDBC for SQL

asked 2018-01-02 15:43:35 -0600

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello experts,.... we are having trouble using the “StreamSets over HDInsight on Azure” when using a pipeline where the source is SQL Azure, the issue is trying to connect to SQL Azure through a JDBC.

Not sure where to have information on how to accomplish this connection, any guidance will be highly appreciated.

We are having the following 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://mtypodsqlserver.database.windows.net,1433

But when tried to setup the JDBC but when restarting the service, the service never goes back to start.

Best regards,

-Ulises

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-03 14:19:00 -0600

jeff gravatar image

What exact driver jar did you use (source URL and/or full jar file name)? Did you set it up as per the instructions here?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-02 15:43:35 -0600

Seen: 22 times

Last updated: Jan 03