Ask Your Question

Getting issues while using destination as JDBC Producer

asked 2018-11-13 03:36:36 -0600

Vandana Bhat gravatar image

updated 2018-11-14 01:03:20 -0600

Shruthi gravatar image

Hello All,

I am using destination as JDBC Producer is my pipeline with Redshift as the database. i get the following error when I try to validate the pipeline. can someone please help me?

JDBC_00 - Cannot connect to specified database: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: [Amazon][JDBC](11760) Cannot call setReadOnly while Connection is in a transaction.

edit retag flag offensive close merge delete


Check your JDBC driver version , try to use version 5.1.x. Then restart your streamsets

Shruthi gravatar imageShruthi ( 2018-11-14 01:02:26 -0600 )edit

Error is reproducible with latest version of aws redshift driver i.e. 1.2.16.xxxx. I believe the problem is with HikariCP-2.4.1 included with streamsets. The bug is documented at: Streamsets team should upgrade to latest version of HikariCP. gravatar ( 2018-11-14 10:52:27 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-11-27 14:17:48 -0600

iamontheinet gravatar image


This is a known issue with the HikariCP version in SDC. It will be resolved as part of

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2018-11-13 03:36:36 -0600

Seen: 276 times

Last updated: Nov 27 '18