You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "mtzcsc (via GitHub)" <gi...@apache.org> on 2024/06/12 03:01:30 UTC

[I] [Bug] [Module Name] Bug title [seatunnel]

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-unsubscribe@seatunnel.apache.org.apache.org

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


Re: [I] An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461 [seatunnel]

Posted by "mtzcsc (via GitHub)" <gi...@apache.org>.
mtzcsc commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2172582370

   Originally, the jar of the ojdbc8-12 version was adjusted, and the adjustment to the ojdbc8-19 version will not cause an error


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461 [seatunnel]

Posted by "Carl-Zhou-CN (via GitHub)" <gi...@apache.org>.
Carl-Zhou-CN commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2172585328

   > Originally, the jar of the ojdbc8-12 version was adjusted, and the adjustment to the ojdbc8-19 version will not cause an error
   
   Issue resolved, close this issue


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] [Bug] [Module Name] Bug title [seatunnel]

Posted by "hailin0 (via GitHub)" <gi...@apache.org>.
hailin0 commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2167268570

   @mtzcsc 
   Please add source table create table sql into this issue


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] [Bug] [Module Name] Bug title [seatunnel]

Posted by "mtzcsc (via GitHub)" <gi...@apache.org>.
mtzcsc commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2162194490

   该库为目标库 表无法删除重建,在测试的脚本中重新建表一摸一样的 还是存在同样的问题


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] [Bug] [Module Name] Bug title [seatunnel]

Posted by "hailin0 (via GitHub)" <gi...@apache.org>.
hailin0 commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2162142949

   @mtzcsc 
   please try schema_save_mode is RECREATE_SCHEMA
   
   ```
   sink {
       Jdbc {
            
           schema_save_mode = "RECREATE_SCHEMA"
       }
   }
   ```


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461 [seatunnel]

Posted by "hailin0 (via GitHub)" <gi...@apache.org>.
hailin0 commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2167337815

   [source table datatype](https://github.com/user-attachments/files/15832730/default.xlsx)
   


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461 [seatunnel]

Posted by "Carl-Zhou-CN (via GitHub)" <gi...@apache.org>.
Carl-Zhou-CN closed issue #6972: An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461
URL: https://github.com/apache/seatunnel/issues/6972


-- 
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-unsubscribe@seatunnel.apache.org

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


Re: [I] [Bug] [Module Name] Bug title [seatunnel]

Posted by "mtzcsc (via GitHub)" <gi...@apache.org>.
mtzcsc commented on issue #6972:
URL: https://github.com/apache/seatunnel/issues/6972#issuecomment-2162201462

   @hailin0 该表无法无法支持重建 ,不过有自动新建的表也出现相同的问题


-- 
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-unsubscribe@seatunnel.apache.org

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