Shulou(Shulou.com)06/03 Report--

Download the driver package corresponding to the database, mysql-connector-java-5.1.7-bin.jar, put it in the lib directory of jmeter, restart jmeter

JDBC Connection Configuration

Variable Name for created pool: The variable name of the connection pool must be consistent with the variable name of the connection pool in the JDBC Request.

Database URL format: jdbc:mysql://ip:port/dbname, a request can only execute one sql statement

The format is: jdbc:mysql://ip:port/dbname? allowMultiQueries=true, executes multiple SQL statements at once

JDBC Driver class Select the driver corresponding to the database. username and password are the username and password for logging in to the database respectively.

3. Add JDBC Requester

4. Query multiple sql statements, jdbc:mysql://ip:port/dbname? allowMultiQueries=true and select Callable Statement

5. UPDATE statement

Multiple statements, using Callrable

6. Insert, delete statements use the same Query Type as update statements

7. parameterized sql statement

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.