Ask Your Question
0

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

Comments

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: https://github.com/brettwooldridge/HikariCP/issues/674. Streamsets team should upgrade to latest version of HikariCP.

soubhik.das@sterlingts.com gravatar imagesoubhik.das@sterlingts.com ( 2018-11-14 10:52:27 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

iamontheinet gravatar image

Hi,

This is a known issue with the HikariCP version in SDC. It will be resolved as part of https://issues.streamsets.com/browse/....

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 61 times

Last updated: Nov 27