Versions Compared

Old Version 3

changes.mady.by.user Mohamed Elorbany

Saved on

compared with

New Version 4

changes.mady.by.user Gerryn Goh Jo-Vee

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Figure 2: Configure Database Wizard (Load)

NameDescription
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
titleTest the connection parameters

Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.

Table

Table Name.

Key Column

Key Column is the field id from a form.

Figure 3: Advanced

NameDescription
Filter Conditions

Filter Conditions

Extra Conditions 

Additional condition(s) for filtering the data set. HQL is expected here.

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.


Figure 4: Configure Database Wizard (Save)

NameDescription
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
titleTest the connection parameters

Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.

Table

Table Name.

Key Column

Key Column is the field id from a form.

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.