Figure 3: Configure Store JDBC Binder

Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. Example:

com.mysql.jdbc.Driver

Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. Example:

jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.

The SQL query specific to your database type (MySQL, MSSQL, Oracle, etc.). Use syntax like {field_id} in query to inject submitted form data.

SELECT * FROM app_fd_table 
WHERE id = '#requestParam.id#'

Note: If you use JDBC in a form grid or spreadsheet for load /or save binder, be advised the SQL syntax is different from the aboveform load or save binder. Kindly download and view the sample app for JDBC in a form grid at the bottom of this pageor spreadsheet.

Use syntax like curly brackets {field_id} in query to inject submitted form data. 

INSERT app_fd_table 
       (id, 
        c_name, 
        c_emailaddress) 
VALUES ({id}, 
        c_contacttel) 
VALUES ({id}, {name}, 
        {emailAddress}) 

You can use {uuid} to tell Joget to create a random unique id or a "Universally unique identifier". Example:

INSERT app_fd_table
       (id,
        c_name,
        {namec_emailAddress
VALUES ({uuid}, 
        {emailAddressname}, 
        {contactTelemailAddress}) 

Note: Be advised JDBC load/save binders cannot be used if your form or form grid has file or image attachment field elements. You will need to use the default Multirow Form Binder in this circumstance.

Use syntax like curly brackets {field_id} in query to inject submitted form data.

UPDATE app_fd_table 
SET    id = {id}, 
       c_name = {name}, 
       c_emailaddress = {emailAddress}, 
       c_contacttel = {contactTel} 
WHERE  id = {id} 

Used in deleting SQL statement to delete form data records in Datalist/Grid element. Use syntax like curly brackets {id} in query to inject form data primary key value.

DELETE FROM app_fd_table 
WHERE  id = {id}