Powered By Blogger

Search This Blog

Showing posts with label DBMS scheduler. Show all posts
Showing posts with label DBMS scheduler. Show all posts

Monday, August 18, 2008

Schedule BPEL process

BPEL: Scheduling reoccuring processes

  • Implement a master process, that has a and a that is configured for the time to make the process sleepling
    • Advantage: It's BPEL
    • Disadvantage: As it contains a wait and some other activities that might lead to (de)hydration, you fill you database
  • Use the Oracle RDBMS Job Scheduler (dbms_job package) that will start your process periodically
    • Advantage: One time implemented, backed up with the DB, and pattform independend
    • Disadvantage: It's bound to an Oracle DB, and you need to know at least some pl\sql, the rest is java
  • Use a Timer EJB (provided with a j2ee compliant java container)
    • Advantage: it's a statefull bean, so it will get saved, and revovered when the container goes down, use java to implement
    • Disadvantage: Dependend on the container you are using
  • Use QUARTZ, the open source scheduler
    • Advantage: It's opensource and Oracle BPELPM uses it for scheduling

Quartz can handle clustering, however it requires the JDBC-Jobstore for that case. We haven’t tested it with an Weblogic cluster. Within a few weeks we’ll have a Weblogic cluster available, and we will test this asap.

I am working on this as I get some documents will share on same page