| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to throw an exception with severity error in the ev.log? |
« View previous topic :: View next topic » |
| Author |
Message
|
| m.schneider |
 Posted: Mon Jul 09, 2007 6:51 am Post subject: How to throw an exception with severity error in the ev.log? |
 |
|
Centurion
Joined: 10 Apr 2007
Posts: 132
Location: Germany
|
Hi,
I'm trying to throw an exception that appears as error in the event-log.
This code appears as a informational entry:
THROW USER EXCEPTION SEVERITY 1 MESSAGE 2950 VALUES('The SQL State' , SQLState1 , SQLCode1 , SQLNativeError1 , SQLErrorText1);
And if a change it to:
THROW USER EXCEPTION SEVERITY 3 MESSAGE 2950 VALUES('The SQL State' , SQLState1 , SQLCode1 , SQLNativeError1 , SQLErrorText1);
I receive an error.
How can I use the build in catalog to throw errors? Do I have to pick a special number of the supplied user messages?(2951 - 2999)
Thanks for your help. |
|
| Back to top |
|
 |
| wbi_telecom |
| Posted: Mon Jul 09, 2007 7:06 am Post subject: |
|
|
Disciple
Joined: 15 Feb 2006
Posts: 188
Location: Harrisburg, PA
|
As per the infocenter you should not receive an error as long as severity contains any expression that returns a non-NULL, integer value. What is the error you are getting?
Cheers, |
|
| Back to top |
|
|
| m.schneider |
| Posted: Mon Jul 09, 2007 7:27 am Post subject: |
|
|
Centurion
Joined: 10 Apr 2007
Posts: 132
Location: Germany
|
( TMBROKER.EXEGRP1 ) ('.store_msg.storeMsg', '17.4') Bei Ausführung der SQL-Anweisung ''THROW EXCEPTION SEVERITY 2 MESSAGE 2951 VALUES( 'The SQL State', SQLState1, SQLCode1, SQLNativeError1, SQLErrorText1);'' wurde ein Fehler festgestellt.
An error occured during the execution of THROW, ... |
|
| 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
|
|
|
|
