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.
  

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.