注册

hibernate生成查询语句与数据库关键字冲突

￿ 2021/08/16 1625 12

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:linux
【CPU】:intel
【问题描述】*:
hibernate生成查询语句与数据库关键字冲突,于是我配置hibernate参数
如图:
image.png
在加上引号之后反而不识别了
hibernatesql:Actual SQL: dataSource ::: select this_.“id” as id1_13_0_, this_.“admin” as admin2_13_0_, this_.“auth_type” as auth_typ3_13_0_, this_.“bound_domain_account” as bound_do4_13_0_, this_.“company” as company5_13_0_, this_.“complete_trial_task” as complete6_13_0_, this_.“contact” as contact7_13_0_, this_.“ctime” as ctime8_13_0_, this_.“custom_user_status” as custom_u9_13_0_, this_.“dcz_switch” as dcz_swi10_13_0_, this_.“network_zone_enable” as network11_13_0_, this_.“network_zone_list” as network12_13_0_, this_.“default_cloud_quota” as default13_13_0_, this_.“default_download_threshold” as default14_13_0_, this_.“default_enterprise_cloud_open” as default15_13_0_, this_.“default_team_limit” as default16_13_0_, this_.“default_team_privilege” as default17_13_0_, this_.“default_team_quota” as default18_13_0_, this_.“default_upload_threshold” as default19_13_0_, this_.“default_user_quota” as default20_13_0_, this_.“default_valid_enable” as default21_13_0_, this_.“default_valid_end_time” as default22_13_0_, this_.“default_valid_start_time” as default23_13_0_, this_.“description” as descrip24_13_0_, this_.“description_en” as descrip25_13_0_, this_.“docs_probation_date” as docs_pr26_13_0_, this_.“docs_switch” as docs_sw27_13_0_, this_.“domain_first” as domain_28_13_0_, this_.“domain_second” as domain_29_13_0_, this_.“due_reminder_switch” as due_rem30_13_0_, this_.“email” as email31_13_0_, this_.“etime” as etime32_13_0_, this_.“function_set” as functio33_13_0_, this_.“industry” as industr34_13_0_, this_.“is_fees” as is_fees35_13_0_, this_.“is_guard” as is_guar36_13_0_, this_.“link_sharing_switch” as link_sh37_13_0_, this_.“logo” as logo38_13_0_, this_.“mobile” as mobile39_13_0_, this_.“mtime” as mtime40_13_0_, this_.“name” as name41_13_0_, this_.“name_en” as name_en42_13_0_, this_.“personal_sharing_switch” as persona43_13_0_, this_.“phone” as phone44_13_0_, this_.“promo_code” as promo_c45_13_0_, this_.“quota” as quota46_13_0_, this_.“region_id” as region_47_13_0_, this_.“render_template” as render_48_13_0_, this_.“scale” as scale49_13_0_, this_.“security_setting_id” as securit50_13_0_, this_.“slave_datacenter_limit” as slave_d51_13_0_, this_.“slave_datacenter_switch” as slave_d52_13_0_, this_.“status” as status53_13_0_, this_.“stime” as stime54_13_0_, this_.“type” as type55_13_0_, this_.“website” as website56_13_0_ from “iris_account” this_ where this_.“id”=? and this_.“status” in (?, ?, ?, ?, ?) ::: [1, -1, 1, -2, 0, -3]

报错无法解析
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
无法解析的成员访问表达式[THIS_.“id”]

这是为何?

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