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

The general steps are as follows:

(1) copy the JDBC driver JAR package file (ojdbc14.jar) of ORACLE to the lib directory of JMeter.

(2) run jmeter.bat

(3) create a thread group: right-click test plan-> add-> Threads- > thread group

(4) create JDBC Connection Configuration: right-click thread group-> add-> configure original-> JDBC Connection Configuration

(5) enter the Variable Name content of Virable Name Bound to Pool in Database Connection Configuration

(6) enter database configuration information in Database Connection Configuration

For example:

Database URL: jdbc:oracle:thin:@192.168.1.168:1521:ptoracl

JDBC Driver class: oracle.jdbc.driver.OracleDriver

Username: lianggzone

Password:lianggzone

Note:

Database URL format: jdbc:oracle:thin:@ [IP address]: [Port number]: [instance name]

The user name and password are the user name and password to connect to the database.

(7) create JDBC Request: right-click thread group-> add-> Sampler- > JDBC Request

Variable Name: fill in the same content as the JDBC Connection Configuration above.

SQL Query: that's the SQL statement.

(8) add Monitor: right-click Thread Group-> add-> Monitor

(9) final effect

For more information, see http://edu.51cto.com/course/2324.html

If it helps you, retweet + like = support

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.