Introduction

SQL Query lets you perform update/insert/delete queries on your selected database.

SQL Query Properties

Configure SQL Query

Figure 1: SQL Query Properties

NameDescription
Datasource

Target database to execute SQL 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.
Custom JDBC Driver

JDBC driver name.

Example values:

  • com.mysql.jdbc.Driver (MySQL)
  • oracle.jdbc.driver.OracleDriver (Oracle)
  • com.microsoft.sqlserver.jdbc.SQLServerDriver (Microsoft SQL Server)

Only applicable to "Custom Datasource" option.

Custom JDBC URL

Database connection URL.

Example: jdbc:mysql://localhost:3306/jwdb

Only applicable to "Custom Datasource" option.

Custom JDBC Username

Database username.

Example: root

Only applicable to "Custom Datasource" option.

Custom JDBC Password

Specified database user's password.

Only applicable to "Custom Datasource" option.



Query

Figure 2: Query Property

NameDescription
Query

SQL statement that matches the syntax of the specified datasource.

Hash Variable is accepted here.

FAQ

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

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




Related Tutorials & Useful Links








  • No labels