Introduction
What are JDBC Form Binders?
...
| borderColor | green |
|---|---|
| borderWidth | 1 |
| titleBGColor | #ddffcc |
| borderStyle | solid |
| title | Definition |
JDBC Form Binder allows you
...
to use custom SQL statements to retrieve and load records into your form fields. Similarly, you can write SQL statements to save the records in your form field into a database table.
JDBC form binders are located in the form PROPERTIES tab. JDBC form binders can replace the standard Workflow Form Binder.
In a load binder
...
, you only need to configure the datasource and SELECT query
...
. In a store binder, you will
...
need to write SQL statements for SELECT, INSERT, UPDATE, and DELETE database actions.
JDBC form binders have the following exception where this binder cannot be used (revert back to Workflow Form Binder):
- Use of form element workflow variables. JDBC form binders will not populate or update the workflow variables.
- Use of file and image attachment field elements. JDBC form binders will not handle the file retrieval or file transfer into Joget file storage.
Figure 1: JDBC Form Load Binder Properties
...