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


### 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