product-sp
product-sp copied to clipboard
polling cdc - ORA-01843 or ORA-01847 with Oracle 11g
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