| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Polling DB using Adapter |
« View previous topic :: View next topic » |
| Author |
Message
|
| dmorales |
 Posted: Wed Sep 24, 2008 10:02 am Post subject: Polling DB using Adapter |
 |
|
Newbie
Joined: 19 Sep 2008
Posts: 1
|
I'm trying to poll a DB SqlServer DB and I dont understand how to extract and the follow step for polling this DB. I'm aprenttice.Can you help me please. I need to know the steps if is necessary
My query is this.
I have a database and I need that from the Adapter doing this to the polling BD
This table is Customer and when entering new record activates the trigger that enters the event to the event store table
up there all right, I have defined the following properties in the configuration file Adapter: ArchiveProcessed = False, ArchiveTableName = ARCHIVE_EVENTSTORE, EventTableName: EVENTSTORE
but still do not understand that then the data that are in store event, that way is correct as well to extract data from a SProcedure?
I dont understand , help me please,
Thank you! |
|
| Back to top |
|
 |
| yumani2 |
| Posted: Wed Sep 24, 2008 10:48 am Post subject: |
|
|
Newbie
Joined: 23 Sep 2008
Posts: 4
|
I'm really new to this thopic, I need steps if posibble?
I am using the WBIAdapter a server that runs on AIX, I created the tables for the event mechanism, I have a table for events and another to archive these events, the schema of my table is as follows:
Event_id NUMBER (20) PRIMARY KEY,
Connector_id VARCHAR2 (40)
Object_key VARCHAR2 (80) NOT NULL,
Object_name VARCHAR2 (40) NOT NULL,
Object_verb VARCHAR2 (40) NOT NULL,
Event_priority NUMBER (5) NOT NULL,
Event_time DATE NOT NULL DEFAULT SYSDATE,
Archive_time DATE DEFAULT SYSDATE,
Event_status NUMBER (5) NOT NULL,
Event_comment VARCHAR2 (100));
and I have a BO, with the same fields, but there are no steps that follow, which I do with the BO, as retrieve data from the event table? ,
In the configuration file Adapter, I have defined the required properties
I'm using MB as transformation tool .
Thanks for the answers
 |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Sep 25, 2008 8:04 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
The events are getting updated on the table, if its not getting retrieved then its an adapter configuration issue.
if its configured correctly, you can even test using Virtual Test Connector to find out the adapter is running fine or not
Please ensure that you have configured properly
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| yumani2 |
| Posted: Thu Sep 25, 2008 9:49 pm Post subject: |
|
|
Newbie
Joined: 23 Sep 2008
Posts: 4
|
It's Ok, The events are getting updated on the table because a trigger exist in the DataBase, But what would the following procedure, previously I recovered from the DB through a store procedure and BO with the verb "Retrieve" using the Adapter and served me well, my question is, now I crate a SP to extract that data and then? which is the union with the file properties of the adapter configuration, the adapter does so automatically wtih the follows properties: Poll Frecuency,PollStart,PollEnd , and so on , Do you understand me?
Thanks !
|
|
| 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
|
|
|
|
