数据库相关异常_caused violation of inheritance rule. manually set-CSDN博客

本文链接：https://blog.csdn.net/yanlici1249075710/article/details/78052004

Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
- SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
2017.08.30 at 19:51:00.013 GMT+08:00 INFO  
com.dj.seal.bankFile.util.KeyManageUtil 104 updateMap - updateMap:Wed Aug 30 19:51:00 GMT+08:00 2017


错误原因分析：

    insert into COUNTER_PICTURE(SEQNO,GUARDIANFLAG,MASTERDOCUMENTF,PID,SUBDOCUMENTT,PROXYDOCUMENTF,MASTERDOCUMENTT,SUBDOCUMENTF,PROXYDOCUMENTT) VALUES('C40938ns687E0662980','1',null,'6f6d70cf-8a51-4bd1-94c8-f93764d6a79d',null,null,'E:/dj/ftp/69184abb-f3ff-4414-bb7c-fa79fb753fe8.jpg',null,null)


    原因就是COUNTER_PICTURE 这个表里缺少两个字段：PROXYDOCUMENTF    PROXYDOCUMENTT

    解决办法就是：向这个表里添加这两个字段
        alter table COUNTER_PICTURE
        add (PROXYDOCUMENTF varchar2(255));

        alter table COUNTER_PICTURE
        add (PROXYDOCUMENTT varchar2(255));





===============

    insert into COUNTER_PICTURE(SEQNO,GUARDIANFLAG,MASTERDOCUMENTF,PID,SUBDOCUMENTT,PROXYDOCUMENTF,MASTERDOCUMENTT,SUBDOCUMENTF,PROXYDOCUMENTT) VALUES('C40938ns687E0662980','1',null,'6f6d70cf-8a51-4bd1-94c8-f93764d6a79d',null,null,'E:/dj/ftp/69184abb-f3ff-4414-bb7c-fa79fb753fe8.jpg',null,null)



ora-00001：违反唯一约束条件
        这个就是pid 这个唯一字段，添加时候，结果又重复了