Insert/update response for JDBC scenario

[Former Member]

Hi Experts,

I would like to get the response for the Webservice to JDBC <b>insert</b> sychronous scenario. After inserting into the table, how we have to perform the response process?(whether the datas are inserted into the table or not type of response/flag type response)

Regards

Sara

[Former Member · Accepted solution]

hi sara,

If you are expecting a commit response from the data base, a similar discussion on the forum is present.

Refer this link

regards

Ramesh P

[agasthuri_doss]

Hi,

This will help you

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards

Agasthuri Doss

[Former Member]

Hi,

Check below links.

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

JDBC RECEIVER ADAPTER

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

Regards,

phani

[Former Member]

Hi All,

Could you please tell me, how to get the response back(whether data is inserted or not type of response) after inserting into the table.

ACTION: INSERT/UPDATE

Regards

Sara

Message was edited by:

Sara D

[Former Member]

If your interface is Asynchronous..and you are just inserting record in database tables using (INSERT) then u cannot get any response from database which automatically tell you that records sucsessfully inserted:-)

If really you want to chek it then you have to make Synch JDBC call.

Using JDBC adapter with XI will definetely insert the records in database if all things are ok (like database is up, Test data is correct, Interface without Error.) If really you have such requirment, then you have to make a Synch call.

Thanks

Farooq.

<b>*Rewards Points if you find it usefull*</b>

[prateek]

Generally JDBC sync scenario is used when u want to "select" some data from the database. What exactly do u want in response after the select statement?

This would be helpful

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

Regards,

Prateek