JDBC DATE conversion Issue
I am working on a Proxy to JDBC (Async to Sync) scenario in this I am passing a sender field to target and retrieving the data from data base as response
Created the Request structure as below
Mapped the source field to f1 under key node and maintained the compare Operation as EQ and where the f2 field is the date,I have mapped it with constant( Value is GET DATE ()-90) and maintained the compare operation as GTEQ.
during run time getting issue at mapping as unable to convert the date,Could any one please help me with this.
Thanks & Regards,
Shreyansh Shah replied
Second point is about doing string concatenation like below:
String1 = "SELECT f1,f2,f3,f4 from xyz where f1 = '"
f1 is from source field
String2 = "' and f2 = getdate() - 90'"
With this the access field will have entire select statement with source field value. The use of single quote (') in String1 and String2 will depend on value of f1. Single quote is required if the value of f1 is string and it's not required if it's numeric.
Better you can execute the query in database first and then place it in mapping.