The following command line options instruct GenRocket to test a JDBC connection. Some GenRocket Receivers have the capability to connect to SQL databases via JDBC (e.g. GenericSQLInsertReceiver). Receivers that access databases via JDBC must read from a properties file, on a local computer, in order to attain the necessary information to connect to a database. These two command line options are most commonly used for debugging purposes.
-tjdbc --test-jdbc <propertiesFile>
- <propertiesFile> - the location and name JDBC configuration file.
Example JDBC Configuration File
Below is an example of a JDBC configuration file defined to connect to a MySQL database called, acme:
driver=com.mysql.jdbc.Driver user=root password=openSaysMe url=jdbc:mysql://localhost:3306/acme batchCount=1000
Example Testing Unencrypted Properties File
Example Testing Encrypted File