Page History

Figure 1: Advance - Load & Save 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 question mark (?) in your query to represent the primary key or foreign key.

SELECT * FROM app_fd_table 
WHERE id = ?

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 for load/save, be advised the SQL syntax is different from the above. Kindly download and view the sample app for JDBC in a form grid at the bottom of this page.

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

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

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 form data records in Datalist/Grid element. Use syntax like curly brackets {id} in query to inject form data primary key

DELETE FROM app_fd_table 
WHERE  id = {id}