注册

java插入SQL语句含有\n

DM_452142 2025/02/12 231 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:含有\n的SQL语句。使用java驱动执行SQL

\n会自动变为\n导致插入数据会多一个\

SQL语句:
MERGE
INTO
emc_version_service_docker_config T
USING dual ON
(T."version_id" = 'xxxxxx'
AND T."service_code" = '11111')
WHEN MATCHED THEN
UPDATE
SET

T."environment_variables" = '[{"name": "JAVA_HEAP", "value": "-server \n-XX:+UseContainerSupport -XX:InitialRAMPercentage=40.0 -XX:MinRAMPercentage=20.0 -XX:MaxRAMPercentage=75.0 -XX:MaxNewSize=1024m -XX:NewRatio=3 -XX:SurvivorRatio=8 -Xss1M -XX:MetaspaceSize=256M -XX:MaxMetaspaceSize=256M -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=92 -XX:+UseCMSCompactAtFullCollection -XX:CMSFullGCsBeforeCompaction=0 -XX:+CMSParallelInitialMarkEnabled -XX:+CMSScavengeBeforeRemark -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+PrintGCDateStamps -XX:+HeapDumpOnOutOfMemoryError -Duser.timezone=${MKS_ClientTimeZone}", "isEncrypted": 0}]',
WHERE
T."version_id" = 'xxxxxx'
AND T."service_code" = '11111'
WHEN NOT MATCHED THEN
INSERT
(
"environment_variables",
)
VALUES('[{"name": "JAVA_HEAP", "value": "-server \n-XX:+UseContainerSupport -XX:InitialRAMPercentage=40.0 -XX:MinRAMPercentage=20.0 -XX:MaxRAMPercentage=75.0 -XX:MaxNewSize=1024m -XX:NewRatio=3 -XX:SurvivorRatio=8 -Xss1M -XX:MetaspaceSize=256M -XX:MaxMetaspaceSize=256M -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=92 -XX:+UseCMSCompactAtFullCollection -XX:CMSFullGCsBeforeCompaction=0 -XX:+CMSParallelInitialMarkEnabled -XX:+CMSScavengeBeforeRemark -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+PrintGCDateStamps -XX:+HeapDumpOnOutOfMemoryError -Duser.timezone=${MKS_ClientTimeZone}", "isEncrypted": 0}]');

回答 0
暂无回答
扫一扫
联系客服