I have a sync message, HTTP - JDBC. User data comes in the request and record is inserted in the DB.
The JDBC by default gives the Insert_count as 1 on successful insert - in the response.
Now, in the response after checking the insert_count- I would like to use the user details from the request and send an email out saying that the user record is inserted.
That is the actual rek.
And can anyone elaborate the use of RequestResponseBean in this case?
With RequestResponseBean you try but requirement is you need the values which came from sender. If you map the response of JDBC and Request you get but i think it will not pass the data for request. to the mail adapter.
The trick would be to put the request value (ie, userid) within the XML message nodename. If you look at the JDBC receiver SQL structure, the root node can have any name. So if you generate your request XML msg with the root node as <request_userid>...</request_userid>, the response message will look like <request_userid_response>...</request_userid_response> ! Then, in your response msg mapping, you can get the value using string function (ie substring) to store it a response attribute for later use.
I use this to get the number of each inserted document ... and it works
If i have understand your question correctly, you want to get the source message in "Response Message Mapping" using message id of the source message. If yes, It cannot be possible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.