| Author |
Message
|
| broker_new |
 Posted: Fri Aug 15, 2008 2:26 pm Post subject: Oracle--> MQ Connectivity |
 |
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
I have requirement which is as follows.
There will be a trigger which will be monitoring a table.
Whenever there is any update in anyone of the records it should be able to write the record on the queue.
I know that we need to install maoi support pac on Oracle database.
I would like to know, are there any prerequisites for installing this support pac.Because we have faced some problems in compiling the C programs.
Do we need to install a MQ client on the Oracle database.
Is there anyother way of doing this other than installing the support pac...
 |
|
| Back to top |
|
 |
| sridhsri |
| Posted: Fri Aug 15, 2008 8:09 pm Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
| I do not know this support pack. But I can tell you this, any application that needs to send a message to MQ will need access to the MQ APIs - in this case MQ Client. |
|
| Back to top |
|
|
| broker_new |
| Posted: Fri Aug 15, 2008 9:31 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
sridhsri, I agree with you that we need to set up MQ client on Oracle database.
But this support pac didn't have any pdf (as other support pacs do) explaining the steps that need to be followed instead it has a readme file which is not so explanatory. |
|
| Back to top |
|
|
| harish_td |
| Posted: Sun Aug 17, 2008 10:30 am Post subject: |
|
|
Master
Joined: 13 Feb 2006
Posts: 236
|
Hi,
I remember using a JDBC Adapter that was earlier part of WBI framework.
It could be configured to poll a DB and generate a Business Object.
I wonder whether it is still being supported.
Just my two cents,
Harish |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sun Aug 17, 2008 8:52 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| harish_td wrote: |
I remember using a JDBC Adapter that was earlier part of WBI framework.
It could be configured to poll a DB and generate a Business Object.
I wonder whether it is still being supported.
|
WBI Adapters are there,
Currently IBM is promoting WebSphere Adapters.
architectural wise both are different.
In this scenario, we just need to know where the oracle is located,
monitoring the table is being doing by the trigger program, there are lot of options you can think off in this case
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| vaibhav_vy |
| Posted: Mon Aug 18, 2008 1:29 am Post subject: |
|
|
Apprentice
Joined: 04 Aug 2008
Posts: 28
|
Definitely WBI JDBC adapter can help in this situation by creating event/archive tables & writing triggers which will populate these tables after detecting any database event.
Right now, there is no support for WebSphere JDBC adapter/ node for new Broker version. IBM recommands to use WebSphere nodes as they run as part of Broker Runtime, so no need to monitor different adapters for High Availability. But you can use many other alternatives as already discussed in this thread. |
|
| Back to top |
|
|
|
|
