Using_DataSource_In_IBM_BPM_Process_Designer - uoForms/ebc6230-bpm GitHub Wiki

Using the created Data Source in Process Designer

Prior Steps:

Please see the related tutorials below.

Once these two above steps are performed and Data Source is ready to be used, following steps are to be followed to test the jdbc connection created in (2)

(a) Create a General System Service. This option is available under Implementation

(b) Drag ‘SQL Execute Statement’ which is seen under ‘Implementation’ listed under ‘ToolKits’. Connect using flowlines

(C) Make the necessary changes as seen below, under the propert section’s Data Mapping:

Sql: "Select getdate()";

Return Type: "XMLElement"

DataSourceName:"jdbc/bpmtest"

Create variables suitably:

Initialize the String value to map properly with the XMLElement.

Map this result XMLElement variable in the Propery section as seen below:

(c) Run the process in the debug mode to step through the code: Select ‘Debug’ option which is right next to the ‘Run’ button as seen in the above screenshot.

Click on StepOver to traverse to the result:

With the above result, we can confirm that the connection to the DB is successfully established.