| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 Select failing in Custom node |
« View previous topic :: View next topic » |
| Author |
Message
|
| subhadra |
 Posted: Tue May 07, 2002 5:11 am Post subject: |
 |
|
Newbie
Joined: 06 May 2002
Posts: 8
|
Hi,
Have written a custom node, which performs a Select on a table. It was working fine, till one fine day, when it gave a SQL select failure. Since then, i just cannot get it to work. Is there any way in which i can trap the DB2 SQL error code? (All schema names, etc. are OK)
Thanx in advance,
Subhadra |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue May 07, 2002 12:36 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Are you throwing back the exception in your plug-in? I don't think you can refer to sQL error code directly in your plug-in. Try printing ExceptionList in your message flow, it will have DB2 SQL Error code in it.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| subhadra |
| Posted: Fri May 10, 2002 11:11 pm Post subject: |
|
|
Newbie
Joined: 06 May 2002
Posts: 8
|
Yes, i AM throwing an exception, and printed the exception list trace, this doesn't provide the SQL error code. The thing which puzzles me is that the code works perfectly fine for some time, and suddenly, i get the SQL select failed error. Pls note that i have not made any change to the code, or the database, and the Select statement always remains the same !
Is the resource getting locked, or something like that ???
Regds
Subhadra |
|
| 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
|
|
|
|
