新增出错错误记录NodeletException,SAXParseException20231025

新增出错(DB2+ibatis)

[com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 281; The content of element type “sqlMapConfig” is incomplete, it must match “(properties?,settings?,resultObjectFactory?,typeAlias*,typeHandler*,transactionManager?,sqlMap+)+”.][Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 281; The content of element type “sqlMapConfig” is incomplete, it must match “(properties?,settings?,resultObjectFactory?,typeAlias*,typeHandler*,transactionManager?,sqlMap+)+”.]:[Ljava.lang.StackTraceElement;@1179358f

    ORDER_NO            INTEGER generated always as identity
        primary key,
    PLAN_MONTH          VARCHAR(40)  default ''   not null,
    MANU_FACTORY_ID     VARCHAR(40)  default ''   not null,
    PLAN_VERSION        VARCHAR(255) default ''   not null,
    PLAN_VERSION_STATE  VARCHAR(10)  default '00' not null,
    REMARK              VARCHAR(40)  default ''   not null,
    REC_CREATOR         VARCHAR(32)  default ''  not null,
    REC_CREATOR_NAME    VARCHAR(32)  default ' '  not null,
    REC_CREATE_TIME     VARCHAR(14)  default ' '  not null,
    REC_REVISOR         VARCHAR(32)  default ' '  not null,
    REC_REVISOR_NAME    VARCHAR(32)  default ' '  not null,
    REC_REVISE_TIME     VARCHAR(14)  default ' '  not null,
    ARCHIVE_FLAG        VARCHAR(1)   default ' '  not null,
    ARCHIVE_TIME        VARCHAR(14)  default ' '  not null,
    ARCHIVE_STAMP_NO    VARCHAR(10)  default ' '  not null,
    PROCESS_INSTANCE_ID VARCHAR(64)  default ' '  not null,
    DOC_ID              VARCHAR(64)  default ' '  not null,
    REC_ID              VARCHAR(64)  default ' '  not null,
    REC_VERSION         VARCHAR(64)  default ' '  not null,
    REC_AREA_ID         VARCHAR(10)  default ' '  not null,
    EXT1                VARCHAR(255) default ' '  not null,
    EXT2                VARCHAR(255) default ' '  not null
  1. 这个错误有可能是xml写的不正确,(但是我是自动生成的xml应该不存在这个选项)
  2. 这该死啊,是主键是新增的,但是xml生成的时候也包括主键了,就报这个错误了(和这个有关但吧全是)
  3. 我把sql换了一个xml然后报错不能传空,但是我又都有默认值,就把创建人创建时间给了,就突然对了

com.ibatis.sqlmap.client.SqlMapException: Failed to instantiate MappedStatementStrategy bean

com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=5, TABLEID=24840, COLNO=2, DRIVER=4.21.29:

posted @ 2023-10-25 15:15  啧啧啧|(* ̄ ̄*)  阅读(51)  评论(0)    收藏  举报  来源