Ask Your Question
0

Errors using jTDS driver for MS SQL Server

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

metadaddy gravatar image

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

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
1

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

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
0

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

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

Comments

Issue has been open on jTDS for JDBC 4.0 support for 10 years! https://sourceforge.net/p/jtds/feature-requests/46/

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

Question Tools

1 follower

Stats

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

Seen: 348 times

Last updated: Nov 20 '17