Author |
Message
|
vasanthi |
Posted: Thu Apr 20, 2006 5:03 am Post subject: installing timer node on wbimb 5.0 |
|
|
Apprentice
Joined: 23 Apr 2005 Posts: 42
|
Hi
I want to install the timer node on WBIMB 5.0. Can anybody tell me where i can get the documentation for this.
Thanks
vasanthi |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 20, 2006 5:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
The Timeout nodes from v6 can't be moved to v5.
IA0K was not migrated to run on v5. You can attempt this migration yourself, in the same way all other v2 objects are migrated to v5.
But IAOK has been withdrawn and was not ever supported in the first place - so you'll be completely on your own with it.
Maybe if you explained what you are trying to use the Timer nodes for, we could help with a different option to solve the same problem. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
vasanthi |
Posted: Thu Apr 20, 2006 5:58 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2005 Posts: 42
|
Hi jeff
Thanks for your immediate response. actuall my situation is i am having two flows. each flow is using a jtext adapter to read the data from a file.
In the first flow i need to read the data from a file and update some records in the database and also delete some thousands of records and then set a field value in a table let us say proces='Y'.
The second flow should not start unless the first flow has deleted all the records and reset a flag so that the second flow can start.that is the second flow should start processing the messages only when it sees the Process field set to 'Y'.
so that is why i want to use a timer node so that i can delay the second flow for few minutes until the first flow is completed.
Thanks
vasanthi
But as far as i know the Jtext adapter is going to start processing as soon as it sees a file in the event directory. |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 20, 2006 6:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
Why are you doing these in two flows, then, if there's a dependency between the two?
If you use the Timer node, then what happens if the database the first flow is using is running really slow? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
vasanthi |
Posted: Thu Apr 20, 2006 6:33 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2005 Posts: 42
|
Hi jeff
The reason i am using two different flows is the first flow will be receiving a file and upadting or inserting a data into a table called CONTROL.if that row already exists in the CONTROL table the flow should delete thousands of records from another table and then update the record in the CONTROL table.
There are other 10 different flows that needs to access the data , as i have previously mentioned should check whether the process flag is set to 'Y' before processing the data. And these flows should start processing only when the flag is set to 'Y'.Each of these flows will be having a row in the CONTROL table.So let us say the Process flag for FLOW 1 is set to 'Y' then the flow1 should start processing its data.
Thanks
vasanthi |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 20, 2006 6:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
Using databases as a means of communication between applications is a poor idea.
Using timers to try and emulate an event driven situation is a poor idea.
You have various operations that have to run in a particular sequence, or need to be triggered at certain times. You should try and build system so that it works this way - that operation B always follows operation A, or that operation C is only started when a certain event occurs.
You have to process your files at a different time than when the files are actually available. One way to do this is to have a "load" job that reads the files into a staging table. Then, later you can run a "process" job that will read the staging table and do the right thing.
Otherwise, you can examine more closely if you can use the JText adapter in such a way that you can trigger it to handle the data, rather than having it run automatically. Then you can look at, for example, using an MQ message to trigger the JText adapter rather than a timer. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
EAI Developer |
Posted: Thu Apr 20, 2006 6:58 am Post subject: |
|
|
 Centurion
Joined: 30 Nov 2005 Posts: 101 Location: US
|
Hi,
I think there is a concept called "schedule connector " in WBICS.Don't know about WBIMB.  |
|
Back to top |
|
 |
JT |
Posted: Thu Apr 20, 2006 7:00 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
You can accomplish your objective by using a database trigger (based on the updated column) that writes a MQ message to the Inputq of the 2nd msgflow. |
|
Back to top |
|
 |
rkford11 |
Posted: Thu Apr 20, 2006 7:09 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004 Posts: 316
|
JT wrote: |
database trigger (based on the updated column) that writes a MQ message to the Inputq of the 2nd msgflow. |
I know this is possible with DB2, is this possible with others like Oracle,Sql server, sybase? |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Apr 20, 2006 7:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
rkford11 wrote: |
I know this is possible with DB2, is this possible with others like Oracle,Sql server, sybase? |
Possible, sure.
Presupplied - no, not necessarily.
But all the database systems I know of (except, perhaps, mySQL) support binding external functions into stored procedures or "external functions" through some means or another - so you could bind in the MQ APIs. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
vasanthi |
Posted: Thu Apr 20, 2006 9:10 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2005 Posts: 42
|
Thanks all of you for your response.
JT can you be more elaborate on what you have mentioned.how i can stop my 2nd message flow from picking up the data.as soon as the JText sees a file in the directory it picks it up and starts putting the messages into the second flow.
Thanks
vasanthi |
|
Back to top |
|
 |
rkford11 |
Posted: Fri Apr 21, 2006 10:56 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004 Posts: 316
|
jefflowrey wrote: |
But all the database systems I know of (except, perhaps, mySQL) support binding external functions into stored procedures or "external functions" through some means or another - so you could bind in the MQ APIs. |
Jeff,
can you please elaborate more on these functions(specially for oracle and SQL server), possibly point me to the references.
Thanks |
|
Back to top |
|
 |
|