| Author |
Message
|
| rksuresh |
 Posted: Thu Nov 14, 2002 4:41 pm Post subject: Multiple database instances |
 |
|
Novice
Joined: 11 Apr 2002
Posts: 24
|
We have a message flow which needs to update different oracle instance based on the message that is being received in the queue. We need to change the datasource name dynamically based on the message.
Promoting the datasource property wouldnt work because the datasource has to be set based on the message during the runtime.
What is the best way to accomplish this?
thanks |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Nov 14, 2002 7:33 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You could use different database nodes with different DSN's set in it. Use a filter node to propagate message to appropriate Database node.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| rksuresh |
| Posted: Fri Nov 15, 2002 8:17 am Post subject: |
|
|
Novice
Joined: 11 Apr 2002
Posts: 24
|
Thanks for your reply.
I was thinking about multiple database nodes/Compute node option, but before deciding that route I was wondering if there was any other options available. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Nov 15, 2002 8:30 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Unfortunately, you cannot set DSN name dynamically in standard MQSI nodes.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| rksuresh |
| Posted: Fri Nov 15, 2002 8:39 am Post subject: |
|
|
Novice
Joined: 11 Apr 2002
Posts: 24
|
| Is it possible to accomplish this with a plugin node, what would it take to write a plugin node in Java? I have never written a plugin node, please give me your views about it and any suggested readings. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Nov 15, 2002 9:05 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Yes, this can be done using a Plug-in node. There are few redbooks out there which explains how to write a Java plug-in. Do a search on this forum for "redbook" and you will find the link to the website. I would prefer to use existing nodes than writing a plug-in node.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
