Posts

Showing posts from September, 2017

Jmeter Authorization | NTLM

While Testing with Jmeter, you might be trying to script a application which do not have a login page. But it does authenticate the user by Single Sign on (SSO) or Through a pop up. SSO: When Your Request is transferred to some 3rd party application to validate your credentials through which you have logged into your device . Example : Your Intranet application in your company which authorizes and display your personalized homepage for the person who has logged into the device. Pop-UP : While working with Loadrunner you might be using web_set_user function to fulfill your need. Whereas in Jmeter, it is done using HTTP Authorization manager. where you mention the external server link, User name, password and domain. Although just adding this part and executing the Homepage still might return 401 unauthorized. Well now you have to look if your request need some Authorization Key, which is generated by HTTP Authorization manager. It might be requiring that in header of th...

How to Change the IE setting using Registry Editor[RedEdit]

Disable Proxy Settings in Registry Step 1 Click "Start," type "regedit" in the search field and press "Enter." Step 2 Expand the "HKEY_CURRENT_USER" hive by clicking on the "+" sign next to it. Continue expanding "Software," "Microsoft," "Windows" and "CurrentVersion," then click on the "Internet Settings" subkey or folder. Step 3 View the contents of the Internet Settings folder on the right pane. Double-click on the "ProxyEnable" DWORD value to open the "Edit DWORD Value" window. Change "Value data" to "1" and press "OK" to confirm. Step 4 Double-click on the "ProxyServer" string value. Back Up a Registry Key Step 5 Locate the Registry key or subkey you will modify. For this case, locate the "Internet Settings" subkey. Step 6 Right-click on the "Internet Settings" subkey or fol...

Run Stored Procedure from JAVA program and see the output

How to Call a stored procedure using JAVA code: package com.qa.conf; import java.io.*; import java.sql.*; import java.time.LocalDateTime; import java.time.ZonedDateTime;  public class DBConnection { public static void main(String args []){                System. out .println( "Started" );               String OPTSCHK = "INTERNAL" ,                        CHASEMEDIUM = "EMAIL" ,        try {         //step1 load the driver class         Class. forName ( "oracle.jdbc.driver.OracleDriver" );                  //step2 create  the connect...

How to write a PL/SQL procedure

How to write PL/SQL Procedure Initialize input and output variables. input variables are those which dynamic values which needs to be updated whenever Procedure is called Output variables are those in which you need to store the output of query For Single Result set, we use Output Variable But when output is of Many Line it is recommended to use Cursers else you might end up with exception: TOO_MANY_ROWS The Select Query is modified with little insertions so that result can be stored in an variable which can there is used for further action. Example : create or replace PROCEDURE TESTPROC1 (   U_MATCHSYSTEM IN VARCHAR2  -- Declare Input Variable   ,R_RESULT_TEXT OUT VARCHAR2  -- Declare Output Variable   AS BEGIN select txn_proc_id,counterparty_id,TXN_ID into R_TXN_PRC_ID,R_CPTYID,R_TXN_ID from table1 where MATCHSYSTEM= U_MATCHSYSTEM ; R_RESULT_TEXT := CONCAT (R_RESULT_TEXT, 'Process Started');  -- You can Store...