Sql Server demo project

This project explains how to use Bonita native database connector to call a SqlSserver store procedure, and retrive it results

Usage

our Sql Server demo database is configured with a temp table, and a stored procedure.

sqlServerSetup.sql

link:docs/sqlserver.sql[role=include]

the database connecotr is used 3 times

1. call the store procedure, using process instance id as parameter

2. get the result using process instance id as parameter

3. clean the work table (delete temp record with process instance id)