| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle Procedural Gateway for MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| gfrench |
 Posted: Fri May 05, 2006 2:44 am Post subject: Oracle Procedural Gateway for MQ |
 |
|
Acolyte
Joined: 10 Feb 2002
Posts: 71
|
Is this a good thing to use? The developers have experience of oracle stored procs and not programming or jms or jdbc, so we are looking for simple and cheap.
In reading the doc it specifies the standard type MQ stuff, client or server etc. We will use MQ Client and it discusses QUEUE_MANAGER and MQSERVER parms in the initsid.ora.
Does anyone know if there is any scope to use standard mq client wild card selection on queue manager name and could I use channel table instead of the MQSERVER parm.
Just really being lazy and want user experience before commiting to it.
Thanks in advance
Graham |
|
| Back to top |
|
 |
| tleichen |
| Posted: Fri May 05, 2006 12:55 pm Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
Either method should work, in theory. Out of curiosity, what platforms are you using for both MQ client and the QMGR(s)?
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri May 05, 2006 8:47 pm Post subject: Re: Oracle Procedural Gateway for MQ |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| gfrench wrote: |
Is this a good thing to use? The developers have experience of oracle stored procs and not programming or jms or jdbc, so we are looking for simple and cheap.
In reading the doc it specifies the standard type MQ stuff, client or server etc. We will use MQ Client and it discusses QUEUE_MANAGER and MQSERVER parms in the initsid.ora.
Does anyone know if there is any scope to use standard mq client wild card selection on queue manager name and could I use channel table instead of the MQSERVER parm.
Just really being lazy and want user experience before commiting to it.
Thanks in advance
Graham |
We use the Oracle Messaging gateway.
As connection parms you supply the channel, the host the port.
You have to supply 4 queues reserved for gateway usage in, out, err in, err out.
The rest is setup between MQ and the gateway and AQ. Oracle procs will help you with that.
Enjoy 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
