Ask Your Question

Getting issues while using destination as JDBC Producer

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

Vandana Bhat gravatar image

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

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 -0500 )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 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

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

iamontheinet gravatar image

updated 2020-02-19 17:15:50 -0500

metadaddy gravatar image


This was a known issue with the HikariCP version in SDC. It was resolved as part of in Data Collector 3.8.0.

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



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

Seen: 412 times

Last updated: Feb 19