| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Handler problem. |
« View previous topic :: View next topic » |
| Author |
Message
|
| sandip_gaikwad |
 Posted: Mon Oct 24, 2011 9:39 pm Post subject: Handler problem. |
 |
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
| My flow is database related .i am using handler in my project.So i want to if database connection not available that time flow come to on handler otherwise any insert,update ,delete problem it won't come to on handle it want to terminate that time. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Tue Oct 25, 2011 4:28 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| sandip_gaikwad |
| Posted: Wed Nov 02, 2011 3:34 am Post subject: |
|
|
Voyager
Joined: 25 Jul 2011
Posts: 95
|
Here condition is that I used handler in the database note i want to terminate handler when I insert any record that contain null field.
What is code for that using handler? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Nov 02, 2011 4:08 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I think a lot of us are having some trouble making sense of your statements.
I *think* what you are saying is that you want to write an ESQL DECLARE HANDLER that will only handle a failure condition that indicates that the database connection is not available.
If you have some other kind of error returned from a database, then you want your DECLARE HANDLER to ignore this.
You can specify with the DECLARE HANDLER what kinds of SQLSTATE, SQLCODE, etc., it will capture. So you should be able to determine the specific SQL errors you are looking for - that indicate the connection is not available - and then put those codes in your DECLARE HANDLER statement and Broker will do what you want. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
