product-sp icon indicating copy to clipboard operation
product-sp copied to clipboard

polling cdc - ORA-01843 or ORA-01847 with Oracle 11g

Open jpvadell opened this issue 5 years ago • 0 comments

Description: I configured the cdc in polling mode @source(type = 'cdc', url = 'jdbc:oracle:thin:@localhost:49161/XE', mode = 'polling', jdbc.driver.name = 'oracle.jdbc.OracleDriver', polling.column = 'dated', polling.interval = '10', username = 'vatrox', password = 'vatrox', table.name = 'LOGS_AUDIT', @map(type = 'keyvalue' ) )

The table fields are

DATED TIMESTAMP(6) USER_ID VARCHAR2(50 BYTE) TENANT VARCHAR2(20 BYTE) LOGLEVEL VARCHAR2(20 BYTE) MESSAGE VARCHAR2(1000 BYTE)

When I delete all records from the table, when start the process this error appears. ORA-01847: day of month must be between 1 and last day of month

And when I start the process and some records exists, this is the error. ORA-01843: not a valid month

Example data... insert into logs_audit values (to_timestamp('11/04/2018 01:13:00.000000','DD/MM/YYYY HH24:MI:SS.FF'),'jpvadell','-1234','INFO','Trying CDC');

Maybe is something with the NLS_DATE_FORMAT parameter?

Affected Product Version: Stream Processor 4.4.0 RC1

Steps to reproduce: Try to use Oracle as DB

jpvadell avatar Apr 14 '19 20:04 jpvadell