File Adapter |
- 01 Simple BPM Task Initiator
- 02 BPM Business Rules and Decision Activity
- 03 Service Invocation DB and File Adapters
- 04 BPM as a Web Service, ADF Front End for BPM Process
- 05 Mediator and Conditional Routing
- 06 BPM Composer Run time Process and Rules Editing
- 07 BPM and JMS Adapter
Lets extend the use case where the successfully approved candidates data will be written into DB , those whose applications are rejected would be written into file system . Some of the out of box adapters such as file and database adapter will be used for this purpose Lets Open composite.xml drag n drop database adapter on the composite ,
Give the name as “Rejected Applications”
Select File Write Operation
/tmp is the output folder , %SEQ% is auto generated sequence id appended to file name
Select the XSD (Admission Process XSD ) Save the Composite . Open the BPM Process , drag n drop the Service component next Is Accepted as shown below, In the Implementation select the File Adapter that we just defined, You would need to do Data Association to Student Application Data Object,
DataBase Adapter |
Similarly to above steps open composite and drag n drop DB Adapter, Establish DB Connection if not already available please use the below schema to create table after logging in as sys
--------------------------------------------------- login as sys CREATE USER university IDENTIFIED BY welcome1; GRANT resource, connect to university; ---- login as university --Step 1----------------------------- CREATE SEQUENCE "UNIVERSITY"."STUDENTSEQ" MINVALUE 1 MAXVALUE 100000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; --Step 2---------------------------- CREATE TABLE "UNIVERSITY"."APPLICATIONS" ( "ID" NUMBER NOT NULL ENABLE, "FISTNAME" VARCHAR2(20 BYTE), "LASTNAME" VARCHAR2(20 BYTE), "AGE" NUMBER, "MARKSPERCENT" NUMBER, "RESERVATION" VARCHAR2(20 BYTE), "ANNUALINCOME" VARCHAR2(20 BYTE), "ADMISSIONSTATUS" VARCHAR2(20 BYTE), CONSTRAINT "APPLICATIONS_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "USERS" ENABLE ) --Step 3--------------------------------- CREATE OR REPLACE TRIGGER "ASSIGN_APPL_ID" BEFORE INSERT ON applications FOR EACH ROW BEGIN IF :NEW.ID IS NULL OR :NEW.ID < 0 THEN SELECT STUDENTSEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END IF; END;
Note down JNDI name eis/DB/university
Perform Insert Operation
Import Applications table from University Schema
ID is Auto generated based on Schema , rest of the parameters are part of payload from BPM User Initiator Task
Ensure that STUDENTSEQ is selected
Customize Adapter Service by selecting Module name as Data and Name as Selected Applications
Save all, Now open BPM Process, drag n drop service component after Admin Approval task, select service implementation as the DB Service that we just defined we would need xml transformation to send input payload into database.
Save All, so thats it we are all set to deploy and run the process Summary : Student jcooper enters his student application , based on business rules if his percentage is greater than 70% this application is accepted , needs to be approved by Admin officer jstein, after approval the data is written into Database Alternative flow, if the percentage is less than 70, the student application is rejected by the business rule and his data is written into file system , and his data is stored at /tmp location