| Author |
Message
|
| gowdy |
 Posted: Sun Oct 07, 2001 2:04 pm Post subject: |
 |
|
Apprentice
Joined: 17 Jul 2001
Posts: 29
Location: Bournemouth, UK
|
Hi
I need to access a database using a compute node. However, the problem is that we are not allowed direct access to the database. Does anyone out there know of a possible solution (support pac, etc) that we can implement? We know that there is a Java API for the database, but how would I use this within MQSI without creating a specific node. I am using v2.0.1 - do I need to upgrade to 2.0.2 or 2.1?
As ever, help is gratefully received.
Regards
Mark |
|
| Back to top |
|
 |
| NickB |
| Posted: Mon Oct 15, 2001 1:11 am Post subject: |
|
|
Centurion
Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services
|
Mark
What do you mean by "direct access to the database"? Are you saying that you are not allowed to issue SQL calls directly to your database? |
|
| Back to top |
|
|
| gowdy |
| Posted: Mon Oct 15, 2001 1:50 am Post subject: |
|
|
Apprentice
Joined: 17 Jul 2001
Posts: 29
Location: Bournemouth, UK
|
Hi
Due to architectural demands, we are not allowed to make direct SQL calls on a database. Is there any way to, eg use Java to access an API to retrieve the data? Someone mentioned the Java plug-in node for MQSI (ia76) but that does not offer a solution for this problem.
Many thanks, as ever
Mark |
|
| Back to top |
|
|
| wolstek |
| Posted: Mon Oct 22, 2001 5:40 am Post subject: |
|
|
Acolyte
Joined: 25 Jun 2001
Posts: 52
Location: Bristol, UK
|
| Don't know whether this answers your question but you can use the eSQL PASSTHRU statement to call stored procedures though there may be limitations on how much you can do. See the eSQL reference manual for more info |
|
| Back to top |
|
|
| Bob |
| Posted: Mon Oct 22, 2001 11:14 am Post subject: |
|
|
Newbie
Joined: 03 Oct 2001
Posts: 4
|
It seems that what you want to do, is to call an external module from a Compute node. In your case, the external module is doing database calls for you.
If that is the case, I'm not aware of that capability being available in MQSI (although it would be a nice addition).
Things that come to mind are:
1) to write an external program that is triggered by a queue entry and have that program read the queue, call the external database module, add the information to the message, and have the newly created queue output processed by your message flow
2) to send a message with reply to an external program that does the steps in 1) above except that the message is placed on the reply queue instead of the newly created queue. |
|
| Back to top |
|
|
| gowdy |
| Posted: Tue Oct 23, 2001 12:34 am Post subject: |
|
|
Apprentice
Joined: 17 Jul 2001
Posts: 29
Location: Bournemouth, UK
|
Thanks all
Those were options we had considered, as well as the Java plug-in node. In the end, we managed to get ODBC access to the database - no problem therefore.
Of the ideas suggested, the most appealing was the putting a message onto a queue which would trigger a process (we considered using Workflow for this) and then put the response back onto a replyToQ.
Thanks again for all your help
Mark |
|
| Back to top |
|
|
|
|
