jmeter3.2 Testing Oracle

1. Preparatory work
The Oracle 11g R2 version of the database is installed
Copy the ORACLE driver Ojdbc6.jar from the $oracle_home/jdbc/lib/of the database server
The database has a table students, with 2 field IDs and a name

2. Start Oracle Test
1. Open the JMeter, add a test plan, locate the Oracle driver location to add

2. Test plan-Add thread Group
3 Thread Group-add configuration components-jdbc Connection Config


Variable Name: Database connection pool names, similar to Web sites, you can create multiple connection holds, the following sites can specify connection pooling to read different configurations.

Validation Query: The default is select 1, if it is Oracle, you need to change to select 1 from dual, otherwise the error cannot create poolableconnectionfactory (ORA-00923: Requested from keyword not found)

Database URL: DB connection address, format Jdbc:oracle:thin: @ip: Port: Instance name is JDBC:ORACLE:THIN:@172.17.100.131:1521:ORCL

JDBC Driver CLASS:JDBC Driver, Oracle's fill Oracle.jdbc.driver.OracleDriver

Username: Database user name

Password: The corresponding database password
4 "Add-sampler-jdbc Request under Thread Group

5 "Bulk Insert data (parametric)



6 Add listener-View results tree (you can also continue adding other, such as aggregated reports)

7 "execution, BULK insert 100 records, thread settings

jmeter3.2 Testing Oracle