One, configure SQL Server
1. Download the SQL driver and put the Sqljdbc4.jar into the JMeter installation directory/lib.
2, start JMeter, right-click Add-config file->jdbc Connection configuration.
3. Setting the JDBC Connection configuration property
(1) Variable Name:mssql, this value will be used in subsequent JDBC request;
(2) Database url:jdbc:sqlserver://db address; instancename= instance name; databasename= database name;
(3) JDBC Driver class:com.microsoft.sqlserver.jdbc.SQLServerDriver (SQL Server fixed notation);
(4) Username/password: The user name and password of the database;
4. Right-click the thread group to add-sampler-JDBC Request
Set the JDBC Request Property
5. Right button-listener-view result tree
You can test SQL Server.
Second, configure my SQL
1, download the MySQL driver, put the Mysql-connector-java-5.1.35.jar into the JMeter installation directory/lib.
2, start JMeter, right-click Add-config file->jdbc Connection configuration.
3. Setting the JDBC Connection configuration property
(1) Variable Name:mysql, this value will be used in subsequent JDBC request;
(2) Database url:jdbc:mysql://Address: port/database name;
(3) JDBC Driver class:com.mysql.jdbc.Driver (mysql fixed notation);
(4) Username/password: The user name and password of the database;
4. Right-click the thread group to add-sampler-JDBC Request
Set the JDBC Request Property
5. Right button-listener-view result tree
We can test the MyServer.
JMeter Configuring the JDBC Test SQL Server/mysql