Skip to content

VerdictDB JDBC Properties

VerdictDB supports a number of configurable properties, which can be written as key=value pairs inside JDBC connection string. The currently supported properties are as follows:

  • verdictdbmetaschema: sets the name of schema/database that VerdictDB will use to store metadata of scrambled tables.
  • verdictdbtempschema: sets the name of schema/database that VerdictDB will use to create scrambled tables.
  • loglevel: sets the minimum level of logs that VerdictDB will print out to the console. Possible values are {error, warn, info, debug, trace}.
  • file_loglevel: sets the minimum level of logs that VerdictDB will print out to the log file . Possible values are {error, warn, info, debug, trace}.

For example, a JDBC connection string with VerdictDB-specific properties can be written as:

String connectionString =
    String.format("jdbc:verdict:mysql://%s:%d/%s?verdictdbmetaschema=myverdictdbmeta&" +
        "verdictdbtempschema=myverdictdbtemp&loglevel=debug",
        MYSQL_HOST, MYSQL_PORT, MYSQL_DATABASE);
Connection vc = DriverManager.getConnection(connectionString, MYSQL_USER, MYSQL_PASSWORD);

With the above JDBC connection string, VerdictDB will create metadata tables in the database myverdictdbmeta and scrambled tables in myverdictdbtemp, and every log with log level higher or equals to debug will be printed out to the console.