Table of Contents

Introduction

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

Database Update Tool Properties

Image Added

Figure 1: Database Update Tool Properties

Image Removed

Figure 1: Database Update Tool Properties

Name	Description	Screens (Click to view)
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	JDBC 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.

Image Added

Figure 2: Query Property

Screens (Click to view)

Image Removed

Figure 2: Query Property

Name

Description

Query

SQL statement that matches the syntax of the specified datasource.

Hash Variable is accepted here.

Info

title	FAQ

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

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