Skip to main content

Executing Database Queries using the Database Executor Script

This page introduces the Database Query Executor that uses CLI commands.


  • Scripts take a long time to execute.

  • To prevent access attempts to IAST while executing the script, you have to stop the Access Control and CxIAST Manager services before running it.

Help (-h or --help)

This parameter displays all available options in CLI mode.

java -jar db-query-executor.jar -h

Generating the Example Config File (-c or --config-file)

This parameter creates a config properties file with all the required parameters.

java -jar db-query-executor.jar -c

Running Scripts (-f or --file)

To execute this application, you have to declare all the parameters in a config property file:

  • The JDBC's connection string

  • The scripts to be executed

java -jar db-query-executor.jar -f


Check the required properties below:

conn (String) - JDBC connection string - refer to for

additional information;

  • Example: jdbc:sqlserver://localhost\SQLEXPRESS:1403;username=USER;password=PAS


  • scripts.passwords (boolean) – a flag to define, if the password script should be


  • (boolean) – a flag to define, if the credit card script should be


At least one of these scripts should be defined as true.

As mentioned previously, it is possible to use the config file generator (-c or --config-file

parameter) to generate the required property file.