The approximate steps are as follows:
(1) Copy the JDBC Driver jar package file (Ojdbc14.jar) from Oracle to the JMeter Lib directory.
(2) Running Jmeter.bat
(3) Create thread Group: Right-click Test Plan, add->threads-> thread Group
(4) To establish a JDBC Connection configuration: Right-click Thread Group, add-and-configure Originals->jdbc Connection Config
(5) in database Connection configuration input virable name Bound to pool variable name content
650) this.width=650, "height=", "width=" 790 "src=" http://mmbiz.qpic.cn/mmbiz_jpg/ icgsknubvvjhicdrrejsb1affgb0epyuhnrzl7d2i58tclkxdefl1iaian8ul1g8p1kbqmaxb4wntwvjpoqte1uig/640?wx_fmt=jpeg& Tp=webp&wxfrom=5&wx_lazy=1 "style=" Margin:1em Auto;padding:0px;height:auto;border-width:0px;font-style: Inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-family:inherit; Vertical-align:baseline;width:auto, "alt=" 640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy "/>
(6) In database Connection configuration information
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]
User name, password is the user name and password to connect to the database
(7) To create a JDBC request: Right-click the thread group, add->SAMPLER->JDBC request
Variable Name: Fill in the same content with the JDBC Connection configuration above.
SQL query: is the SQL statement.
650) this.width=650; "height=" 503 "width=" 827 "src=" http://mmbiz.qpic.cn/mmbiz_jpg/ Icgsknubvvjhicdrrejsb1affgb0epyuhnttshibbh3tgunkv3m8ck5celkiafabz4vpg4kiasyuz56jcmffuh4ibilg/640?wx_fmt=jpeg &tp=webp&wxfrom=5&wx_lazy=1 "style=" Margin:1em auto;padding:0px;height:auto;border-width:0px; Font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-family: Inherit;vertical-align:baseline;width:auto; "alt=" 640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy "/>
(8) Add Monitor: Right-click Thread Group, add-on monitor
(9) Final effect
650) this.width=650; "height=" 342 "width=" 241 "src=" http://mmbiz.qpic.cn/mmbiz_jpg/ Icgsknubvvjhicdrrejsb1affgb0epyuhnb4mic0ib79xnicxybvfp9n7gpe4cbj2uiaoieyphz0atpklhtibrsypljoq/640?wx_fmt=jpeg &tp=webp&wxfrom=5&wx_lazy=1 "style=" Margin:1em auto;padding:0px;height:auto;border-width:0px; Font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-family: Inherit;vertical-align:baseline;width:auto; "alt=" 640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy "/>
For more information, see: http://edu.51cto.com/course/2324.html
If you have a loss of help, forwarding + likes = support
This article is from the "Cockroach Performance automation test brand" blog, please be sure to keep this source http://xqtesting.blog.51cto.com/4626073/1964224
JMeter Testing the Oracle Database