How to monitor RFC to JDBC scenario?
How to monitor RFC to JDBC scenario
I have update_insert scenario from RFC to Oracle database.
In TOC SXMB_MONI I have black and white flag.
In RWB I found for this scenario only successful status.
But in the database I found only 2 records from the 15 that I sent.
How can I monitor this problem?
What are the steps to investigate this situation?
Have a way to see the exact statement that I sent to the database?
Nimrod Gisis replied
If nothing can be seen in the Adapter monitor...go to the Database.
Oracle has various developer\system tools that can allow you to get information.
For example Oracle has the TOAD tool which allows you to get the SQL trace of the treatment the XI actually send.
see if the SQL interpreted by the JDBC adapter was really what you meant.