| Author |
Message
|
| tbenyacs |
 Posted: Wed Oct 03, 2007 8:01 am Post subject: WebSphere MQ 6 - ORACLE 10g connection |
 |
|
Novice
Joined: 19 Apr 2007
Posts: 18
Location: Budapest, HU
|
Hi, Everybody,
I dealing with WebSphere MQ 6 - ORACLE 10g connection.
I have to PUT / GET messages to / from a remote QM via ORACLE Messaging Gateway.
The Ora scripts are the following:
'
DECLARE
v_options sys.mgw_properties;
v_prop sys.mgw_mqseries_properties;
BEGIN
v_prop := sys.mgw_mqseries_properties.construct();
v_prop.max_connections := 1;
v_prop.interface_type := Dbms_Mgwadm.JMS_QUEUE_CONNECTION; --MQSERIES_BASE_JAVA_INTERFACE
v_prop.username := 'UserName';
v_prop.PASSWORD := 'Password';
v_prop.hostname := '192.168.0.77';
v_prop.port := 1417;
v_prop.channel := 'SYSTEM.DEF.SVRCON';
v_prop.queue_manager := 'QM_GENCS';
v_prop.outbound_log_queue := 'SYSTEM.JMS.D.SUBSCRIBER.QUEUE';
-- Specify a WebSphere MQ durable subscriber queue to be used with the
-- log topic.
-- v_options := sys.mgw_properties(
-- sys.mgw_property('MQ_JMSDurSubQueue', 'ORA_LOG'));
Dbms_Mgwadm.create_msgsystem_link(
linkname => 'mqjms', properties => v_prop, options => v_options );
END;
------------------------
BEGIN
Dbms_Mgwadm.register_foreign_queue(
NAME => 'testmq',
linkname => 'MQJMS',
provider_queue => 'ORA_IN',
domain => Dbms_Mgwadm.DOMAIN_QUEUE);
END;
------------------------
BEGIN
Dbms_Mgwadm.add_subscriber(
subscriber_id => 'sub_aq2mq',
propagation_type => Dbms_Mgwadm.outbound_propagation,
queue_name => 'ADMIN.QUEUE',
destination => 'TESTMQ@MQJMS');
END;
'
The error message in the oramgw*.log (Messaging Gateway log) is the following:
'
>>2007-10-03 17:29:18 MGW Engine 0 EXCEPTION main
java.lang.NoClassDefFoundError: com/ibm/mq/jms/MQConnectionFactory
at oracle.mgw.drivers.mq.jms.MQJmsLink.<init>(MQJmsLink.java:9
at oracle.mgw.drivers.mq.MQLinkParamsNFactory.createMsgLink(MQLinkParamsNFactory.java:339)
at oracle.mgw.engine.MsgLinkMgr.addLink(MsgLinkMgr.java:64)
at oracle.mgw.engine.Agent.initAgent(Agent.java:468)
at oracle.mgw.engine.Agent.start(Agent.java:132)
at oracle.mgw.engine.Agent.agentMain(Agent.java:698)
'
The 'v_prop.channel := 'SYSTEM.DEF.SVRCON';' is OK.? If NOK, which type of channel have to specify?
What is the trouble?
Thanks for the help!
_________________
Tamas Benyacs |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Oct 03, 2007 8:23 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The trouble maybe is that you don't have the MQ client installed on the Oracle machine, and have all the necessary MQ classes on the classpath.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 03, 2007 8:18 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
Does the user starting the gateway / oracle have the jars needed on the classpath? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| tbenyacs |
| Posted: Thu Oct 04, 2007 12:33 am Post subject: |
|
|
Novice
Joined: 19 Apr 2007
Posts: 18
Location: Budapest, HU
|
| jefflowrey wrote: |
| The trouble maybe is that you don't have the MQ client installed on the Oracle machine, and have all the necessary MQ classes on the classpath. |
The Oracle database, Messaging Gateway and the Websphere queue manager are in the same host therefore there is not a MQ client in this machine. It is maybe a problem?
_________________
Tamas Benyacs |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 04, 2007 12:47 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
You'd still need the client installed if you're trying to establish a client connection.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Oct 04, 2007 12:55 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
I am not sure, whether IBM has come up with the fix pack for 2 Phase commit transactions with Oracle Database.
As there is an issue with MQ 6 at first...
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Oct 04, 2007 3:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Gayathri - I don't see how that would result in a noClassDefFoundError...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tbenyacs |
| Posted: Thu Oct 04, 2007 4:56 am Post subject: Ora10 - WMQ6 connection |
|
|
Novice
Joined: 19 Apr 2007
Posts: 18
Location: Budapest, HU
|
| Vitor wrote: |
| You'd still need the client installed if you're trying to establish a client connection. |
I have an MQ 6 Client on the host.
The question is that the Ora 10 MGW knows the WebSphere MQ V6 or only V5.3?
_________________
Tamas Benyacs |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Oct 04, 2007 5:05 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Sorry Jeff, thats only an information.
CLASSPATH haven't exported properly i believe in this part.
request you to check the proper jar files are present in the respective dir
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Oct 04, 2007 2:15 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| tbenyacs wrote: |
| jefflowrey wrote: |
| The trouble maybe is that you don't have the MQ client installed on the Oracle machine, and have all the necessary MQ classes on the classpath. |
The Oracle database, Messaging Gateway and the Websphere queue manager are in the same host therefore there is not a MQ client in this machine. It is maybe a problem? |
Sure seems one to me. AFAIK the Oracle Messaging Gateway tries to establish a client connection to MQ...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| tbenyacs |
| Posted: Tue Oct 09, 2007 6:52 am Post subject: |
|
|
Novice
Joined: 19 Apr 2007
Posts: 18
Location: Budapest, HU
|
| fjb_saper wrote: |
| tbenyacs wrote: |
| jefflowrey wrote: |
| The trouble maybe is that you don't have the MQ client installed on the Oracle machine, and have all the necessary MQ classes on the classpath. |
The Oracle database, Messaging Gateway and the Websphere queue manager are in the same host therefore there is not a MQ client in this machine. It is maybe a problem? |
Sure seems one to me. AFAIK the Oracle Messaging Gateway tries to establish a client connection to MQ... |
Thanks for the advices!
I have succeeded in connection the Ora Msg and WS MQ via Srvr Conn channel and java SYSTEM queues.
_________________
Tamas Benyacs |
|
| Back to top |
|
|
|
|
