JDBC Palettes and Group Activity in Tibco BW

Welcome to the tutorial series on Tibco. Today, I would brief on how to build a Tibco process using JDBC palettes and group activity iterate through record sets and transaction processing.

Here we will define a JDBC connection to connect to MS SQL.

Lets build a process to fetch records from database using JDBC query as shown. Run the process to see the result set.

Test and verify the dataset.

Now, we would build another process to update specific record using parameterizing query as shown. 

Lets refactor the process to update each records using group along with JDBC Query activity.

..

...

Lets induce a failure for customer two while updating the credit score as shown. Run the process and see customer one data is updated though process failed while updating the customer 2.

In order avoid inconsistency, lets completely have the update process in a transactional group as shown. 

Test and verify the behavior, see that on failure previous updated data are rolled backed.

The video demonstration is available on the Youtube, here is the embedded video.