page_gasoline : Rest SQL DataSource + Admin page

Pierre-yves Monnet's picture

page_gasolinetruck

Via this page, you can display easily data coming directly from a database into a Bonita BPM Forms.
The JDBC Datasource is use to have the benefit of the connection pooling.

The Gasoline truck do the same as the DATA SOURCE REST API EXTENSION, plus :
* as a administrative tool to define the query
* can test and see the result of the query, to verify what you have
* can manage multiple datasource
* manage security per request (and not in general)
* base the security on the profile (and not the Permission), to have a better and power control

List the different queries

screenshoot_list.jpg

For each query, define an ID, a SQL request, an explanation, a datasource.
A Delay can be include in the request, to verify how your form will handle a slow query.

screenshoot_query.jpg

Query can contains parameters : just reference it using the format " :
" like
select username from user_ where country = :countrycode

Then, give the parameters value in the REST CALL:
queryid=12&countrycode=FR

screenshoot_RESTCALL.jpg

Category: 
Licence: 
LGPL v3

Downloads

Total downloads: 747
Version BonitaBPM Version Post date Download Link
1.2 7.x 2016-Dec-08 Download
204 downloads
Release note
1.1 7.3.x, 7.2.x 2016-Nov-02 Download
245 downloads
Release note
1.0 7.x 2016-Oct-01 Download
298 downloads
Release note

Issues

Notifications