MQSeries.net :: View topic - Closing a statement in Esql

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Closing a statement in Esql

Closing a statement in Esql

« View previous topic :: View next topic »

Author

Message

sachinramesh

Posted: Wed May 21, 2008 3:34 am Post subject: Closing a statement in Esql

Disciple

Joined: 20 Feb 2007
Posts: 170

Hi

My scenario is , a java application is putting messages in the MQ QUEUE and MB is picking up and processing it and inserting it into the database.

I am getting an error which says "NO more handlers error".When i searched for the error i found that there were no handlers to handle the statements or the statement is trying to process when the previous one is not closed.

Is there anything like closing a statement or closing a queue in esql code.

Can anybody tell me when can these errors occur.

AkankshA

Posted: Wed May 21, 2008 3:41 am Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

when do u get this error ???

while inserting or before ???

did u use debugger to find the exact line which throws the error
_________________
Cheers

crossland

Posted: Wed May 21, 2008 5:08 am Post subject:

Master

Joined: 26 Jun 2001
Posts: 248

Can you post the failing ESQL?

Tim
http://www.inspirotechnic.com

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Closing a statement in Esql

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