Ask Your Question

Errors using jTDS driver for MS SQL Server

asked 2017-11-20 16:45:20 -0600

metadaddy gravatar image

updated 2017-12-18 13:56:54 -0600

I'm trying to use the jTDS JDBC driver to connect to MS SQL Server. I'm getting this error:

JDBC_00 - 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: Connection.isValid() is not supported, configure connection test query.
edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-04-29 12:06:45 -0600

natty gravatar image

The Advanced tab in the configuration has a section where a connection test query can be entered. While the cause of this error is due to the Driver supporting JDBC 3.0, rather than 4.0, it’s also worth knowing that this can be easily worked around by specifying a test query. For example, select 1 from table, or something like that.

edit flag offensive delete link more

answered 2017-11-20 16:47:59 -0600

metadaddy gravatar image

jTDS is a JDBC 3.0 driver - StreamSets Data Collector needs JDBC 4.0. You should use the Microsoft SQL Server JDBC Driver.

edit flag offensive delete link more


Issue has been open on jTDS for JDBC 4.0 support for 10 years!

metadaddy gravatar imagemetadaddy ( 2017-11-20 16:48:11 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-20 16:45:20 -0600

Seen: 1,676 times

Last updated: Nov 20 '17