I. TEST environment preparation
oracle:10g
JDBC Driver: Classes12.jar
Copy the Oracle installation directory (Oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar) file to the Jmeter/lib directory
jmeter:jmeter-2.11
Two. Design test plan and run
1. Open JMeter, click Test Plan
Click on the "Browse ..." button to add your JDBC driver.
2. Add a thread group, right-click on "Thread Group" and add a "JDBC Connection Configuration" below
To configure the JDBC Connection configuration page.
Pool Timeout: Connection timeout can be modified during this time
3. Right click on "Thread Group" and add a "JDBC request" below.
The parameters that need to be modified include variable Name, to fill in the same content as the JDBC Connection configuration above, so: Oracleconn. This indicates that the JDBC Connection configuration establishes a connection pool named Oracle, after which the other JDBC request shared the connection pool.
NOTE: In SQL statements, you can use parameterization. The values in the INSERT statement can also be parameterized, such as:
Note: It is not possible to add a semicolon after a SQL statement, otherwise it will be reported as syntax error.
4. Add an assertion, right-click the thread group----> Add---> Assert----> Response assertion.
5. Let's add some listeners to the line to view:
Add an assertion result: Right-click the thread group----> Add---> Listener----> Result assertion.
Add a graphical result: Right-click the thread group----> Add---> Listener----> Graphical results.
Add a View results tree: Right-click the thread group----> Add---> Listener----> View the results tree.
Here is a list of all the additions:
6. Thread Group page set number of users, start time, number of cycles, and then click the menu bar "Run"----"Start"
Here's the result:
At this point, jmeter to carry out the stress test to this end, in particular, according to the actual project to carry out.
Note: Assertion results has a serious effect on the throughout of JMeter pressure measurement.
Three. Problems encountered
1. Appearance: Java.sql.SQLException:No suitable driver found for JDBC:ORACLE:THIN:@127.0.0.1:1521:ORCL error resolution
It was because the package was not loaded.
Workaround: Close JMeter, and then copy Class12.jar (search for Classes12.jar This file on your computer) to the Lib directory under the JMeter directory and restart the run.
2. When connecting to MySQL database, it appears: Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Unknown character set: ' Utf8mb4 ' ERROR
It seems to be the problem of setting the character, and later in the JDBC connection configuration there will be a database URL plus character encoding (? characterencoding=utf-8)
Jdbc:mysql://127.0.0.1:3306/paydb?characterencoding=utf-8
3. Appearance: Org.apache.avalon.excalibur.datasource.NoAvailableConnectionException:Could not create enough Service your request (Timed out).
Workaround: This occurs because the connection timed out, increasing the pool timeout.
4, the execution prompt: Ora-00911:invalid character.
Workaround: Make sure that the SQL statement you entered in the query in the JDBC request is correct. Note: Do not add semicolons after the SQL statement.
Four. Drive class
Different drive classes corresponding to the jar is different, be sure to note that the following: MSSQL download Sqljdbc4.jar placed under Apache-jmeter-2.6\lib
Datebase |
Driver class |
Database URL |
Mysql |
Com.mysql.jdbc.Driver |
Jdbc:mysql://host:port/{dbname} |
PostgreSQL |
Org.postgresql.Driver |
Jdbc:postgresql:{dbname} |
Oracle |
Oracle.jdbc.driver.OracleDriver |
Jdbc:oracle:thin:user/[email Protected]//host:port/service |
Ingres (2006) |
Ingres.jdbc.IngresDriver |
Jdbc:ingres://host:port/db[;attr=value] |
MSSQL |
Com.microsoft.sqlserver.jdbc.SQLServerDriver Or Net.sourceforge.jtds.jdbc.Driver |
Jdbc:sqlserver://ip:1433;databasename=dbname Or jdbc:jtds:sqlserver://localhost:1433/"+" library " |
Five. Attach the jar package used
Attachment
JMeter Learning (eight) JDBC test plan-Connect Oracle