i am new to NamedParameterJdbcTemplate. getting this exception while running this code
InquireClaimDetailsInfoResponse result = null;
MapSqlParameterSource params = new MapSqlParameterSource();
params.addValue("HEADER_TCN", tcn);
log.info("Initiated Rest API for Inquire Claim Details Query Execution started");
System.out.println("query"+query +"params" +params);
try {
List <Map<String, Object>> resultList = namedParameterJdbcTemplate.queryForList(query, params);
}catch(Exception e) {
System.out.println("exception" + e.getMessage());
}
log.info("Query Executed");
return result;
}
exceptionPreparedStatementCallback; bad SQL grammar [“SELECT DISTINCT cl.claim_header_sid AS “CLAIM_HEADER_SID”, cl.claim_line_sid AS “CLAIM_LINE_SID”, cl.claim_line_tcn AS “TCN”, sts.status_name AS “Claim Status”, a.MBR_IDENTIFIER AS “Beneficiary ID”, a.patient_first_name AS “Member First Name”, a.patient_last_name AS “Member Last Name”, Null AS “Member Middle Name”, Null AS “Member Suffix”, a.PATIENT_ACCOUNT_NMBR AS “Patient Account Number”, a.BI_PRVDR_IID AS “Billing / Pay To Provider ID”, ‘XX’ AS “Type”, a.SE_PRVDR_IID AS “Rendering Provider ID”, null AS “Type”, a.RF_PRVDR_IID AS “Referring Provider ID”, null AS “Type”, a.REF_PC_PRVDR_IID AS “primaryCare Provider”, null AS “Type”, a.SP_PRVDR_LCTN_IID AS “supervising Provider”, null AS “Type”, cl.revenue_code AS “clmLnRevenueCode”, cl.prcdr_code AS “clmLnPrcdrCode”, MDFR_CODE1 AS “Modifiers 1”, MDFR_CODE2 AS “Modifiers 2”, MDFR_CODE3 AS “Modifiers 3”, MDFR_CODE4 AS “Modifiers 4”, to_char(cl.from_service_date,’MM/dd/yyyy’)AS “clmLnFrmSrvcDate”, to_char(cl.to_service_date,’MM/dd/yyyy’)AS “clmLnToSrvcDate”, to_char(cl.billed_amount,’$999,999,999,990.99′)AS “Submitted Amount”, cl.billed_units AS “Units”, cl.billed_amount AS “Billed_Amount”, null AS “CLM LN Paid Date”, a.warrant_date AS “Warrant Date”, a.warrant_ach AS “Warrant Number”, to_char(cl.billed_amount,’$999,999,999,990.99′)AS “Submitted Charges”, cl.billed_amount AS “Billed Amount”, null AS “Paid Date”, a.warrant_date AS “Warrant Date”, a.warrant_ach AS “Warrant Number” FROM clm_hdr_dtl_page_ad_prf_view a, ad_claim_line cl, status sts, ad_claim_header ch WHERE a.tcn = ‘331800210075696000’ AND a.CLAIM_HEADER_SID = ch.CLAIM_HEADER_SID AND ch.CLAIM_HEADER_SID = cl.CLAIM_HEADER_SID AND sts.status_type_cid = cl.bsns_status_type_cid AND sts.status_cid = cl.bsns_status_cid AND cl.bsns_status_type_cid = 8 AND cl.aplctn_status_type_cid = 2 AND cl.aplctn_status_cid <> 78 and Billed_Amount = 181;”]