- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.2K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
GoldenGate for Big Data: issue with DST
We are having an issue with Oracle GoldenGate for Big Data that we use to publish CDC messages to Kafka (with the KafkaHandler).
Normally the datetime values that we publish to Kafka, would be in the local time zone (Netherlands), but we have configured GoldenGate to publish those values in the time zone UTC.
But during the transition from Daylight Saving Time (UTC+02:00) to no DST (UTC+01:00) on October 25, 2020 we observed this behaviour (datetime in format DD-MM-YYYY HH:MM):
insert in RDBMS on 25-10-2020 02:59:59 (UTC+02:00) -> OP_TS = 25-10-2020 00:59:59
insert in RDBMS on 25-10-2020 02:00:01 (UTC+01:00) -> OP_TS = 25-10-2020 00:00:01
The last OP_TS should be 25-10-2020 01:00:01.
We have tried a lot of options (ORA_SDTZ, SOURCETIMEZONE, TZ) but we can't get it working correctly.
Do you have a solution?