ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing External Databases Within MQSI

Post new topic  Reply to topic
 Accessing External Databases Within MQSI « View previous topic :: View next topic » 
Author Message
gowdy
PostPosted: Sun Oct 07, 2001 2:04 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
NickB
PostPosted: Mon Oct 15, 2001 1:11 am    Post subject: Reply with quote

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
View user's profile Send private message
gowdy
PostPosted: Mon Oct 15, 2001 1:50 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
wolstek
PostPosted: Mon Oct 22, 2001 5:40 am    Post subject: Reply with quote

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
View user's profile Send private message
Bob
PostPosted: Mon Oct 22, 2001 11:14 am    Post subject: Reply with quote

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
View user's profile Send private message
gowdy
PostPosted: Tue Oct 23, 2001 12:34 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing External Databases Within MQSI
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.