Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
8 subscribers
Views
1031 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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>...
OriginalPostID-124146
OriginalPostID-124146
Discussion posts and replies are publicly visible
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