JMeter Connecting the Oracle Database

First, jmeter to connect to the Oracle database, you must copy the JDBC driver jar package file Ojdbc14.jar to the JMeter Lib directory

Second, enter the JMeter bin directory run Jmeter.bat, start JMeter

Third, the JMeter software configuration is as follows:

1. Add Thread Group

2. Right-click the thread group and select "Add-Configure component--jdbc Connection Configuration"

3. Click on the JDBC Connection configuration and set the input domain to connect the Oracle database as an example:

2. Variable Name Bound to Pool: This value should be unique throughout the test plan and will be used later

4. Database url:jdbc:oracle:thin:@ database ip:1521: DB ID database connection string

6. JDBC Driver class:oracle.jdbc.driver.OracleDriver Database driver

8. Username: Database user name

10. Password: The corresponding database user password

    650) this.width=650; "title=" JDBC Connection Configuration "alt=" wkiom1ss5ogda5loaak1b_ Eevqa325.jpg "src=" Http://s3.51cto.com/wyfs02/M00/58/41/wKiom1Ss5oGDa5loAAK1B_eEVqA325.jpg "/>

4. Click on the thread group and select "Add--sampler--jdbc Request"

5. Click JDBC Request to set the input domain:

1. Variable Name: Enter the value of Variable name in the JDBC Connection Configuration

2. Query: Enter the corresponding SQL

   650) this.width=650; "title=" JDBC Request "alt=" wkiol1ss53xtcw-naagsxuog_t0322.jpg "src=" Http://s3.51cto.com/wyfs02 /m01/58/3d/wkiol1ss53xtcw-naagsxuog_t0322.jpg "/>

6. Add Listener, click Thread Group, select "Add-listener-view result tree/graph result"

7. Save the Test plan

8. Start the test plan from the Run menu

JMeter Connecting the Oracle Database