Two questions regarding wM JDBC adapter:
I want to use a adapter service that internally will use PreparedStatement. Does CustomSQL or DynamicSQL internally use PreparedStatements? Is there something in configuration that I have to specify apart from the placeholder (? in the query) and specifying the input/output parameters?
I created a simple DynamicSQL query with 5 input parameters. Query is something like “select * from sample where id in (?, ?, ?, ?, ?)”.
Have bound the input param’s to names like input1, input2 etc. The actual values of these are retrieved from calling another sevice in a previous step. When I look at the pipleline to bind the design-time variables, the source id’s are in an Array. But the destination (i.e. ServiceIn.DynamicSql_ServiceName.input1, input2 etc.) input variables are not in an array. Is there any way, I can get the placeholders to show up as arrays so I can loop through the source and map each source input into the destination input? Else I have to branch on $iteration inside the loop, check if $iteration == 1, then map first variable of input array to input1 and so on. Not a very elegant solution.
Responses would be much appreciated.