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

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22)
 and found no similar issues.
   
   
   ### What happened
   
   An error is reported for data synchronization Caused by: 
java.sql.BatchUpdateException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值
   
   ### SeaTunnel Version
   
   2.3.4
   
   ### SeaTunnel Config
   
   ```conf
   # Defining the runtime environment
   env {
     parallelism = 2
     job.mode = "BATCH"
   }
   source{
       Jdbc {
           url = "jdbc:oracle:thin:@ip:1521/ORCL_1"
           driver = "oracle.jdbc.OracleDriver"
           user = "c"
           password = ""
           query = "select ORG_CODE  JGBM  , PERSON_ID HZWYBS  ,'1' 
DATA_SOURCE, '1' OPERATIONFLAG ,'' JKDABM , 
NVL(substr(replace(INS_PROP_CODE,'无',''),0,2),'9') HZYBLXBM ,IDCARD KH ,'' KLX  
,'' FKDQ ,'0' HZLX  ,NVL(IDCARD_TYPE_CODE,'01') SFZJLBBM 
,NVL(trim(IDCARD),'000000000000000000') SFZJHM ,substr(NAME,0,10) HZXM  
,replace(SEX_CODE,'无','')  XBBM  ,DATE_OF_BIRTH CSRQ  ,'' NLDW ,TEL DHHM  ,TEL 
SJHM  , '-' DZYJDZ  ,'-' XLBM  ,replace(CITIZENSHIP_CODE,'无','')  GJBM  
,replace(NATION_CODE,'无','') MZBM  ,replace(MARITAL_CODE,'无','')  HYZKBM  , 
CONTACT_NAME  LXRXM    from caching2.TM_OUT_PERSON_INFO p  where 
rksj>=trunc(sysdate-3)"
       }
   }
   
   transform {
       # If you would like to get more information about how to configure 
seatunnel and see full list of transform plugins,
       # please go to https://seatunnel.apache.org/docs/transform-v2/sql
   }
   
   sink {
       Jdbc {
           url = "jdbc:oracle:thin:@ip:1521/ORCL_1"
           driver = "oracle.jdbc.OracleDriver"
           user = ""
           password = ""
           
           generate_sink_sql = "true"
           database = "ORCL"
           table = "EHR2.HZJBXXB"
           enable_upsert = "true"
           primary_keys = [JGBM, HZWYBS, DATA_SOURCE, OPERATIONFLAG]
           #schema_save_mode = "CREATE_SCHEMA_WHEN_NOT_EXIST"
       }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   Invoked via DS
   ```
   
   
   ### Error Exception
   
   ```log
   Caused by: java.sql.BatchUpdateException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值
   ```
   
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### Screenshots
   
   
   
![dd59719c9ae34bb9719c3de59a3dd1c](https://github.com/apache/seatunnel/assets/49063245/a469d0d4-0fdb-46fa-91b2-fdf96bb6dd1d)
   
![image](https://github.com/apache/seatunnel/assets/49063245/0d09d8eb-e3e0-474e-a796-d537096f2c47)
   
   
   ### Are you willing to submit 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: commits-unsubscr...@seatunnel.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to