Page History

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:3307/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 =  {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 form load or save binder. Kindly download and view the sample app for JDBC in a form grid or 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}, 
        {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,
        c_emailAddress
VALUES ({uuid},
        {name},
        {emailAddress})

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} 

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}