How to write string literals in sql query in springboot application.yaml file?

Asked Jul 01 '22 at 20:49

Active Jul 01 '22 at 20:54

Viewed 111 times

I am trying to place sql query to read data from kudud table in applciation.yaml file where string literal is used. But while running the program it is giving the parsing error as below - EL1043E: Unexpected token. Expected 'rcurly(})' but was 'identifier'

Below is the query used where "FINNACE" is a literal-

application.yaml - filequery.map : '{

"filequery" : "SELECT FILE, project FROM ( SELECT FILE AS file_or_table_group, "FINNACE" AS project FROM finnance_data ) AS finnancedata"

edited Jul 01 '22 at 20:54

asked Jul 01 '22 at 20:49

Tinku

Did you try :`\"FINNACE\"` ? – SeanH Jul 01 '22 at 20:58
Yes @SeanH, I tried this also. – Tinku Jul 01 '22 at 21:10
Not sure why, but I think you can save this json content into a separate json file and let your code to load it separately. That's possibly can separate the issues. – SeanH Jul 01 '22 at 22:49
1

@SeanH, It got resolved, we need to provide " to escape " means it should be like - ""FINNANCE"". Thanks – Tinku Jul 05 '22 at 20:13
Good news. Thanks. – SeanH Jul 05 '22 at 21:23

How to write string literals in sql query in springboot application.yaml file?

0 Answers0