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

I spent two hours in the afternoon studying Jmeter sending JDBC requests, and now share the basic operation flow.

To make a JDBC request, you first need two jar packages: the mysql driver-mysql-connector-java-5.1.13-bin.jar and the sqlServer driver-sqljdbc4.jar. Place the two jar packages in the lib file in the Jmeter directory, and then restart Jmeter. (need to contact me directly with jar package)

1: add thread group

2: add JDBC Connection Configuration

3: configure the basic parameters of JDBC Connection Configuration (note that the naming of Variable Name must be the same as that of Variable Name in JDBC Request)

Driver Class can be written as org.gjt.mm.mysql.Driver or com.mysql.jdbc.Driver, based on the correct response

4: add JDBC request

4: in JDBC request, type the sql query statement

5: execute the thread and view the result as follows

That's all the basic content is. I'll talk about how to take a value from the jdbc response to do the correlation later.

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.