TECH KNOW STUDY

JDBC Connection Through JMeter

6:31:00 PM vikas 0 Comments Category : JMeter

JMeter "JDBC Connection" for Oracle DataBase(PLSQL)

We can use JMeter which will reduce our manual effort to execute Any PLSQL query You can easily get JDBC connection configuration for MYSQL. This Post is for ORACLE DataBase (PLSQL)connection configuration through JMeter.

Here steps define to connect your ORACLE DataBase through JDBC connection

Open a test plan and add a thread group
Add a "JDBC Connection Configuration" from Configuration Element inside the thread group
configure the "JDBC Connection Configuration" with respective details as mentioned below

#Variable Name: - Need to give a name for JDBC pool. we need to use same pool name while executing the query.
#Pool Configuration: - If you have any no. of virtual user to hit the database give on the "Max number of connection" otherwise leave it as 0(ZERO). Also, put some time out time. #Connection Validation by Pool: - Here the main part is validation query

For MYSQL: - Select 1
For ORACLE(PLSQL): - Select 1 From Dual

#DataBase Connection Configuration: -Here we need to provide Host Name, Port Number, DataBase Name or Service ID.

You need to mention the JDBC driver class but before you need to download latest Oracle JDBC jar file and need to place that file inside "D:\apache-jmeter-3.0\lib" and mention the driver name over here Also, provide the right credentials to connect the DataBase

Add JDBC request sampler from sampler

#Variable Name: - The variable name should be same as we given in Step 3. Over here the variable name is "connectionsetting"

Write your SQL query and execute it for a successful result.

Ultimate Thread Group Configuration

6:34:00 PM vikas 0 Comments Category : JMeter

Ultimate Thread Group

To add thread group plugins in our JMeter you need to download JMeter plugin zip file. You can find out the latest plugin zip file over the link JMeterPlugins. Just extract the “JmeterPlugins.jar” file and paste it to below mentioned path

Path:- apache-jmeter-2.13–>lib –> ext –>

By using Ultimate Thread group you can put distributive load on the server in different time slot with a click. For an example if you want to put 520 users of load with different count of user in different time slot. Suppose 100 users for first 80 second and then 120 users for next 60 second so on….

You can give separate ramp-up time, shutdown time, flight time for each schedule record

Ultimate Thread Group Configuration:-

Add a Ultimate Thread Group

Add no. of rows depend on how may Thread/Slots you wants

Ex. Fig.1
I am adding 5 rows with different configuration

Configuration description:-

Start Thread Count- We need to put no. of user we want to execute with that Thread/Slots.All the thread will start one by one like we have 100 users in first thread for execution.

Initial Delay-This is the time delay for first user to hit the server after execution started.

Start-up time- We can say it used to find the ramp up time for the thread. Start up time will be divided among each user as (Threads Count / Start-up Time). So here it is (100/10). It means 10 sec for each user to hit the server.

Hold Load For- Once all the user ramp up related to that particular thread, load of 100 users will be there for 80sec.

Shutdown Time- After 80 seconds users need to stop the hitting server. So here it is 5 seconds. It means within 5 seconds all the user will stop the hitting server.

Macro Creation

10:14:00 PM vikas 0 Comments Category : Computer World , TIPS

Creation of Macro through NOTEPAD++

Some time we need an automated script/functionality to reduce manually work and time also.

Here I am giving a small example to create a macro with the help of notepad++. You can do the same with the help of excel only the function and all changed there.

Here you can see how to work on macro creation in notepad++

Macro

As you can see every step’s in above image, But some more clarification I am defining all the steps.

Note: Try to use these shortcuts to walk through the notepad++

1. CTRL+Arrow key-->To escape the whole word

2. CTRL+SHIFT+Arrow key-->To mark the whole world

3. CTRL+Delete/Backspace-->TO delete whole world

4. Use Home and End to move the cursor at the end or starting

I am suggesting these shortcuts because playback is performed same as it recorded.
Example-->If you press backspace 2 times it always be same in playback action.
It will be good if you disable word wrap if you are working with multiple of lines