...

Introduction

...

...

...

...

...

JDBC form binders have Database SQL Query has the following exception where this binder cannot be used (revert back to Workflow to Workflow Form Binder):

• Use of form element workflow variables.  JDBC form binders Database SQL Query will not populate or update the workflow variables.
• Use of file and image attachment field elements.  JDBC form binders Database SQL Query will not handle the file retrieval or file transfer into Joget file storage.

JDBC Binders Database SQL Query comes standard in Joget v6 and DX. If you are using Joget v5, you can download the JDBC Binders from Joget Marketplace.

Image RemovedImage Added

Figure 1: Database SQL Query selected as Load Data From & Save Data To

...

Database SQL Query Properties

Configure

...

Database SQL Query Load

...

Data

Figure 2: Configure JDBC Database SQL Query Binder

SELECT
   * 
FROM
   app_fd_table 
WHERE
   id = ?

SELECT `myAppName.myColumn` FROM app_fd_myTable;

Configure

...

Database SQL Query Data Store

...

Figure 3: Configure Store Database SQL Query Data Store JDBC Binder

Note
If a column name contains reserved keywords, do ensure it is encapsulated properly. For example for MySQL, if the column identifier itself contains a dot symbol ( . ), it should be encapsulated like this: Code Block language sql SELECT `myAppName.myColumn` FROM app_fd_myTable;

store binder binder binder
Form to store uploaded files

Name	Description
Store Binder	JDBC Binder selected (See Figure 1).
Datasource	Custom Datasource - setup to connect to an external database, has additional configuration. Default Datasource - connect to the Joget database. By selecting Default Datasource, the database your Joget is currently using will be selected. (See Figure 3).
Custom JDBC Driver	Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. Example: com.mysql.jdbc.Driver
Custom JDBC URL	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 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. Info title Test the connection parameters Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.
SQL SELECT Query for	Data Store	The SQL query specific to your database type (MySQL, MSSQL, Oracle, etc.). Use syntax like {field_id} in query to inject submitted form data. Code Block language sql title Example linenumbers true SELECT * FROM app_fd_table WHERE id = {id} Note: If you use JDBC in a form grid or spreadsheet for load or save	data store, be advised the SQL syntax is different from form load or save	data store. Kindly download and view the sample app for JDBC in a form grid or spreadsheet.
SQL INSERT Query	Use syntax like curly brackets {field_id} in query to inject submitted form data.  Code Block language sql title Example linenumbers true 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: Code Block language sql title Example linenumbers true INSERT app_fd_table (id, c_name, c_emailAddress VALUES ({uuid}, {name}, {emailAddress}) For JDBC SQL INSERT in a grid, use "{foreignKey}" syntax to populate the parent id into the child table foreign key value, as follows: Code Block INSERT app_fd_table_child ( id, c_name, c_fk) VALUES ( {uuid}, {name}, {foreignKey})
SQL UPDATE Query	Use syntax like curly brackets {field_id} in query to inject submitted form data. Code Block language sql title Example linenumbers true UPDATE app_fd_table SET id = {id}, c_name = {name}, c_emailaddress = {emailAddress}, c_contacttel = {contactTel} WHERE id = {id}
SQL DELETE Query	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. Code Block language sql title Example linenumbers true DELETE FROM app_fd_table WHERE id = {id}
Handling for field workflow variable?	Click the checkbox if you are using workflow variables mapping in your form elements. The JDBC binder will copy the field value to the workflow variable when you submit the form if the form is mapped to a  process. Not applicable to grid elements.
Handling for uploaded files?		Click the checkbox if you are using file or image attachments in your form elements. The JDBC binder will save your file or image attachment into the ".\wflow" folder when you save the form. Select form to store uploaded files only if you are using a form grid or spreadsheet.
Form to store uploaded files	Select form to store uploaded files only if you are using form grid or spreadsheet.

Understanding JDBC Errors

SELECT * FROM app_fd_table WHERE id = ?

Related

...

Database SQL Query Data Store

• Database SQL Query Options
• Database SQL Query List Action
• List Database SQL Query
• JDBC Options Binder
• JDBC Datalist Action
• JDBC Datalist Database Binder

Download Demo Apps

• Demo app using JDBC Form Binders for MySQL database:  APP_jdbc_load_store_form_binder_dx_kb.jwa  
• Demo app using JDBC Form Grid Binders for MySQL database:  APP_form_grid_with_jdbc_binder.jwa 
• Demo app using JDBC in List Grid for MySQL database:  APP_list_grid_multirow_jdbc_dx_kb.jwa  
• Demo app using JDBC Form Binders for Oracle database:  APP_example_form_jdbc_on_oracle_v6.jwa 
• Demo app using JDBC Form Grid Binders for Oracle database:  APP_jdbc_form_grid_oracle_dx_kb.jwa