You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-zh@flink.apache.org by 陈卓宇 <25...@qq.com.INVALID> on 2022/04/15 12:05:53 UTC

flinkcdc读oracle 报错

flinksql语句：

CREATE TABLE products ( 
     id INT NOT NULL, 
     NAME STRING, 
     PRIMARY KEY(id) NOT ENFORCED 
     ) WITH ( 
     'connector' = 'oracle-cdc', 
     'hostname' = '10.16.16.26', 
     'port' = '1521', 
     'username' = 'tmp_test0415', 
     'password' = 'tmp_test0415', 
     'database-name' = 'svdp', 
     'schema-name' = 'TMP_TEST0415', 
     'table-name' = 'TEST_1'); 
      
 select * from products;

报错：
[ERROR] Could not execute SQL statement. Reason:
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found


求教大佬该如何解决


陈卓宇


&nbsp;