Skip to main content

Executing Database Queries using the Database Executor Script

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

Note

  • 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

Config.Properties

Check the required properties below:

conn (String) - JDBC connection string - refer to https://docs.microsoft.com/enus/sql/connect/jdbc/building-the-connection-url?view=sql-server-2016 for

additional information;

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

    SWD;databaseName=MY_DATABASE

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

    executed

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

    executed

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.