cancel
Showing results for 
Search instead for 
Did you mean: 

capturing actual JDBC exception in BPM

Former Member
0 Kudos

I have a scenario wherein i am inserting data in sql server syncronously using the xml insert structure.

I have a BPM in place to do error handling, so that whenver any exception occurs, exception branch is executed,

however, in the exception branch am not able to detect wht the error was. Like was the error related to connectivity or related to DB that something failed because of BD constraint.

How can I trap the actual JDBC error in my exception handling..

Accepted Solutions (0)

Answers (1)

Answers (1)

moorthy
Active Contributor
0 Kudos

Hi,

As you are using BPM and the call is Sync,you can get the response back if everything is fine. If not it will throw exception.

If you want to detect the Application errors, one option is using Stored Procedures in the DB side, so that it will respond you back with insertion failed bacause of duplicate entry etc...

If you want to handle , exceptions for connectivity issuses, you can make use of ALerts configured for JDBC adapters.. So you can create the Alerts like that.

To know more-

http://help.sap.com/saphelp_nw2004s/helpdata/en/33/4a773f12f14a18e10000000a114084/content.htm

Hope this helps

Regards,

Moorthy