alibaba / alibaba/DataX

空值写入oracle数据库date类型报错

Open
#798 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

从一个ftp取文件写入oracle数据库时,有一个日期类型的字段有空值,写入时报 ERROR StdoutPluginCollector - 脏数据:
{"exception":"TIMESTAMP 类型转换错误,请帮忙看看怎么解决,谢谢!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the FTP-to-Oracle import with an empty date field and trace the reported "TIMESTAMP type conversion error" through the Oracle writer and date-conversion entry points. Done means a null date is handled without producing dirty data, with the relevant behavior covered by a regression test if the project has one.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.