Description
There are many test case scenarios where the synthetic test data needs to be inserted directly into an SQL database. The GenRocket Engine can insert synthetic test data into an SQL with itsGenericSQLInsertV2Receiver. The GenericSQLInsertV2Receiver can connect to an SQL database via JDBC with an internally user-defined config.properties file.JDBC stands for Java™ EE Database Connectivity.
In Java EE development, this is a well-known and commonly used technology for implementing database interaction. JDBC is a call-level API, meaning that SQL statements are passed as strings to the API, which then takes care of executing them on the RDMS.
Notes:
- The GenericSQLInsertV2Receiver can only connect to an SQL database via JDBC within the test environment via a JDBC configuration file.
- The GenRocket Cloud has no access to a test environment’s databases.
In This Article
GenRocket/JDBC Single Server Example
The diagram below shows an example of the GenRocket components and the Client’s test MySQL database on the same machine. The closer the GenericSQLInsertV2Receiver is to the database (e.g., the same machine), the better and faster the synthetically generated data will be inserted into the database.
GenRocket/JDBC Double Server Example
The diagram below shows an example of the GenRocket components and the Client’s MySQL database on separate machines. Please keep in mind that the closer theGenericSQLInsertV2Receiver is to the database (e.g., the same machine), the better and faster the synthetically generated data will be inserted into the database.
Additional Information
The following articles can be used to learn more about connecting to Databases:
| Topic | Description |
| Supported Databases | See a list of databases supported by GenRocket. |
| How to Connect Runtime to Database | See the basic steps for setting up GenRocket Runtime to connect to a database. |
| How do I Structure Resource Subdirectories to Store Config Files? | Learn how to structure subdirectories for storing multiple configuration files for databases. |
| How do I Encrypt Config and Property Files? | Learn how to encrypt configuration and property files using the GenRocket runtime encrypt file command. Only GenRocket Runtime can decrypt files encrypted with this command. |
| Generating Data for a Remote Database | Learn more about recommendations for generating data for a remote database. |
| How do I connect to an MS SQL database with GenRocket Runtime? | View a step-by-step guide for connecting to an MS SQL database. |
| How do I connect to an Oracle database with GenRocket Runtime? | View a step-by-step guide for connecting to an Oracle database. |
| How do I connect to a MySQL database with GenRocket Runtime? | View a step-by-step guide for connecting to a MySQL database. |