| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC connector and Database nodes in MB |
« View previous topic :: View next topic » |
| Author |
Message
|
| sivareddypv |
 Posted: Wed Aug 24, 2005 6:48 am Post subject: JDBC connector and Database nodes in MB |
 |
|
Newbie
Joined: 11 Aug 2005
Posts: 4
Location: Australia
|
I am in basic level of MB.Can someone please help me with information on
when we use JDBC connector and When we use Database Nodes in Message Broker. As both of them are used for the same purpose. I know few differences but I would like to know the exact differences. Is this concept has anything linked with Coupling and Decoupling.
_________________
sivareddy |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Aug 24, 2005 6:51 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The database nodes can't be configured to automatically respond to changes in the database tables.
The JDBC connector can.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sivareddypv |
| Posted: Wed Aug 24, 2005 7:45 am Post subject: |
|
|
Newbie
Joined: 11 Aug 2005
Posts: 4
Location: Australia
|
Thanks for your answer. In what type of situation we use JDBC connector and when do we use Database nodes. Does the Database connection has to be there continuosly while the flow is running in both cases.
_________________
sivareddy |
|
| Back to top |
|
|
| hopsala |
| Posted: Wed Aug 24, 2005 8:38 am Post subject: |
|
|
Guardian
Joined: 24 Sep 2004
Posts: 960
|
The JDBC adapter is in a seperate program, which is a part of the IBM Adapter Infrastructure; it can be used with message brokers such as WBI and ICS. The Database Node is just a piece of code running within your message flow code.
MB, as you probably noticed, is a message-oriented product; this means that unlike a C program, it doesn't just "run" but has to have something trigger it to start processing. The most basic way of doing so is using an MQGET node.
If you want to trigger the flow to start when someone makes a change in the database, you use the JDBC adapter - it can poll for events in a database table (search JDBC in this site, you'll see many posts on this subject, especially lately).
If you want some MQ message to trigger you, and then write the message content to database, use the Database Node within your flow. Database nodes cannot "start" a flow.
It is worth noting that the JDBC node can do everything a Database Node as well as poll for events; thing is, it takes a long time before you'll learn to work with it, so if you have no buisness need for it, don't use it. |
|
| 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
|
|
|
|
