Oracle CDC not reading data from Origin

asked 2019-04-09 14:06:30 -0600

anonymous user


Dear Team, I am not able to read the data from Oracle to Postgre using Oracle CDC with the latest version 3.8, I am using very latest version with an ojdbc7 driver. can you guide me how will I read using Oracle CDC.


edit retag flag offensive close merge delete



Are you getting any errors? Did you follow steps to enable LogMiner, supplemental logging, etc. outlined here

iamontheinet gravatar imageiamontheinet ( 2019-04-09 14:12:36 -0600 )edit

@Dash Earlier it was working fine earlier but Recently Upgraded my Streamsets to 3.8. after that only it's not working and I am not getting any error but my oracle cdc client not reading the data from origin. Which version of jdbc it will work fine with the latest version of Streamsets? Thanks.

Dep gravatar imageDep ( 2019-04-10 07:49:00 -0600 )edit

I am not 100% sure it's a version issue but try ojdbc8. That has worked for me in the past but I've also never tried using any other version.

iamontheinet gravatar imageiamontheinet ( 2019-04-10 11:13:39 -0600 )edit

I tried with the same version ojdbc8, but still, I am not getting the data from origin using oracle cdc client

Dep gravatar imageDep ( 2019-04-10 13:16:14 -0600 )edit

I am also experiencing the same issue. No error however data is not coming through the origin. The log shows got rollback for 2.19.1880 - transaction discarded

Mgcobo gravatar imageMgcobo ( 2020-05-28 01:24:20 -0600 )edit