Call Database Using Axis2

 calldatabaseusingaxis2 14/02/2008,23:41 215.98 Kb

Description:

This use case illustrates the functionality of calling database operation by invoking wsdl created in axis2.
The 4 database operations invoked in this process are:
Insert, Delete, Search and SearchAll
In this process user needs to choose among the given operations which he needs to perform and provide relevant inputs accordingly so as to get output for his query.

Use case dependencies:

1. Option.xform
2. Option.xform.xsd
3. Response.xform
4. Response.xform.xsd
5. ResponseAll.xform
6. ResponseAll.xform.xsd
7. ResponseSearch.xform
8. ResponseSearch.xform.xsd

Requirements:

1. Intalio|BPMS Server-5.1.1
2. Intalio|BPMS Designer-5.1.1
3. DatabaseQueryServiceWS.aar
4. DatabaseQueryServiceWS.wsdl
5. test.xsl
6. test1.xsl
7. Axis2 version 1.3
8. JdbcConnection.txt[connection properties file]
   
9. mysql-connector-java-3[1].1.8-bin.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 ‘CallDatabaseusingAxis2.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.

Work Scenario in the Axis 2:
To upload “DatabaseQueryServiceWS.aar” in the Axis2:

1. Make sure Intalio-bpms server is already started.

2. Open a web browser, provide url as: http://localhost:8080/axis2/.

3. Click on the “Administration” link.

4. Login with the following credentials:
   username: ‘admin’ (without quotes).
   password: ‘axis2’ (without quotes).

5. Click on link to “Upload Service” to upload.

6. Browse to location of “DatabaseQueryServiceWS.aar” to “Upload a AxisService Archive File “ page.

7. Now click on Available Services link and refresh the webpage
   Note: You will see the list of the available services.

8. Verify that “DatabaseQueryServiceWS” is present there.

9. Click on the “DatabaseQueryServiceWS” it displays respective wsdl file.
   Note: This wsdl displays users Ip address in place of localhost in soap address location.you need to save this wsdl file on your system and you need to use in place of existing wsdl.

Configurations:

1. Copy and Paste “JdbcConnection.txt” file in intalio-bpms-server-5.1.1\bin.
2. Copy and Paste"mysql-connector-java-3[1].1.8-bin.jar" in
   1. [Java]\jdk1.5\jre\lib\ext.
   2. [intalio-bpms-server-5.1.1]\repository\com\intalio\bpms\axis2-services\1.1.1\axis2-services-1.1.1.war\WEB-INF\lib.
   3. [intalio-bpms-server-5.1.1]\repository\com\intalio\bpms\pxe\5.1.2\pxe-5.1.2.war\WEB-INF\lib.
   
3. All you need to have a table with four fields (id,bookname,author,price) in MySQL-5.
   mysql> create table book (id int auto_increment NOT NUll primary key,bookname varchar(15),author varchar(15),price varchar(5));
   mysql> insert into book (bookname,author,price) values ("xxxx","xxxx","xxxx"); (please enter at least 1 rows)
   
4. Restart the server if it’s already started so that all the configurations done can become effective next time you start the server.

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/ui-fw which takes to login screen for workflow UI.
5. Login with the following credentials:
   username: 'examples\ewilliams' (without quotes).
   password: 'password' (without quotes).
6. Under Processes tab you should see "Call Database Operations" link, click it to view Option form
7. The form generated displays:
   Text Area where instructions are provided for the respective operations.
   Text Input fields to input data.
   Radio Button to select the operation user wants to perform.
8. Provide the pertinent inputs and click on Start process button to proceed.