Ask Your Question
0

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

1 Answer

Sort by ยป oldest newest most voted
0

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

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 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 117 times

Last updated: Nov 20 '17