Page History

...

Panel

borderColor	purple
borderWidth	1
titleBGColor	#ddccff
borderStyle	solid
title	New Feature

This is a new feature in Joget Workflow v6.

Image RemovedImage Added

Figure 1: JDBC Form Load Binder Properties

Name

Description

Datasource

Custom Datasource
Default Datasource

By selecting Default Datasource, the database your Joget is currently using will be selected.

Custom JDBC Driver

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

Custom JDBC URL

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

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

Use question mark '?' in your query to represent primary key or foreign key

Code Block

language	sql
linenumbers	true

SELECT

SELECT

* FROM app_fd_table WHERE id = ?

Image Added

Figure 2: JDBC Form Store Binder Properties

Name

Description

Datasource

Custom Datasource
Default Datasource

By selecting Default Datasource, the database your Joget is currently using will be selected.

Custom JDBC Driver

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

Custom JDBC URL

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

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

Code Block

language	sql
linenumbers	true

SELECT

id = '#requestParam.id#'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.

SQL INSERT Query

Use

syntax

like

curly

brackets

{field_id}

in

query

to

inject

submitted

form

data

.

Code Block

language	sql
linenumbers	true

INSERT

 app_fd_table

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

 
       (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.


SQL UPDATE Query	Use

syntax

like

curly

brackets

{field_id}

in

query

to

inject

submitted

form

data

.

Code Block

language	sql
linenumbers	true

UPDATE

 app_fd_table

SET id =

 
SET    id = {id},

 
       c_name

 {name},

 
       c_emailaddress

 {emailAddress},

 
       c_contacttel

 {contactTel}

WHERE id =

 
WHERE  id = {id}

SQL DELETE Query

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

Code Block

language	sql
linenumbers	true

DELETE

 FROM

 app_fd_table

WHERE id =

 
WHERE  id = {id}

Below is a are sample app apps to demonstrate the use of JDBC Load and Save Binder. All the above SQL statements are in this demo app:

APP_jdbc_example.jwa

Binders:

Example app using JDBC binders on Form APP_form_load_save_using_jdbc.jwa.
Example app using JDBC binders on Form Grid APP_form_grid_with_jdbc_binder.jwa.
Example app using JDBC binders for Oracle databases APP_example_form_jdbc_on_oracle_v6.jwa

...

Space shortcuts

Page tree

Versions Compared

Old Version 12

New Version Current

Key