为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:windows11 64x
【CPU】:Intel core 12
【问题描述】*:
达梦适配Nhiberante的包,如果遇到列名称这个Comment,无法正常执行
使用的如下驱动
2023/12/14 23:24:37 Eorro-第 1 行, 第 500 列[Comment]附近出现错误: 语法分析出错 at Dm.DmCommand.do_ExecuteDbDataReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd) at NHibernate.AdoNet.AbstractBatcher.ExecuteReade
为什么执行下面的sql语句报错
select taskdiscus0_.Id as col_0_0_, taskdiscus0_.Name as col_1_0_,
taskdiscus0_.UserAccount as col_2_0_, taskdiscus0_.AttachFile as col_3_0_,
taskdiscus0_.CreateTime as col_4_0_, taskdiscus0_.ToAccount as col_5_0_,
taskdiscus0_.ToUserName as col_6_0_, taskdiscus0_.TxtComm as col_7_0_,
taskdiscus0_.Type as col_8_0_, flowinstta2_.AgentAccount as col_9_0_, flowinstta2_.Comments as col_10_0_, flowinstta2_.ElmentDisplayName as col_11_0_, flowinstta2_.ElmentName as col_12_0_, flowinstta2_.FinishDate as col_13_0_, flowinstta2_.FlowCode as col_14_0_, flowinstta2_.FlowName as col_15_0_, flowinstta2_.HandlerAccount as col_16_0_, flowinstta2_.InstanceId as col_17_0_, flowinstta2_.OwnerAccount as col_18_0_, flowinstta2_.ReceiveDate as col_19_0_, flowinstta2_.SysCode as col_20_0_, flowinstta2_.Id as col_21_0_, flowinstta2_.TaskState as col_22_0_, flowinstta2_.Version as col_23_0_, flowinstta2_.WorkAction as col_24_0_, flowinstan1_.Description as col_25_0_, flowinstan1_.State as col_26_0_, flowinstan1_.OwnerAccount as col_27_0_, flowinstan1_.Dept as col_28_0_, flowinstan1_.CreateTime as col_29_0_, flowinstan1_.SerilNo as col_30_0_, flowinstta2_.NotifyIsRead as col_31_0_, taskdiscus0_.HasRead as col_32_0_ from VadTaskDiscuss taskdiscus0_
cross join VadFlowInstance flowinstan1_ cross join VadFlowInstTask flowinstta2_
去掉这个部分就能执行
taskdiscus0_.TxtComm as col_7_0_,
这个有什么特别的吗
COMMENT是关键字,在连接串中加入keywords参数
jdbc:dm://127.0.0.1:5236?=(COMMENT)