JDBC Consumer cannot access SQL Server 2000

asked 2018-07-02 02:10:10 -0600

syangunique gravatar image

updated 2018-07-02 16:04:18 -0600

metadaddy gravatar image

Microsoft was no longer update the jdbc driver for sqlserver 2000, When I use streamsets to connect sql server 2000 when using old jdbc driver or jTDS driver, It is appear this error and could not get access to it. The error log:

com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: Connection.isValid() is not supported, configure connection test query. at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:73) at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:771) at com.streamsets.pipeline.stage.origin.jdbc.table.TableJdbcSource.checkConnectionAndBootstrap(TableJdbcSource.java:117) at com.streamsets.pipeline.stage.origin.jdbc.table.TableJdbcSource.init(TableJdbcSource.java:263) at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:48) at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:36) at com.streamsets.datacollector.runner.StageRuntime.lambda$init$0(StageRuntime.java:177) at com.streamsets.datacollector.util.LambdaUtil.withClassLoader(LambdaUtil.java:31) at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:175) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:101) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:49) at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:386) at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:299) at com.streamsets.datacollector.runner.preview.PreviewPipeline.run(PreviewPipeline.java:49) at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.start(SyncPreviewer.java:207) at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$start$0(AsyncPreviewer.java:94) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:227) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:223) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:227) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:223) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:100) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: Connection.isValid() is not supported, configure connection test query. at com.zaxxer.hikari.pool.PoolElf.setupConnection(PoolElf.java:178) at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:497) at com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565) ... 30 more

edit retag flag offensive close merge delete

Comments

1

Did you try configuring a connection test query, as the error suggests?

jeff gravatar imagejeff ( 2018-07-02 15:33:56 -0600 )edit