Ask Your Question
1

JDBC Query Consumer - SQL Server Closed Connection

asked 2018-05-30 17:25:07 -0500

jay1988 gravatar image

updated 2018-05-30 20:12:58 -0500

metadaddy gravatar image

We are using a JDBC Query Consumer and trying to connect to a SQL Server. While doing validation we are getting below error and not able to proceed with pipeline execution.

ERROR JdbcSource - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: I/O Error: DB server closed connection.

com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: I/O Error: DB server closed connection.
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-05-30 20:12:39 -0500

metadaddy gravatar image

It looks like SQL Server is accepting the connection, but then dropping it. There are a couple of possible reasons:

  • Mismatched SSL configuration between the JDBC driver and SQL Server
  • Authentication problems
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-30 17:25:07 -0500

Seen: 9 times

Last updated: May 30