getting response from jdbc receiver

[Former Member]

Hi

My scenario is as follows:

There r two databases -

---

> database1 and database2.From 2 tables of database1 data is to be retrieved and to be updated to 2 tables of database2.After updating database2 ; one of the database1 tables has to be updated with somevalue.

So here iam OK until updating the 2 tables of database2 , but i was strucked at 'how to do the reverse process'.i.e how can i get the response from database2 when iam using 'INSERT' for the attribute 'action' in the mapping of updating 2 tables of database2 in forward processing.

[Former Member · Accepted solution]

>>>one of the database1 tables has to be updated with <b>somevalue</b>

What value?

>>>but i was strucked at 'how to do the reverse process'

You need to use a BPM to achieve this. Or use briging at adapter level. But adapter bridge with JDBC adapters are said to have issues. So would suggest you go for a BPM.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi Jai Shankar,

Incase of using BPM,can u please briefly explain me how this can be acheived i.e which steps i have to use where....

Receive ---> Send ---> Receive ---> Send (or) Receive ---> Send ---> Send

Please explain ...

Thanks & Regards

Radhika.

[Former Member · Accepted solution]

Your BPM design will be very similar to

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1926. [original link is broken] [original link is broken] [original link is broken] [original link is broken]

The steps will be

1. Receive (Asynch)

2. Send (Synch)

3. Send (Asynch)

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi Jai Shankar,

Here Iam using 'INSERT' as the attribute 'action'.If we use 'SELECT' we will get the response of the selected records.But when using 'INSERT' , how the response will come . How should be the structure of database2 response datatype when using 'INSERT'.

[justin_santhanam · Accepted solution]

Radhika,

You will get the response as <Insert_Count>number of records inserted</Insert_Count>.

Best regards,

raj.

[Former Member · Accepted solution]

Hi Raj,

What is that 'Insert_count' . Where we can see that?

Thanks & Regards

Radhika.

[justin_santhanam · Accepted solution]

Radhika,

You are doing as per Jai's design right? Receive ->Send Synch-->Send Asynch.

If yes then you can see the same in Send Synch step. U can see the message in SXMB_MONI. Insert_Count is nothing but ,which will return number stating how many records have been inserted during the synch call.

Best regards,

raj.

[prabhu_s2]

did u check with this blog:

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

<b>at 'how to do the reverse process'.i.e how can i get the response from database2 when iam using 'INSERT' for the attribute 'action' in the mapping of updating 2 tables of database2 in forward processing</b>

what is the kind of reponse u req?

[Former Member]

hi Radika,

U can use a BPM to fulfill ur requirement.

In this BPM, first u update the two database tables using Insert statement, after that u can have another send step, which will update the first database with required value.

In case u need more help, do tell.

[Former Member]

Hi Mahendru,

Incase of using BPM,can u please briefly explain me how this can be acheived i.e which steps i have to use where....

Receive ---> Send ---> Receive ---> Send (or) Receive ---> Send ---> Send

Please explain ...

Thanks & Regards

Radhika.