topic Re: Connecting to Websphere MQ in Talend Studio

Connecting to Websphere MQ

Anonymous — Mon, 29 Oct 2018 15:28:24 GMT

Hi,

I’m trying to simply connect to and read from a Websphere MQ, I’ve tried both via tMOM components in a job and cWMQ components in a route. Both seem to struggle to find the correct java classes. I’ve put the following into …TOS\.m2\repository\org\talend\libraries

com.ibm.dhbcore.jar
com.ibm.mq.commonservices.jar
com.ibm.mq.headers.jar
com.ibm.mq.jmqi.jar
connector.jar

Anyone any ideas?

TOS 6.4.1
Wesphere 8.5.5.1

Re: Connecting to Websphere MQ

Anonymous — Mon, 29 Oct 2018 18:41:27 GMT

You likely need to import the dependent jars using the modules view or tLibraryLoad components.

Re: Connecting to Websphere MQ

Anonymous — Tue, 30 Oct 2018 08:20:21 GMT

Thanks @JGM i've done both and now i get the error below

Starting job MQ_Temp at 08:18 30/10/2018.

[statistics] connecting to socket on port 3453
[statistics] connected
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
com.ibm cannot be resolved to a type
com.ibm cannot be resolved to a type

at sandpit_mhe.mq_temp_0_1.MQ_Temp.tMomConnection_1Process(MQ_Temp.java:1418)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_5Process(MQ_Temp.java:1283)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_4Process(MQ_Temp.java:1140)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_3Process(MQ_Temp.java:997)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_6Process(MQ_Temp.java:854)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_2Process(MQ_Temp.java:711)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.tLibraryLoad_1Process(MQ_Temp.java:568)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.runJobInTOS(MQ_Temp.java:2482)
at sandpit_mhe.mq_temp_0_1.MQ_Temp.main(MQ_Temp.java:2308)
[statistics] disconnected
Job MQ_Temp ended at 08:18 30/10/2018. [exit code=0]

Re: Connecting to Websphere MQ

Anonymous — Tue, 30 Oct 2018 09:15:55 GMT

Hi Can you go to the Window -> Show view -> search for modules -> Talend Module view and see the tMom* jars are already downloaded ?

Re: Connecting to Websphere MQ

Anonymous — Tue, 30 Oct 2018 09:58:50 GMT

@rchinta they all seem to be installed ok

Re: Connecting to Websphere MQ

Anonymous — Thu, 01 Nov 2018 11:01:08 GMT

After speaking to Talend Support they identified that it was a corrupted file jms.jar.

The solution

Delete jms.jar file from the TOS .m2 directory and also from Workspace\.Java\lib
Download the correct jar from https://talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/jms/6.0.0/
Import into studio via Talend/Modules view
Check the file was updated in the nexus.