注册

dm.jdbc.driver.DMException: SQL语句为NULL或空值

足迹! 2022/04/18 1095 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:centos7
【CPU】:X86
【问题描述】*:一样的数据,不知道为什么报错
Cause: dm.jdbc.driver.DMException: SQL语句为NULL或空值

image.png

<insert id="insertBatch" parameterType="com.xmirror.xfuse.entity.project.ProjDemandRelationEntity" databaseId="dm"> <foreach collection="list" item="item" separator=";"> insert into "MYSQL"."PROJ_DEMAND_RELATION" <trim prefix="(" suffix=")" suffixOverrides=","> <if test="item.demandId != null"> "DEMAND_ID", </if> <if test="item.projectId != null"> "PROJECT_ID", </if> <if test="item.serial != null and item.serial != ''"> "SERIAL", </if> <if test="item.demand != null and item.demand != ''"> "DEMAND", </if> <if test="item.name != null and item.name != ''"> "NAME", </if> <if test="item.priority != null"> "PRIORITY", </if> <if test="item.label != null"> "LABEL", </if> <if test="item.verificationMode != null"> "VERIFICATION_MODE", </if> <if test="item.businessReviewStatus != null"> "BUSINESS_REVIEW_STATUS", </if> <if test="item.businessReviewComment != null and item.businessReviewComment != ''"> "BUSINESS_REVIEW_COMMENT", </if> <if test="item.technologyReviewStatus != null"> "TECHNOLOGY_REVIEW_STATUS", </if> <if test="item.technologyReviewComment != null and item.technologyReviewComment != ''"> "TECHNOLOGY_REVIEW_COMMENT", </if> <if test="item.testReviewStatus != null"> "TEST_REVIEW_STATUS", </if> <if test="item.testReviewComment != null and item.testReviewComment != ''"> "TEST_REVIEW_COMMENT", </if> <if test="item.safeReviewStatus != null"> "SAFE_REVIEW_STATUS", </if> <if test="item.safeReviewComment != null and item.safeReviewComment != ''"> "SAFE_REVIEW_COMMENT", </if> <if test="item.version != null and item.version != ''"> "VERSION", </if> <if test="item.businessSceneName != null and item.businessSceneName != ''"> "BUSINESS_SCENE_NAME", </if> <if test="item.associatedUsers != null and item.associatedUsers != ''"> "ASSOCIATED_USERS", </if> <if test="item.createDate != null"> "CREATE_DATE", </if> <if test="item.modifyDate != null"> "MODIFY_DATE", </if> </trim> values <trim prefix="(" suffix=")" suffixOverrides=","> <if test="item.demandId != null"> #{item.demandId}, </if> <if test="item.projectId != null"> #{item.projectId}, </if> <if test="item.serial != null and item.serial != ''"> #{item.serial}, </if> <if test="item.demand != null and item.demand != ''"> #{item.demand}, </if> <if test="item.name != null and item.name != ''"> #{item.name}, </if> <if test="item.priority != null"> #{item.priority}, </if> <if test="item.label != null"> #{item.label}, </if> <if test="item.verificationMode != null"> #{item.verificationMode}, </if> <if test="item.businessReviewStatus != null"> #{item.businessReviewStatus}, </if> <if test="item.businessReviewComment != null and item.businessReviewComment != ''"> #{item.businessReviewComment}, </if> <if test="item.technologyReviewStatus != null"> #{item.technologyReviewStatus}, </if> <if test="item.technologyReviewComment != null and item.technologyReviewComment != ''"> #{item.technologyReviewComment}, </if> <if test="item.testReviewStatus != null"> #{item.testReviewStatus}, </if> <if test="item.testReviewComment != null and item.testReviewComment != ''"> #{item.testReviewComment}, </if> <if test="item.safeReviewStatus != null"> #{item.safeReviewStatus}, </if> <if test="item.safeReviewComment != null and item.safeReviewComment != ''"> #{item.safeReviewComment}, </if> <if test="item.version != null and item.version != ''"> #{item.version}, </if> <if test="item.businessSceneName != null and item.businessSceneName != ''"> #{item.businessSceneName}, </if> <if test="item.associatedUsers != null and item.associatedUsers != ''"> #{item.associatedUsers}, </if> <if test="item.createDate != null"> #{item.createDate}, </if> <if test="item.modifyDate != null"> #{item.modifyDate}, </if> </trim> </foreach> </insert>
回答 0
暂无回答
扫一扫
联系客服