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 *
| |
SQL INSERT Query | INSERT app_fd_table
| |
SQL UPDATE Query | UPDATE app_fd_table
| |
SQL DELETE Query | DELETE FROM app_fd_table WHERE id = {id} |