JMeter Connection Database

Tag: Connection failed str AC connection number address Oracle database driver body Data

JMeter to link the database, the first to download the corresponding database driver package, the database driver package is placed in the JMeter Lib directory;

Download MySQL JDBC driver package as MySQL database (note: The version of the driver package must match the version of your database, Driver version is lower than MySQL version may cause connection failure error) I download the mysql-connector-java-5.1.7-bin.jar;oracle database to download the Oracle JDBC driver package;

1. Download the corresponding database driver package and place it in the JMeter Lib directory;

2. Open the JMeter tool and add the thread group

3. In the JMeter tool, add the JDBC Connection Configuration:

4. Add the JDBC Request:

5. Add the View results tree:

6. Configure the JDBC Connection configuration: (MySQL)

Database address: Jdbc:mysql://localhost:3306/test

Database driver: Com.mysql.jdbc.Driver

Database user name, password, according to the actual fill

7. Configure the JDBC Request to add the SQL statement that you want to use:

JMeter Connection Database