|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
Handling a large message |
« View previous topic :: View next topic » |
Author |
Message
|
SANTYP |
Posted: Tue Sep 21, 2010 11:19 pm Post subject: Handling a large message |
|
|
 Centurion
Joined: 27 Mar 2007 Posts: 142
|
Hi Gurus,
I have a problem while handling the message from a stored procedure...
my flow is simple..
mqinput node --> compute node ..> Mq Reply node
in the compute node I am calling an oracle storedprocedure.. which will result a largestring (typically 5mb message)
which is of simple xmlstring.
after calling the procedure... i am not getting any response...
(I am executing the procedure in toad it is talking 1-2mins to give the result so I am waiting min before doing step over in the broker)
I am forcefully killing the broker process.. the thread is getting hanged...
suggest me what would be possible issue..
Thanks in advance.. |
|
Back to top |
|
 |
francoisvdm |
Posted: Sun Sep 26, 2010 8:53 pm Post subject: |
|
|
Partisan
Joined: 09 Aug 2001 Posts: 332
|
Try and return a smaller message from stored procedure, if that works, make the return message progressively bigger and see if you csn pick up a pattern....maybe you are just running out of time.....or, maybe the message is just too big. If size is the problem, you are lucky because you can control the stored procedure.... return a subset of the data. If time is the problem....just wait longer. _________________ If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
Back to top |
|
 |
kimbert |
Posted: Mon Sep 27, 2010 12:52 am Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
|
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
|
|
|
|