luckyzerg opened a new issue, #5029:
URL: https://github.com/apache/seatunnel/issues/5029

   ### Search before asking
   
   - [X] I had searched in the 
[feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22)
 and found no similar feature requirement.
   
   
   ### Description
   
   从Oracle同步数据到Oracle不支持大字段。不知道这个算feature还是bug
   同步大字段时会出现如下报错:
   
   Caused by: 
org.apache.seatunnel.connectors.seatunnel.jdbc.exception.JdbcConnectorException:
 ErrorCode:[COMMON-10], ErrorDescription:[Flush data operation that in sink 
connector failed] - Writing records to JDBC failed.
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.checkFlushException(JdbcOutputFormat.java:132)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.writeRecord(JdbcOutputFormat.java:140)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.write(JdbcSinkWriter.java:81)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.write(JdbcSinkWriter.java:44)
           at 
org.apache.seatunnel.engine.server.task.flow.SinkFlowLifeCycle.received(SinkFlowLifeCycle.java:202)
           ... 15 more
   Caused by: 
org.apache.seatunnel.connectors.seatunnel.jdbc.exception.JdbcConnectorException:
 ErrorCode:[COMMON-10], ErrorDescription:[Flush data operation that in sink 
connector failed] - java.sql.BatchUpdateException: ORA-01461: can bind a LONG 
value only for insert into a LONG column
   
   配置为(隐藏了敏感信息):
   
   env {
     execution.parallelism = 1
     job.mode = "STREAMING"
     checkpoint.interval = 15000
   }
   source{
       Jdbc {
           url = "jdbc:oracle:thin:@//*.*.*.*:1521/*"
           driver = "oracle.jdbc.OracleDriver"
           connection_check_timeout_sec = 100
           user = "***"
           password = "***"
           query = "select * from *** where updt_dt>sysdate-1/1440 and 
rownum<=1000"
       }
   }
   sink {
       jdbc {
           url = "jdbc:oracle:thin:@//*.*.*.*:1521/*"
           driver = "oracle.jdbc.OracleDriver"
           user = "***"
           password = "***"
           database="***"
           table = "***"
           primary_keys = ["***"]
           generate_sink_sql ="true"
   }
   }
   
   
   ### Usage Scenario
   
   _No response_
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to