How to read a query from extenalized .sql file using java and executing it in DB connector as dynamic/parameterized query?

you can achieve this by using properties direcly inside cdata. Step 1. Add query in properties file

`insert.query=Insert into txt_table (SSO_ID,PSID,PTIN) values (#[payload.SSO_ID],#[payload.PSID],#[payload.PTIN])`

Step 2: Use property key inside insert query

 **<db:insert config-ref="CSDB_Configuration" bulkMode="true" doc:name="Db call -Insert in table" doc:description="It is DB call to insert data in  table">
                 <db:parameterized-query><![CDATA[${insert.query}]]></db:parameterized-query>
 </db:insert>**

Hi,

Please go through the post.It will be helpful for you. https://stackoverflow.com/questions/25097586/how-to-read-sql-queries-from-properties-file-in-mule-3-5-database-connector

Specially this ans: I had the same issue. As @David suggested I added a flow var and inserted the query (from a property).The only difference was I had to add the CDATA section below. I was able to pull the query from a property file after that. Here is my flow:

 <set-variable variableName="openQuery" value="${opens}" doc:name="Open Var"/>    
 <db:select config-ref="MySQL_Configuration" doc:name="Opens">
     <db:dynamic-query><![CDATA[#[flowVars.openQuery]]]></db:dynamic-query>
 </db:select>