| Author |
Message
|
| dcapodic |
 Posted: Thu Jul 27, 2006 9:12 am Post subject: WBIMB and JDBC Adapter.... |
 |
|
Apprentice
Joined: 03 Sep 2003
Posts: 32
|
Hi....
I am just diving into this so this is a basic question but I am sure I will have more in depth ones to follow  I have a need to use the JDBC Adapter from within a message flow. In starting to read the docs, they are very ambiguous about exactly what software I need to make this happen. It is suggested that you can do it directly from WBIMB but then in the manuals themselves it keeps referring to WID and WAS. I am currently running WBIMB 6.0.0.1 and WMQ 6.0.1.0. Can I get the JDBC Adapter to work with just this or do I need something else....do I need the framework itself installed? WAS...WPS....
Thanks....
Dan |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Jul 27, 2006 9:30 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
If you want to run the adapter, you will need atleast the adapter framework and the adapter.
You don't need WAS or WPS to run it. The adapter is suppose to run with any of the broker types as WMB or ICS or WAS. |
|
| Back to top |
|
|
| Dhiren |
| Posted: Wed Aug 23, 2006 3:09 am Post subject: Another question |
|
|
Novice
Joined: 27 Jan 2005
Posts: 17
|
Adding to the original post... could somebody tell me
what version of the Adapter Framework is required to work with WBI MB v6.0 ???
I could only find information on MQSI 2.1 and MB 5 but nothing on MB v6.0...
Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 23, 2006 3:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The only reason you could possibly need the JDBC adapter with WMB is if you need to react to a database insert and cause a message flow to start.
You do not need the JDBC adapter for inserts or updates. You can just use JDBC from a JCN, or just use ESQL or a Database node.
And you could relatively just as easily use a Timer node to trigger a poll of the database.
You need to install the Adapter Framework, and then the Adapter itself. When you do this install, you must specify that you aren't using ICS as your broker. Then you need to create an instance of the adapter and configure it to use MQ as the transport. Then it will put messages onto queues, which can be processed by Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| dilse |
| Posted: Wed Aug 23, 2006 8:24 am Post subject: |
|
|
Master
Joined: 24 Jun 2004
Posts: 270
|
Here is my 2 cents..
JDBC Adapter will poll to the database on regular intervals for any updates, additions, and deletions depends on your requirements and after you configure the connector and create a set of queues that you configured for the Message Broker to use. On any additions, updates and deletes to the database will trigger a message that will be put on a MQ Queue. From there you need to take it and process according to your requirement using a message flow.
DilSe..
_________________
DilSe..
Take life as it comes.. |
|
| Back to top |
|
|
| fitzcaraldo |
| Posted: Mon Aug 28, 2006 7:35 pm Post subject: |
|
|
Voyager
Joined: 05 May 2003
Posts: 98
|
Another 2 cents...
One often overlooked feature of using the adapter is that it decouples the database from the broker. This is especially important if the database is beyond your direct control. If all interaction is via the adapter you can easily handle database outages - eg for backup. Without the adapter you would need to stop those flows requiring direct database access when the database was not available. |
|
| Back to top |
|
|
|
|
