Errors using jTDS driver for MS SQL Server

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

5464 ●26 ●41 ●82 https://about.me/patpa...

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

add a comment

1

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

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.