| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| from ESQL code call a C shared lib |
« View previous topic :: View next topic » |
| Author |
Message
|
| kvd1998 |
 Posted: Thu Apr 02, 2009 7:15 am Post subject: from ESQL code call a C shared lib |
 |
|
Newbie
Joined: 02 Apr 2009
Posts: 3
|
Hi,
We have requirement to use an C application built in some years back, all it does is connect to DB on request, get the records with status New and then reformat (and have some application logic) each record and once the reformated records are delivered it will update the DB records status as processed. And this application will be initlized on time intervel.
Now we have to call this C built application from message flow. Need your help here, first can we call a C lib file from with in ESQL or Java compute node, if so how. If that is not possible then is it we have to build a User defined node in C and call this age old C application, if that is the case, how will the DB connections made by this old C application will be handled by broker.
Please do provide your suggestions if any other approch can be taken.
Thanks
kvd |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Apr 02, 2009 7:19 am Post subject: Re: from ESQL code call a C shared lib |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kvd1998 wrote: |
| Please do provide your suggestions if any other approch can be taken. |
Port the functionality into ESQL. Doesn't sound too complex, and the effort of redeveloping is going to be much less than the effort of shoehorning this into the broker. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kvd1998 |
| Posted: Thu Apr 02, 2009 7:25 am Post subject: |
|
|
Newbie
Joined: 02 Apr 2009
Posts: 3
|
| Yes we have considered that, but its not neeb agreed to rebuild the whole C application. I have just given what it does, but it has some other logic while reformating these DB records. So re building all that logic is ruled out. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Apr 02, 2009 7:30 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kvd1998 wrote: |
| it has some other logic while reformating these DB records. So re building all that logic is ruled out. |
I still contend this will be easier than a custom node. Especially if you end up with threading issues or some other problem because this app doesn't follow the rules for a custom node.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Apr 02, 2009 7:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
ESQL has no mechanisms for calling external programs. The only thing you can do is call Java procedures.
There is a SupportPac.
You can use Java to call an external program, as well, either from a custom Java node or from a JCN.
In no case will the external program be running "inside" broker. So in no case will Broker have *anything* to do with the database.
Unless you do the sensible thing, and rewrite the functionality in Broker - ESQL, Java, etc.
Without rewriting the entire c program, the *most* sensible thing you can do is add an MQ interface to the C program that will read a request message, do the database logic, and send a reply message. |
|
| 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
|
|
|
|
