Receiver JDBC structure and Mapping
Scenario - WS (async) -> PI 7.1 -> JDBC (sync) -> PI 7.1 -> WS (async)
My question is - In my request structure (from WS), I have a field "Transaction ID". This field is not present in the target DB, but when I get the response back from DB, I need to insert this transaction id in the response back to WS.
I am aware that there is an option in the request query (passing parameter and getting back the same value) and this can be achieved through XSL mapping. Can this same functionality be achieved through Graphical Mapping?
In other words, if I pass Transaction Id in my request query, can I get it back in the response? Just to remind, Transaction Id is not available in DB.
Any help / suggestion will be highly appreciated.
Although your post is an old one, but since it is not yet closed, i assume that you are still working on this.
I believe you have a view from where you are doing the select. You can give it a try with the following query -
SELECT V1.<your other fields that you want to select>, V2.TRANSACTIONID,
FROM <ViewName> V1,
(SELECT "TRANSACTIONID" AS TRANSACTIONID FROM DUAL) V2
This will simply create a temporary view V2 for holding the transaction id, and it will pick the value that you are passing with each message and in the response to the SELECT, it will always bring back the Transaction Id that you passed.
I would recommend that you use an XSL Mapping for this. Hope this helps.