DATA GENERATOR FOR MYSQL HOW TO
DATA GENERATOR FOR MYSQL DRIVER

The resource in this image points to the dev folder. Step 2: Next step is to add a new resource named in the GenRocket Web.

Url=jdbc:mysql://localhost:3306/employee?rewriteBatchedStatements=true If you are connecting to a different type of database your configuration file will look different. GenRocket will read this config file and connect to employee database on localhost using username root and password root. This property is only mandatory for GenRocket Receivers.Д®xample config.properties for MySQL database

batchCount - Defines the number of SQL statements that are batched together and sent to the database for execution.

url - Defines the specific URL to access the database.

password - Defines the password used to access the database.

user - Defines the Username used to access the database.

DATA GENERATOR FOR MYSQL DRIVER

The actual driver file must be placed in the $GEN_ROCKET_HOME/lib folder on your local computer.

driver - Defines the name of the specific database driver to use to access the given database.

A va application can connect a SQL database via JDBC by reading a JDBC properties file that contains the following information: GenRocket can connect to any database that supports JDBC.Д¬onnection Steps Step 1: Create a JDBC Configuration Properties FileДЇor GenRocket to connect to a database via JDBC you will need to create a config.properties file.

JDBC stands for Javaв„ў database connectivity ( JDBC) and is the JavaSoft specification of a standard application programming interface (API) that allows Java programs to access database management systems. To use these Generators and Receivers, GenRocket leverages JDBC.

To populate tables in the database using receivers like GenericSQLInsertReceiver, MySQLInsertReceiver etc.

To retrieve data from the database while generating data using GenRocket runtime using generators like ListQueryGen, QueryBeforeLoop etc.

You will want to connect to your MySQL database for two reasons:

DATA GENERATOR FOR MYSQL HOW TO

How to make a connection to a MySQL database with the GenRocket Runtime Solution home Getting Started Organization Resources (for Users) How do I make a connection to a MySQL database with the GenRocket Runtime?

Data generator for mysql