JMETER HEAP adjustment

When you are unable to add largeer messages in JMETER, and you get the following error:

then you need to increase the standard setting of HEAP  in jmeter.bat

FROM:   set HEAP=-Xms512m -Xmx512m
TO : set HEAP=-Xms512m -Xmx1024m


For example: if you want to set the maximum heap size to 4 gigabytes, you’ll need to change the line to: HEAP="-Xms512m -Xmx4096m"

another efficient way to execute script is:
You can execute JMeter test from the command line. It is as simple as

jmeter -n -t Rahulstest script_number202.jmx

Installing Python and dependencies in Linux

Downloading python and dependencies.

Installing Python

Step0:open the Terminal on ubuntu 10.04. and enter the following steps. get dependencies.
Step1:
sudo apt-get install build-essential
Step2:
sudo apt-get install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev
Step3:get software fom website of python
(or you can also download directly from browser to download folder)

cd Downloads/
wget http://python.org/ftp/python/2.7.3/Python-2.7.3.tgz

Step4:Extract and go to the dirctory
tar -xvf Python-2.7.3.tgz && cd Python-2.7.3/

Step5:Now install using the command:(logged in as administrator or root)
./configure
make
sudo make altinstall


Step6: Installing : IDLE Editor for using Python on ubuntu 2.10
cd /home/administrator/Downloads/python2.7.3/Python-2.7.3/Tools
sudo apt-get install idle

Step7: starting editor IDLE in python

idle

Step8: open a new file in idel and name it as Rahultest.py

and write a small program and get it printed. as shown in images below:

JDBC driver & connections for different RDBMS

JDBC driver name and database URL take different forms for different databases, 

EMS not retrieving records with decimal on windows 7

If you have installed EMS SQL manager lite 2011 on windows 7 and when you execute a select command in it and it gives this following BCD error then this article will help you to fix this.

Go to the windows control panel and in there open the Regional settings and further click Additional settings.

in there select Decimal symbol= . instead of ,

restart the EMS and the Query will work fine.

Ranorex on vmware player

Ranorex on VMware player 4.0.5-893925 windows 2008 server R2

1-     Installed dot net framework 3.5 SP1

2-     From Server manager installed it again.

JIRA in Agile-scrum test environment

Jira installed on windows 32 bits

Handling of Issues  / Bugs within the team. 

create issue, Resolve issue, Reopen issue, close issue, etc..,

Database Procedure (For Bank application) to create Records for test environment.

CREATE PROCEDURE [dbo].[SP_InsertTestData]
AS
BEGIN
    SET NOCOUNT ON
    SET XACT_ABORT ON
INSERT INTO [User] ([UserName], [Password], [Email], [Role], [DisplayName], [Verified]) VALUES ('RAHUL','RAHUL','dummy@domain.ext','SystemIntegrator','RAHUL', 1) 
INSERT INTO   dbo.[CARDCONTROL](  [Name], [EmailForAlerts], SystemIntegratorId) VALUES (  'My First CARDCONTROL', 'RAHUL_test@serverTT2.com', (Select Id from [dbo].[User] where UserName = 'RAHUL' ));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 1', '1178189980',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins'));


INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 2', '1178189981',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins2'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 3', '1178189982',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins3'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 4', '1178189983',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins4'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 5', '1178189984',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins5'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 6', '1234560',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins6'));


INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
END