1. PlugIns
  2. JdbcSlim

Summary of all flags and commands

Fixtures defined by JDBC Slim


1. SQL Command


2. Define Properties


This fixture is used to define 4 different kinds of properties

General Properties used by SQL Command

Define Properties Name for Reference
key value
first key value

JDBC Database Connection Properties

Define Properties Name for Reference
key value
first key value

Default Values

Define Properties Name for Reference
key value
column name default value

Input & Output Parameters

Define Properties Name for Reference
key value
column name In/Out:Position:Type:Scale

3. JDBC Authenticator



List of all flags supported by SQL Command

Key Default Value Example values separated with / Usage

Connection Parameters
jdbcDriver org.h2.Driver Class name of the jdbc driver
dbUrl jdbc:h2:mem:h2db database connection string
dbProperties Reference to another properties list which contains properties for the database connection. Check the documentation of your jdbc driver for the list of all possible properties. Normally the mandatory properties are username and password See
dbUser Name of the database user which will be used to open the database connection
dbPassword Password of the database user which will be used to open the database connection
dbAutoCommit true true / false if false an explicit commit is required to make the changes visible in the database to other programs.
dbConnection Name of a Connection to be able to reuse it See Or to use a connection object created externally See

Command Parameters
CMD select * from table the SQL command to be executed. This parameter is mandatory.
QUERY false true / false If the SQL command is a query statement without place holders and which returns multiple rows than set this flag. In the header row the question mark in each column can then be omitted as all columns are output columns. See
dbQueryParameters ParameterDefinitions Reference to another properties list which contains the definitions for input and output parameters of an SQL statement. See
inputDefaults DefaultValues Reference to another properties list which contains default values for placeholders in an SQL command. See
RETRY false 50:10000 if given re-executes the command until all assertions pass or the maximum execution time has passed. The first parameter is the number of retries the second parameter the maximum execution time in milliseconds. See

Input / Output Options
SORT false true / false sort the output result based on indicators in the header line. See
SUBQUERY false true / false Ignore additional rows in the result set See
dbUpdateCount Count false / Count If not 'false' return the no of updates / inserts /deletes done by the SQL command. A column with the header named as the value of this flag is added to the results. See
dbGetgeneratedKeys true add ID generated by the database to the result
outputFlagUnusedInputColumns true true / false If true and the table has input columns which are not used by any place holder than these columns will be marked as fail and the test will fail. Either remove these columns or set this flag to false. See
outputFlagExtraOutputColumns true true / false If true and the result set has columns which are not in the table than these columns will be marked as fail and the test will fail. Change the SQL Command to not return extra columns or set this flag to false.
outputNullString #null# String used to display null values. See
inputNullString #null# String used to insert the value null into the database. If undefined the value from outputNullString will be used. See

Performance Metrics
dbOnlyRowCount false RowCount/ Rows Instead of returning the data of the result-set returns only the row count of the same. A column with the header named as the value of this flag is added to the results. See
dbPerf false ProcessingTime Sum of dbPerfRetrieval and dbPerfExecution. A column with the header named as the value of this flag is added to the results. See
dbPerfRetrieval false RetrievalTime Time in seconds to retrieve the result data from the DB server into the Slim Server. A column with the header named as the value of this flag is added to the results. See
dbPerfExecution false ExecutionTime Time in seconds to execute the SQL command. A column with the header named as the value of this flag is added to the results. See

Specials
DEBUG false false / true If true prints debug information. Should only be used by Jdbc Slim developers
dbUseColumnName true If false then don't use user defined SQL column names. See
outputMultipleRecordsets AsExtraColumns true true / false If the SQL command returns multiple result sets than these are joined into a single row. Set this parameter to false to get the data in separate rows. This is experimental as multiple recordsets returned from one command are unusual.
jdbcMaxloops 100 An Integer value which defines the maximum numbers of record sets and update counts which can be returned by a single SQL command. This is a safety parameter to avoid endless loops in case a JDBCdriver is badly written. Don't use.