Hi,
Please have a look on the attached process that is an answer to your query.
Inorder to execute this process please follow the below given points:
MySQL Database:
All you need to have a table with two fields (Name & Designation) in MySQL-5.
mysql> create table employee (Name varchar (20), Designation varchar (12));
mysql> insert into employee values (‘xxxxx’ ‘xxxxx’);
Designer
1.To configure jdbc connection:
Refer to the reference guides>Intalio|BPMS Connector for JDBC
http://bpms.intalio.com/content/view/184/86/2.Create Database Connection with the name as Process.
Thanks
Chandra