为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:Linux
【CPU】:
【问题描述】*:org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: dm.jdbc.driver.DMException: 第 5 行, 第 104 列["]附近出现错误:
语法分析出错
The error may exist in file [D:\ayangting\develeper\works\mchis-dm\mchis-service\target\classes\sqlmap\oracle\sys\SysOrganCustomMapper.xml]
The error may involve com.zhending.dao.sys.SysOrganCustomMapper.selectByFilter
The error occurred while executing a query
SQL: SELECT SYS_ID, DB_KEY, TB_KEY, SRC, EXT, ORGAN_CODE, ORGAN_NAME, ORGAN_FLAG, LOGIN_CODE, "NODE", PNODE, LEADER, ADDRESS_CODE, PROVINCE, CITY, COUNTY, TOWN, VILLAGE, TEL, POST_CODE, SORT_NO, LETTER, ORGAN_TYPE, ORGAN_GRADE, ORGAN_LEVEL, WOMAN_CHECK_DATE, CHILD_CHECK_DATE, WOMAN_MAIN, CHILD_MAIN, WOMAN_DELIVERY, WOMAN_DELIVERY_LIMIT, WOMAN_DELIVERY_LIMIT_HOURS, NEWBORN_SCREEN_APPLY, NEWBORN_SCREEN, NEWBORN_SCREEN_DIAGNOSE, WOMAN_SCREEN_APPLY, WOMAN_SCREEN, WOMAN_SCREEN_DIAGNOSE, HEAR, HEAR_DIAGNOSE, VISION, VISION_DIAGNOSE, HEART, HEART_DIAGNOSE, BIRTH_CERT_IN, BIRTH_CERT_ISSUE, BIRTH_ORGAN, BIRTH_REPAIR_ORGAN, BIRTH_ADDR_PRINT, RECEPT_SCOPE, CREATE_DATE, UPDATE_DATE, BIRTH_AUDITOR_CODE, BIRTH_AUDITOR, SEND_TICKET, AUTO_TICKET, CHILD_TICKET, RECORD_NOTES, SMS_WARN_DOCTOR, SMS_WARN_TEL, SMS_SIGN, ORGAN_AUDIT_GRADE, ORGAN_NUM, OBSTETRICS_BEDS, GYNAECOLOGY_BEDS, NEWBORN_BEDS, PEDIATRICS_BEDS, WOMAN_TREAT_CENTER, MOTHER_HIV, MOTHER_RPR, MOTHER_HBSAG, WOMAN_CLINIC, BABY_HOSPITAL, QUALIFICATION_DATE, EXPIRATION_DATE, NEWBORN_TREAT_CENTER, MOTHER_MARRY, MOTHER_MIDWIFERY, MOTHER_PLANNING, MOTHER_DIAGNOSIS, MATERNAL_CHILDS, BIRTH_MANAGEMENT, BIRTH_REPLACEMENT, BIRTH_REISSUE, PRECORDIAL_INSTITUTION, TWO_CANCERS_PRIMARY, TWO_CANCERS_TRAN, DRUG_MANAGE_ORGAN, DRUG_RELEASE_ORGAN, ART_ORGAN, PLATFORM_ORGAN_CODE, SRV_CODE, COUNTRY_CODE, PROVINCE_CODE, NEWBORN_SCREEN_ORGAN, REISSUE_DOCTOR_CODE, REISSUE_DOCTOR, TEAM_NO, TEAM, CHILD_TEL, WOMAN_TEL, LONGITUDE, LATITUDE, MEDICAL_ORG_ID, SHAKE_POVERTY_ORG, PLAN_DRUG_ORGAN_NAME, INTEGRITY_CHECK, CREDIT_CODE, XC_CANCER_ORGAN ,CASE WHEN EXISTS(SELECT 1 FROM SYS_ORGAN SO2 WHERE SO2.PNODE=SO.NODE) THEN '1' ELSE '0' END "hasChild" FROM SYS_ORGAN SO WHERE SO.ORGAN_CODE='320000E80232435'
Cause: dm.jdbc.driver.DMException: 第 5 行, 第 104 列["]附近出现错误:
语法分析出错
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: 第 5 行, 第 104 列["]附近出现错误:
语法分析出错
但是在客户端可以正常执行
关注一下引号两边的内容,尝试去掉引号试一下