ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Failing DB entry in USER DEFINED EXCEPTION

Post new topic  Reply to topic
 Failing DB entry in USER DEFINED EXCEPTION « View previous topic :: View next topic » 
Author Message
giriraj.sharma
PostPosted: Mon Jul 30, 2012 12:11 am    Post subject: Failing DB entry in USER DEFINED EXCEPTION Reply with quote

Newbie

Joined: 23 Jul 2012
Posts: 7

Hi,

I am throwing a user defined exception using esql code and i want to enter that code in DB. But the system is entering a diffrent code 500.

Please help me on this.

Thanks & Regards,
Giriraj
Back to top
View user's profile Send private message
marko.pitkanen
PostPosted: Mon Jul 30, 2012 12:33 am    Post subject: Reply with quote

Chevalier

Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland

Hi giriraj.sharma,

What is the version of your broker. Have you taken debug user trace from your ESQL execution? Can you post original error -messages?
Back to top
View user's profile Send private message Visit poster's website
giriraj.sharma
PostPosted: Mon Jul 30, 2012 2:02 am    Post subject: Reply with quote

Newbie

Joined: 23 Jul 2012
Posts: 7

Hi,

There was no error message. I defined a code myself and a corresponding message to be entered in the DB if exception occurs.

But instead of my defined code, It entered 500 and a complete stack trace in the message column that must contain the corresponding error message as defined my me.

Thanks & Regards,
Giriraj
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Mon Jul 30, 2012 2:12 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

So you are not handling correctly the return of a soap request?
The 500 I suppose here is the http return code?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
marko.pitkanen
PostPosted: Mon Jul 30, 2012 2:39 am    Post subject: Reply with quote

Chevalier

Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland

Hi giriraj.sharma,

Can you describe with more details what are trying to do and how you are doing it now or share your ESQL -code or relevant parts of debug user trace here so someone could point out the pain point for you?


--
Marko
Back to top
View user's profile Send private message Visit poster's website
giriraj.sharma
PostPosted: Mon Jul 30, 2012 4:08 am    Post subject: Reply with quote

Newbie

Joined: 23 Jul 2012
Posts: 7

Hi,

Thanks. I got the solution.


--
Giriraj
Back to top
View user's profile Send private message
smdavies99
PostPosted: Mon Jul 30, 2012 10:56 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Would you care to share it with us so that other 'newbies' may learn from it?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Failing DB entry in USER DEFINED EXCEPTION
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.