How do we know database connection fails in RFC-JDBC scenario
In my RFC-JDBC scenario, from my RFC call if I receive one paramater as x, I need to delete the table in DB. If that param isnt x, I need to insert into the DB table.
How can I do this without BPM?.(since I dont want to use BPM).
Another problem is, how do I know that database connection fails, since I need to send "DB Connection Failed" from XI to SAP?.
ok, so you need two statments in your SQL XML. One you will always fill and for the other you can use a creatIf function two create the delete statement only if your parameter is x. Check here on how createif works: http://help.sap.com/saphelp_nw04/helpdata/en/d9/3033f96c79674f90e3ab8d101a595b/content.htm.