retrievingrecords 03/01/2008,04:11 53.60 Kb

Description:

The sample implements a scenario in which user can execute a simple SQL query directly from the bpms console like "select * from book" and output will be displayed accordingly. Here, book is the name of the table from where the values will be fetched.
The WSDL file "JdbcWsdlServiceWS.wsdl" is generated from the "Axis2". The process accepts the input as an SQL query, "select * from book", then it fetches the records from the database "book" and displays the list of the records available in database.

Use case dependencies:

database.xsd: Schema used is of "complex" type.

Requirements:

1. Intalio|BPMS Server-5.0
2. Intalio|BPMS Designer-5.0
3. RetrievingRecords.bpm (bpm file created for this project).
4. JdbcConnection1.txt
5. book.mdb

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 "RetrievingRecords.zip".
2. Go to File > Import...
3. Select 'Existing Projects into Workspace', in the wizard, 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.

Work Scenario in the Axis 2:

To upload "JdbcWsdlServiceWS.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/., that takes to login screen for axis2.
3. Click on the "Administration" link.
4. Login with the following credentials:
   username: "admin" (without quotes).
   password: "axis2" (without quotes).
5. Click on the link to "Upload Service".
6. Browse to location of "JdbcWsdlServiceWS.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 "JdbcWsdlServiceWS" link is present there.
9. Click on "JdbcWsdlServiceWS" link it displays respective wsdl file.
   Note: This wsdl displays users Ip address in place of localhost in soap address location.If you want you can save this wsdl file on your system and use in place of the existing wsdl.

Explanation of the files used:

1. RetrievingRecords.bpm: bpm file created for this purpose.  
2. FileHandlingServiceWS.aar:This file is required to be uploaded in the server i.e. in http://localhost:8080/axis2 so that the service can be deployed.
3. FileHandlingServiceWS.wsdl:This is the wsdl that is required to be invoke in the process.
4. database.xsd: This is the schema that defines the data types required
5. JdbcConnection1.txt: This is the configuration file where we have defined the dsn , username, password.
   Note: Note: You need to paste the configuration file in [intalio-bpms-server]\bin folderand correspondingly change the configurations in this file according to your requirements.
6. book.mdb: The database file that contains records related to fields: Id and Price
   Note: You need to create Data Source with name as "book" and also paste the attached book.mdb file in any of the drives

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. Also verify & check "Deploy processes" choice before 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 "RetrievingRecords:RetrievingRecords" process with a package name "RetrievingRecords", select it and click to Start.
7. This should generate a form with an input field to map input data.
8. Type 'select * from book' in "EvenStartMessageRequest"field then click on Submit button.
9. This will replace the page with an output like:

EventStartMessageResponse:
getSelectedQueryResult:
Order:
Id: 1
Price: 23.0
Order:
Id: 2
Price: 50.0
Order:
Id: 3
Price: 45.0