normal | wide
MAIN arrow Samples-5.1 arrow Multiple Database Call

Multiple Database Call

Print E-mail
Written by KJCh Shivanand on Oct 22 2007

 

zip multipledatabasecall 06/02/2008,06:08 33.16 Kb 

 

Description:

This use case illustrates the functionality of calling database operation by invoking wsdls created using Jdbc connector available in Intalio|BPMS designer. In this process user needs to choose and check out among the four operations: details, insert, modify & delete which operation he needs to perform and get corresponding result for his query.

 

Use case dependencies:

  1. message.xsd
  2. testJDBC
  3. testJDBC.xsd
  4. details.prm
  5. details.sql
  6. insert.prm
  7. insert.sql
  8. modify.prm
  9. modify.sql
  10. delete.prm
  11. delete.sql


Requirements:

  1. Intalio|BPMS Server-5.1.1
  2. Intalio|BPMS Designer-5.1.1
  3. MySQL-5 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 "multipledatabasecall.zip".
  2. Go to File > Import...
  3. Select 'Existing Projects into Workspace', in the wizard and click on Next >
  4. Browse to select the downloaded archive file.
  5. Click to Finish.
  6. Update project builders by right click on project; go to BPMS Designer Tools > Update BPMS Builders.

multipledatabasecall.jpg

 

Defining Configurations:

  • MySQL Database:

  1. All you need to have a table with four fields (empid, empName, designation and projectname) in MySQL-5.
  2. mysql> create table employee (empid varchar(10),empname varchar(25),designation varchar(25),projectname varchar(25));
  3. mysql> insert into employee values ("xxxx","xxxx","xxxx","xxxx"); (please enter at least 3 rows)

 

  • Designer:

  1. To configure jdbc connection:
  2. Refer to the reference guides>Intalio|BPMS Connector for JDBC
  3. Create a Database Connection with the name as testJDBC.

 

  • Server:

  1. Go to [intalio-bpms-server]\var\config\jdbc-connector and create a folder with name as testJDBC.
    Note: The folder names should always be similar to the name given for Database Connections in designer
  2. Create a "connection.properties" file and paste it into the testJDBC folders.
    Note The file can be obtained form the link given above
  3. Paste mysql-connector-5.0.4. jar file under [intalio-bpms-server]\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


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 the following credentials:
    username: "admin" (without quotes).
    password: "changeit" (without quotes).
  6. In the processes list you should see "TestJDBCProcess:TestJDBCProcess" process with a package name "TestJDBCProcess", select it and click to Start.
  7. This should generate a form with four check box fields naming "details", "insert", "modify" and "delete".
  8. Check the checkbox for "details" and click to Invoke.
  9. Again a form generates with an input field to map input data.
  10. Type any employee name in "enterempname" field and then click on Submit button.
  11. This will replace the page with the details of that employee.
  12. Similarly, you can obtain results for other check boxes "insert", "modify", "delete".
Last Updated ( Feb 06 2008 )
  < Prev Next >
[ Back ]