×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

eWay Scheduling

eWay Scheduling

eWay Scheduling

(OP)
I have an eWay with a Java Collab that pulls data from a view in Oracle and writes out the data through another eWay to a flat file.  The only problem I have is I cannot stop the eWay from pulling the data from a view more than once.  I cannot schedule a stop, because I do not know how long it will take to pull the data.  Any suggestions on how to make it stop.  The eWay that pulls the data is the triggering event to kick it all off.

RE: eWay Scheduling

After pulling all data, shutdown the eway programmatically. EGate.shutdownRequest();

RE: eWay Scheduling

(OP)
That did not work on my Java eWay.  I receive the message shutdownRequest() is not available in e*BOB/e*BOS mode!

RE: eWay Scheduling

(OP)
After some additional conversation with SeeBeyond, it was determined that this cannot be done.  That is to say, use a multi-mode eway to pull data (from a view in Oracle) only once and cease pulling the data; while using the multi-mode eWay as the trigger.  The schedule start works great, but the schedule stop is ineffective since it simply shuts down the eWay without sending outgoing messages.  Since I cannot clock the length of time it would take to pull data from the view, I cannot schedule a stop.  This in my opinion make the schedule stop useless.

RE: eWay Scheduling

hello ncaffee!

I had similar problem and i've found a solution.
But why do You want to stop it ? And do you need to read all record from view each time ?
If not U could define global variable with timestamp of last reading from view and control it programmaticaly.
I mean: read records from view in portions (say 1000 records per session), save timestamp and a sign of last processed record in view. Then check the time, compare it to saved timestamp and read next portion of records (here u'll need the sign of last record processed) if you need.
May be this will not help You, if so - explain your situation.

Regards.

RE: eWay Scheduling

Use SeeBeyond Command to stop your eWay when u r done with reading oracle data from the view. This SeeBeyond command will require additional eWay connection which interprets the command issued by your collaboration rule and can shut down/start up the eWay.

RE: eWay Scheduling

You don't need any special connection to do this. Here is a sample code to shutdown a eway.

         // Set the parameters. May be you can read them from database

         String registryHost     = "localhost";
         String schema         = "MyTestSchema";
         String controlBroker     = "localhost_cb";
         String user         = "Administrator";
         String password         = "STC";
         
         // Here the command is shutdown. We can also get the eway name
         // programmatically using EGate.getLogicalName() method.
         String command     = "shutdown ewShutDownTest_MM";

         String exeCommand     = "";

         // Create the shell command to execute
         exeCommand         = "stccmd -rh " + registryHost + " -rs " + schema + " -cb "
                + controlBroker + " -un " + user + " -up " + password +
" -cmd \"" + command + "\"";

         // log some information
         EGate.traceln(EGate.TRACE_EVENT_PUTINLOGMASK,
                                EGate.TRACE_EVENT_INFORMATION, "Sending the shutdown
                                request to shutdown the eway");
         EGate.traceln(EGate.TRACE_EVENT_PUTINLOGMASK,
                                EGate.TRACE_EVENT_INFORMATION, "Command being
                                executed = " + exeCommand);

         // execute the shell command
         Runtime.getRuntime().exec(exeCommand);-

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close