Ask Your Question
1

Errors using sqljdbc42.jar driver for sql server

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

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://10.64.4.109:1433;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 http://m.qpic.cn/psb?/V13iSNrn4eY0RH/...

edit retag flag offensive close merge delete

Comments

1

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

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

1 Answer

Sort by ยป oldest newest most voted
1

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

lucaz248 gravatar image

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

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

Comments

thank you .

1215103810@qq.com gravatar image1215103810@qq.com ( 2018-08-16 21:00:27 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 41 times

Last updated: Aug 01