I have JDBC ->XI -> R/3 synchronous scenario.
I have two possible options,
1) JDBC sender adapter invoking a stored procedure to get the required data. Send the information to R/3. Process the orders in R/3 and return the response back to JDBC (JDBC receiver)
2) Database will send a soap message whenever new records are inserted. i will use the input from soap message to retrieve records from DB (JDBC receiver) and then same steps as above. This will be BPM.
Which of the two will be better? And why? By second approach, I eliminate querying the database again and again.