Skip to content

Latest commit

 

History

History
20 lines (13 loc) · 560 Bytes

README.adoc

File metadata and controls

20 lines (13 loc) · 560 Bytes

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)