为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:centos7
【CPU】:X86
【问题描述】*:一样的数据,不知道为什么报错
Cause: dm.jdbc.driver.DMException: SQL语句为NULL或空值
<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>
https://eco.dameng.com/community/article/ea82c4859f3a509443aea48f1ae4ff9c
开启一下jdbc的日志发上来看看