Ask Your Question
0

SAS Connection error

asked 2021-04-23 01:15:25 -0500

Manimars gravatar image

Hi All, How can I access the SAS connectivity as source using JDBC query consumer/JDBC multitable consumer?

We have been trying to connect to SAS Enterprise Guide 8.3 application having source staging component as JDBC query consumer & JDBC multitable consumer. We have also updated the DC libs with all the necessary drivers and still we were not able to connect to the SAS server. Below is the validation error we get during the preview. Could someone please help me with this connection. We were struggling hard with this from the last few weeks. Let me know if anything is required from my end.

JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Commit/Rollback not supported. : hikariConfigBean.connectionString

edit retag flag offensive close merge delete

Comments

@iamontheinet , @metadaddy, @jeff - any help here please. Thanks in advance.

Manimars gravatar imageManimars ( 2021-04-23 01:16:44 -0500 )edit

Could you please share the complete stack-trace please?

Ranjith gravatar imageRanjith ( 2021-04-27 19:43:03 -0500 )edit

Hi @Ranjith I have shared the latest trace below in the answer section. Please have a look.

Manimars gravatar imageManimars ( 2021-04-28 01:42:38 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-04-28 01:41:29 -0500

Manimars gravatar image

2021-04-28 06:36:17,500 ERROR HikariPool-605 - Exception during pool initialization. HikariPool preview-pool-13-thread-4 com.sas.rio.MVASQLExceptionUnsupported: Commit/Rollback not supported. at com.sas.rio.MVAConnection.setAutoCommit(MVAConnection.java:557) at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:418) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:374) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:1049) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.checkConnectionAndBootstrap(AbstractTableJdbcSource.java:189) at com.streamsets.pipeline.stage.origin.jdbc.table.TableJdbcSource.checkConnectionAndBootstrap(TableJdbcSource.java:72) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.init(AbstractTableJdbcSource.java:171) at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:48) at com.streamsets.pipeline.api.base.configurablestage.DStage.init(DStage.java:36) at com.streamsets.datacollector.runner.StageRuntime.lambda$init$0(StageRuntime.java:220) at com.streamsets.datacollector.util.LambdaUtil.withClassLoaderInternal(LambdaUtil.java:148) at com.streamsets.datacollector.util.LambdaUtil.withClassLoader(LambdaUtil.java:44) at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:218) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:109) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:44) at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:411) at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:314) at com.streamsets.datacollector.runner.Pipeline.validateConfigs(Pipeline.java:221) at com.streamsets.datacollector.runner.preview.PreviewPipeline.validateConfigs(PreviewPipeline.java:60) at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.validateConfigs(SyncPreviewer.java:167) at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$validateConfigs$0(AsyncPreviewer.java:81) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2021-04-28 06:36:17,500 ERROR Failed to initialize connection pool: {} JdbcUtil * preview-pool-13-thread-4 com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Commit/Rollback not supported. at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:576) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:555) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari ... (more)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2021-04-23 01:15:25 -0500

Seen: 362 times

Last updated: Apr 28