Connection Steps For DB2 Database with GenRocket Runtime
Step 1: Download DB2 JDBC Driver and place it in the $GENROCKET_HOME/lib/ folder
The IBM Data Server Driver for JDBC and SQLJ package includes two JDBC drivers:
- db2jcc.jar - This driver is based on the JDBC 3 specification
The db2jcc.jar driver is now deprecated. After version 3.72, which is delivered with DB2 Version 11.1 for Linux, UNIX, and Windows Modification Pack 1 Fix Pack 1, db2jcc.jar will include no new features.
- db2jcc4.jar - This driver is based on the JDBC 4 or later specifications
You can download both of these jars at this IBM website. After you download the appropriate jars for your DB2 instance, place them in your genrocket-3.5.12/lib folder.
- It is OK if your GenRocket version doesn't match the one above -- still just place the IBM Connector in the lib directory
Step 2: Create a JDBC Configuration Properties File
For GenRocket to connect to an DB2 database via JDBC you will need to create a config.properties file. Any application can connect a DB2 database via JDBC by reading a JDBC properties file that contains the following information:
- driver - Defines the name of the specific database driver to use to access the given database. The actual driver file must be placed in the $GEN_ROCKET_HOME/lib folder on your local computer. For DB2, the value should be com.ibm.db2.jcc.DB2Driver.
- user - Defines the Username used to access the database.
- password - Defines the password used to access the database.
- url - Defines the specific URL to access the database. See more in this information below.
- batchCount - Defines the number of SQL statements that are batched together and sent to the database for execution. This property is only mandatory for GenRocket Receivers.
<code>driver=<JDBCDriverClassName> user=<userToConnectToDatabase> password=<passwordToConnectToDatabase> url= jdbc:db2://<hostName>:<portNumber>/<databaseName>;<property=value> batchCount=1000</code>
As an example, to connect to a DB2 database named sampledb and is configured to listen in the port 50000 with the user db2admin1 and password P@ssword1, the configuration file would be:
<code>driver= com.ibm.db2.jcc.DB2Driver user=db2admin1 password= P@ssword1 url= jdbc:db2://localhost:50000/sampledb batchCount=1000</code>
JDBC URL Explanation
The general form of the connection URL is jdbc:db2://[hostName[:portNumber]/[databaseName]][;property=value[;property=value]]
- jdbc:db2:// is known as the sub-protocol and is constant.
- hostName is the address of the server to connect to. This could be a DNS or IP address.
- portNumber is the port number of the database instance. The default is 50000.
- databaseName is the name of the datasource.
- Property is one or more option connection properties.
Step 3: Next step is to add a new resource named resource.jdbc.config in GenRocket Web
The resource.jdbc.config resource in this image points to the dev folder.
- Set the value of resource variable to the config file name with the full file path.
- For example, say you have added config.properties at location /home/user/Desktop/. Then the resource value will be /home/user/Desktop/config.properties.
- Make sure to update your Profile (in ~/.genrocket folder) on your system after adding the new resource with its value. GenRocket will read this resource value from your profile on your system to make a connection with the database.
Step 4: Reference the JDBC Resource in your Generators or Receivers
When you create a Scenario that has a Generator or Receiver that references your jdbc.config resource it will connect directly to your database.