----------------------------------------------------MySQL------------------------------------------------------------
1. Download JDBC, unzip the JDBC, copy the Mysql-connector-java-version-ga-bin.jar file to Jmeter/lib;
2. Open the JMeter and set the JDBC request;
1) database Url:jdbc:mysql://localhost:3306/datebasename. Where localhost:3306, this is the server address you tested, Datebasename, This is the database name you tested. This URL is a JDBC connection
2) Driver Class:org.gjt.mm.mysql.Driver or Com.mysql.jdbc.Driver If you can't connect to the database, try another one.
3) Username: Login name for this database
4) Password: This is the login password for the database
5) write the SQL statement in SQL Query string to test
----------------------------------------------------Oracle----------------------------------------------------------
1. Download JDBC, copy the Oracle JDBC Driver jar package file (Ojdbc14.jar) to the JMeter Lib directory;
2. Open the JMeter and set the JDBC request;
1) Database Url:jdbc:oracle:thin:@192.168.0.236:1521:orcl
format : Jdbc:oracle:thin:@[ip address]:[Port number]:[instance name]
2) JDBC Driver class:oracle.jdbc.driver.OracleDriver
3) Username: your database user name
4) Password: your database password
5) write the SQL statement in SQL Query string to test
Note:
1) The configuration test method for other databases (such as mysql/oracle, etc.) is also the same as
2) OJDBC version differences < differences between Ojdbc14.jar,ojdbc5.jar and Ojdbc6.jar >
6929553
Test Oracle/mysql performance with JMeter