Hi, I would like to know how can exception handling for stored proced

anagha_abhyankar over 9 years ago

Hi,

I would like to know how can exception handling for stored procedure nodes be achieved? It seems to be a problem when exceptions occur for DB is down. Even if other exceptions are added in the procedure & if the DB is down, the node fails to execute. And, I cannot add any exception as we can easily do using configure Pause node on Error for Query DB smart service.

Currently, we have added a status and message returned in the stored procedure in case of any error occured. But this is not working when the DB is down, and in the alerts it gives me the message:
Unable to connect to database: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/<Datasource_name>...

Discussion posts and replies are publicly visible

Parents

0 Cesar Machuca
Appian Employee
over 9 years ago

Is this regarding the Smart Service included in the Execute Stored Procedure plug-in? If so, what you could do is review the source code of the plug-in and modify it so you can customize the exceptions you want to show. The source code is included inside the .jar file:

forum.appian.com/.../64996
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Cesar Machuca
Appian Employee
over 9 years ago

Is this regarding the Smart Service included in the Execute Stored Procedure plug-in? If so, what you could do is review the source code of the plug-in and modify it so you can customize the exceptions you want to show. The source code is included inside the .jar file:

forum.appian.com/.../64996
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data