Steps For Database Testing
- Download JMeter Download the Latest Version of JMeter
- Run the JMeter.bat Run the jmeter.bat file from the JMeter installation directory.
- JMeter GUI JMeter GUI will be shown…
- Adding Basic controls to the Test Plan
- Thread Group control Right click on the Test Plan and add the Thread Group control.
- JDBC Request control Add the JDBC Request control below the Thread Group. Note: JDBC Request allows us to run a SQL query, procedure etc.
- JDBC Connection Configuration control Add the JDBC Connection Configuration control to the Test Plan.
- View Result Tree control Add the View Result Tree control to the Test Plan. Note: View Result Tree control is used to view the result of the query executed.
- Parameterization User Parameters Control
- Calling Procedure 1. Add the JDBC Request control to the Thread Group.
Note: Thread Group allows us to run script with n no. of users with defined ramp-up period and also the scheduling of execution.
Note: JDBC Connection Configuration control is used to configure the database i.e. Oracle, SQL Server etc. In this control, we need to provide values to the following parameters to communicate with DB server
Database Connection Configuration- For Oracle
============================
Database URL: jdbc:oracle:thin:@localhost:IP:service (e.g. IP: 1521, Service: oracle)
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
Username: Username of the database (e.g. Username: scott)
Password: Password of the user (e.g. Password: tiger)
For SQL Server 2005
============================
Database URL: jdbc:sqlserver://localhost:1433;databaseName=Learn_DB;
JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Username: Username of the database (e.g. Username: sa)
Password: Password of the user (e.g. Password: password)
Copy this jar file to “lib” folder. This is jdbc driver for SQL server 2005 [downloaded from Microsoft’s site]
For MySQL
============================
Database URL: jdbc:mysql://localhost:3306/mydb
JDBC Driver Class: com.mysql.jdbc.Driver
Username: Username of the database (e.g. Username: guest)
Password: Password of the user (e.g. Password: password)
Where “mydb” is Database Name E.g. for MySQL is given in jmeter’s user manual “http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html”
1. Add the User Parameters control to the Thread Group.
2. Pass the variable to the query or procedure.
Syntax: ${variable_name} (e.g. ${Dept_No})
Sample Query: update dept set loc='JMeter' where deptno=${Dept_No}
2. Procedure which we are going to call must exist in database.
3. Type the following command in SQL Query parameter of the JDBC Request control
begin
{call update_DEPT_PKG.update_DEPT(10)};
end;
Whichever procedure we want to call must be inside the begin…end block. Call keyword is used to call the procedure from the database.
Thanks Navneet!!!
ReplyDeleteIts really a nice article.
Will help us a lot in doing Database testing..
Please tell me from where i can download the driver for mysql.
ReplyDeleteThanks in advance.
You can download the Mysql driver from
ReplyDeletehttp://dev.mysql.com/downloads/connector/j/
Hi Navneet,
ReplyDeleteI am new to Jmeter,
Please share how to do the web testing through Jmeter.
What can be the situation where we require this DB testing???
ReplyDeleteHow can we use delete statement in Jmeter 2.7
ReplyDeleteNever mind I got it. In JDBC request we can use query type as Update statement followed by delete statement.
ReplyDeletee.g
Delete from tableName where condition.
True
DeleteI've written detailed article about creating jmeter script for database testing. I'll be glad, if it is helpful.
ReplyDeleteThanks for your information. QTP provide most precise and independent review about a software application. This automation testing tool is ideal to determine the performance and validity of a software application. QTP Training in Chennai | QTP training Chennai
ReplyDeleteQuite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.
ReplyDeleteRegards,
Software testing training institutes in chennai|Software testing training|Software training
Nice information!!! I prefer Loadrunner automation testing tool to validate the performance of software application/system under actual load.
ReplyDeleteRegards,
Loadrunner Training|Loadrunner course in Chennai|Qtp training |Qtp training institutes in chennai
The blog gave me idea to perform database testing using the Jmeter My sincere thanks for sharing this post and please continue to share this post
ReplyDeleteSoftware Testing Training
nice blog has been shared by you. before i read this blog i didn't have any knowledge about this but now i got some knowledge so keep on sharing such kind of an interesting blogs.
ReplyDeletesoftware testing training in chennai
Thanks for sharing such an informative blog. I have read your blog and I gathered some needful information from your blog. Keep update your blog. Awaiting for your next update. Selenium Training in Chennai | Software Testing Training in Chennai
ReplyDeleteHi how to add a Delete request in JDBC request?
ReplyDelete
ReplyDeleteIt was so good to read and useful to improve my knowledge as updated one.Thanks to Sharing.
ETL Testing Online Training
Hadoop online Training
Informatica Online Training
Very impressive thanks for sharing
ReplyDeleteVMware Training in Chennai
DevOps Training in Chennai
DevOps Certification in Chennai
Your draftsman ought to likewise have insight in database standardization with the goal that your plan will follow the prescribed procedures for social databases. https://onohosting.com/
ReplyDeleteThe job of the database director (DBA), or information draftsman, can't be over-accentuated in an IT project. https://hostinglelo.in/
ReplyDelete