Figure 1: Database Update Tool Properties

NameDescription
Datasource

Target database to execute statements on.

Choices:-

  • Custom Datasource
    • JDBC Connection Parameters are needed for this choice.
  • Default Datasource
    • Points to the current database your copy of Joget currently connects to.

Figure 2: Database Update Tool Properties - Query

NameDescription
Query

SQL Query. Hash Variable is accepted here.

Q: Can I put in multiple query in the Query itself?

A: It depends on the JDBC driver's capability itself.