You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Introduction

Database Update Tool lets you perform update/insert/delete queries on your selected database.

Database Update Tool Properties

Configure Database Update Tool

Figure 1: Database Update Tool 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