提示: 执行sql: INSERT INTO BIDDINGPAPERDOCUMENTS_MASTER (BIDDINGPAPERDOCUMENTS_MASTER.ID, BIDDINGPAPERDOCUMENTS_MASTER.VERSION, BIDDINGPAPERDOCUMENTS_MASTER.BIDENDDATE, BIDDINGPAPERDOCUMENTS_MASTER.BIDNO, BIDDINGPAPERDOCUMENTS_MASTER.BIDPRJNAME, BIDDINGPAPERDOCUMENTS_MASTER.COOUNIT, BIDDINGPAPERDOCUMENTS_MASTER.FACTIVITY, BIDDINGPAPERDOCUMENTS_MASTER.FACTIVITYNAME, BIDDINGPAPERDOCUMENTS_MASTER.FCREATDTIME, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEDEPTCODE, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEDEPTID, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEDEPTNAME, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEPERSONCODE, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEPERSONFID, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEPERSONID, BIDDINGPAPERDOCUMENTS_MASTER.FCREATEPERSONNAME, BIDDINGPAPERDOCUMENTS_MASTER.FDELFLAG, BIDDINGPAPERDOCUMENTS_MASTER.FINISHTIME, BIDDINGPAPERDOCUMENTS_MASTER.FORMNO, BIDDINGPAPERDOCUMENTS_MASTER.FPROCESSID, BIDDINGPAPERDOCUMENTS_MASTER.FTASKID, BIDDINGPAPERDOCUMENTS_MASTER.FUPDATETIME, BIDDINGPAPERDOCUMENTS_MASTER.ISALTER, BIDDINGPAPERDOCUMENTS_MASTER.ISDONE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER01, BIDDINGPAPERDOCUMENTS_MASTER.PAPER01DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER01REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER02, BIDDINGPAPERDOCUMENTS_MASTER.PAPER02DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER02REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER03, BIDDINGPAPERDOCUMENTS_MASTER.PAPER03DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER03REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER04, BIDDINGPAPERDOCUMENTS_MASTER.PAPER04DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER04REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER05, BIDDINGPAPERDOCUMENTS_MASTER.PAPER05DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER05REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER06, BIDDINGPAPERDOCUMENTS_MASTER.PAPER06DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER06REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PAPER07, BIDDINGPAPERDOCUMENTS_MASTER.PAPER07DATE, BIDDINGPAPERDOCUMENTS_MASTER.PAPER07REMARK, BIDDINGPAPERDOCUMENTS_MASTER.PROCESSSTATUS, BIDDINGPAPERDOCUMENTS_MASTER.PSDESCRIPTION) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [15E4EF4C4CA24FF9BC3064645E5DC13B, 0, 1900-01-24, 21, 22, 23, 12, 13, 1900-01-10 00:00:00.0, 9, 8, 7, 5, 6, 4, 3, 16, 1900-02-03 00:00:00.0, 19, 15, 14, 1900-01-11 00:00:00.0, 20, 32, 25, 1900-02-02 00:00:00.0, 41, 26, 1900-02-04 00:00:00.0, 42, 27, 1900-02-05 00:00:00.0, 43, 28, 1900-02-06 00:00:00.0, 44, 29, 1900-02-07 00:00:00.0, 45, 30, 1900-02-08 00:00:00.0, 46, 31, 1900-02-09 00:00:00.0, 47, 17, 18]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 36 more
Caused by: java.sql.SQLException: ORA-01438: 值大于为此列指定的允许精度
估计excel 中有个空格，然后这个字段是日期类型，导入的时候变成 1900-02-07 00:00:00.0 ，我想要变成null，怎么解决？
|
IP卡
狗仔卡
发表于 2019-8-28 14:51:44
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2019-8-28 15:44:38
