Ask Your Question

Errors using sqljdbc42.jar driver for sql server

asked 2018-07-24 22:26:15 -0500

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

jdbc url=jdbc:sqlserver://;databaseName=sbgl; streamsets-libs-extras/streamsets-datacollector-jdbc-lib/lib = sqljdbc4.jar

I'm trying to use the sqljdbc4.jar driver to connect to SQLServer2000. I'm getting this error: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: Connection.isValid() is not supported, configure connection test query.

error screenshots link

edit retag flag offensive close merge delete



Did you try doing what the error suggests by configuring a connection test query instead?

jeff gravatar imagejeff ( 2018-07-25 15:19:10 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-07-26 03:16:23 -0500

lucaz248 gravatar image

updated 2018-08-01 10:05:55 -0500

metadaddy gravatar image

Go to JDBC Producer > Connection Health Test Query tab, then in the "Connection Health Test Query" option add query test like: select 1

edit flag offensive delete link more


thank you . gravatar ( 2018-08-16 21:00:27 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-24 22:26:15 -0500

Seen: 202 times

Last updated: Aug 01 '18