How to exit Que - tJMSINPUT

tnewbie — Sat, 16 Nov 2024 03:48:58 GMT

Hello All,

Question :1

I am using tJMSINPUT to connect to IBM Websphere MQ and am able to read the messages (xml formats). After reading the messages, I want to parse and load them to corresponding tables. The stumbling block here is, after i read the messages the job is consistently connected to Que and is not released, thus placing an implicit lock on the table. so I observed that if i configure my tJMSINPUT component to read 'n' number of messages and quit then i don't have a problem or if i have a time window set (say 5mins) then also no problem because Talend/tJMSINPUT will release the lock and the data will be populated to table. But on the contrary if i want to continuously read messages from queue and populate them to underlying tables, it is not happening and the job is indefenetly looking for the messages to read from Queue.

Question:2

On the same lines, when i read the xml messages, same thing is happening at tXMLMap, not sure why tXMLMap is behaving like a group by function when i am just intending to carry through the record through it.

Please find attached image that shows my job design at a high level...Please advise if there is any other configuration that i am missing to make this happen.

Re: How to exit Que - tJMSINPUT

tnewbie — Tue, 17 Dec 2019 14:48:54 GMT

Hello Gurus,

Can some one shed light on my below questions please 😞

topic How to exit Que - tJMSINPUT in Talend Studio

How to exit Que - tJMSINPUT

Re: How to exit Que - tJMSINPUT