Errors using jTDS driver for MS SQL Server

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

4173 ●26 ●40 ●72 https://about.me/patpa...

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

add a comment

1

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

natty
11 ●1 ●1

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.