JDBC Form Binder allows you to customize how form data is stored and/or loaded, either from Joget or custom database via user-defined SQL statements. Note that, as a load binder, you only need to configure the datasource and SELECT query ; as a store binder, you will also need to write SQL for INSERT, UPDATE, and DELETE. |
This is a new feature in Joget Workflow v6. |
Figure 1: JDBC Form Binder Properties
Name | Description | |
---|---|---|
Datasource |
By selecting Default Datasource, the database your Joget is currently using will be selected. | |
Custom JDBC Driver | Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC Username | Custom JDBC Username. This field is required when Custom Datasource is selected in Datasource above. | |
Custom JDBC Password | Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.
| |
SQL SELECT Query | Example of a MySQL statement for Load & Save Binders SELECT * FROM app_fd_table WHERE id = '#requestParam.id#' | |
SQL INSERT Query | INSERT | |
SQL UPDATE Query | UPDATE | |
SQL DELETE Query |