Summary:

This use case illustrates how to fetch values from an array and insert the same into the database.
In this process user input array of names and then the process insert the given names into the database.

Use case dependencies:

1.t_chema.xsd.
2.operation.sql.

Requirements:

1.Intalio BPMS Designer 5.2
2.Intalio BPMS Server 5.2
3.MySQL - 5.0 database.
4.mysql-connector-5.0.4.jar.

Preconditions:

1.Make sure Intalio|BPMS Server is up and running fine.
2.Make sure the Process Explorer pane does not contain any Intalio|BPMS Business Process Project with same name.

Process Download & Import:

1.Download ‘FetchValuesFromArray.zip’.
2.Go to File > Import...
3.In Import wizard, select 'Existing Projects into Workspace', click on Next >
4.Select the "Select archive file" radio button.
5.Browse to select the downloaded archive file.
6.Click on Finish.
7.Update project builders by right click on project; go to BPMS Designer Tools > Update BPMS Builders.

Configurations:

MySQL:
1.All you need to have a table user with one field (name) in MySQL – 5.0.
2.mysql> create table user (name varchar(10));

Designer:
1.To create connection profile refer to given link: http://bpms.intalio.com/tutorials-5.2/setting-up-a-connection-profile.html
2.To create dataabase connector refer to given link: http://bpms.intalio.com/tutorials-5.2/using-database-connectors.html

Server:
1.Paste mysql-connector-5.0.4. jar file under [intalio-bpms -server]5.2.0.050\repository\com\intalio\bpms\pxe\5.1.2\pxe-5.1.2.war\WEB-INF\lib
Note: You can obtain the jar file from [intalio-bpms-server]\repository\mysql\mysql-connector\5.0.4

Scenario to fetch value from array:

1.Go to Data Editor and expand Server node.
2.Right click on assign node given under Server->sequence->Subprocess->sequence->invoke and select “Create assign's <bpel:copy>”.
3.Right click on <bpel:copy> node available under assign node and select Edit
4.In the Edit window provide below given code:
<bpel:copy>
<bpel:from>$thisReceiveRequestMsg.body/tns:name[position()=$count]</bpel:from>
<bpel:to>$processQuery1RequestMsg.parameters/Process1:execute/Process1:parameters/Process1:Name</bpel:to>
</bpel:copy>
5..Click to Apply.

Process Deployment & Execution:

1.Click on Deploy Project to Intalio|BPMS Server button in tool bar.
2.Make sure you select all runtime files while exporting to Intalio|BPMS Server.
3.Click on Finish button..
4.Open a web browser, provide url as: http://localhost:8080/bpms-console, which takes to login screen for bpms-console.
5.Login with following credentials
username: 'admin' (without quotes
password: 'changeit' (without quotes)
Note: Bpms-console will be available with deployed processes list
6.You should see "FetchValuesFromArray:FetchValuesFromArray" process with a package name "FetchValuesFromArray", check the box under project and click to Start.
7.This should generate a form with an input text field.
8.Click on “Add child instance” to add more input text fields [This will create an array type input]
9.Provide values in all the text inputs t, and then click on Submit button.
10.This will replace the page with an output receiveResponse: 0

Note:
This sample is an example to educate user on:
1.How to fetch values from an array in Intalio process..
2.How to insert values fetched from array into the database.

Last Updated ( Dec 30 2008 )

[ Back ]