| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using ODBC from MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| dreinhart |
 Posted: Mon Mar 25, 2002 6:55 am Post subject: |
 |
|
Newbie
Joined: 25 Jun 2001
Posts: 2
Location: St. Louis, Mo
|
We are beginning to use this functionality but have been considering it's impact on the basic async nature of MQ.
Specifically, does the use of ODBC to a remote DB create a synchronous connection that is subject to a remote DB outage? Beyond coding the message flow to requeue/retry the message(s) until the remote DB is back, what options are available, or is this simply a consideration for using this feature?
Thanks.
_________________
Dan Reinhart |
|
| Back to top |
|
 |
| kolban |
| Posted: Mon Mar 25, 2002 10:50 am Post subject: |
|
|
Grand Master
Joined: 22 May 2001
Posts: 1072
Location: Fort Worth, TX, USA
|
| Using ODBC should not block. If the back-end ODBC database is unavailable, an exception will be thrown which can be caught. You could then divert the message to a holding queue to be processed in batch later when the database becomes available. At no time should a message flow ever block or be allowed to block. |
|
| Back to top |
|
|
| shcherb |
| Posted: Wed Jun 04, 2003 4:56 am Post subject: |
|
|
Apprentice
Joined: 12 Sep 2001
Posts: 34
|
| kolban wrote: |
| Using ODBC should not block. If the back-end ODBC database is unavailable, an exception will be thrown which can be caught. You could then divert the message to a holding queue to be processed in batch later when the database becomes available. At no time should a message flow ever block or be allowed to block. |
Could you elaborate on this ? What is a holding queue? How can WMQI node can process messages from the queue in a batch ?
Thanks in advance for your cooperation.
Vladimir |
|
| 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
|
|
|
|
