| Author |
Message
|
| cvag |
 Posted: Tue Sep 28, 2010 3:47 am Post subject: Does Handlers will work when database is down? |
 |
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
I'm trying to access database using an SQL statement. An SQL exception is thrown when DB is down.
I'm trying to handle this exception using Contiue Handlers and proceed further in the flow without throwing an exception.
So Continue Handle didn't worked for this situaiton.?
Is there any way to handle this situation(when DB is down) and continue further with the main flow . Does MB s  upports this situation?
Thanks in Advance. |
|
| Back to top |
|
 |
| Mandeep |
| Posted: Tue Sep 28, 2010 4:51 am Post subject: |
|
|
Apprentice
Joined: 03 May 2004
Posts: 33
|
| There is a property on compute node called 'Throw exception on database error'. You could un-check it and handle the exception in ESQL the way you would like. Continue processing or throw an ESQL User Exception based on what kind of exception is returned by DB |
|
| Back to top |
|
|
| cvag |
| Posted: Tue Sep 28, 2010 1:00 pm Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Thanks Mandeep,
Yeah i got ur point and i handled database errors explicitly earlier. But my concern is about "when database is down" can we handle and go further processing with the main flow or not using Handlers. Because the debug point is not even entering the node when the database is down.. whereas the other situations like primary constraint , other query statements etc etc.. its fine.
Could you please reply if you get my point.
Thanks. |
|
| Back to top |
|
|
| ajit1981 |
| Posted: Tue Sep 28, 2010 10:46 pm Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010
Posts: 41
Location: Bangalore, Inida
|
| Put TryCatch node before your compute node, and put one compute node and connect with the Catch terminal, in that compute node you can do your transformation/processing . |
|
| Back to top |
|
|
| cvag |
| Posted: Tue Sep 28, 2010 11:41 pm Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
|
| Back to top |
|
|
|
|
