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

Data entry when IDENTITY_INSERT is set to OFF.

If you get an error message while inserting records in a table.
Error message looks like : Cannot insert explicit value for identity column in table ‘dbo.InverterData’ when IDENTITY_INSERT is set to OFF.
to fix this ; SET IDENTITY_INSERT dbo.InverterData ON;  before insert command and after insert enter this: SET IDENTITY_INSERT dbo.InverterData OFF;

SET IDENTITY_INSERT dbo.InverterData ON;

INSERT INTO   dbo.InverterData
(  Id, CurrentL1,  CurrentL2,  CurrentL3,  GridFrequency,  Power,  SampleTime,  Temperature,  TotalEnergy,  TotalEnergyToday,  TotalHours,  InverterId )
VALUES (   5, 33, 43, 53,8,68,21/11/2011 13:00:00,210,2 );

SET IDENTITY_INSERT dbo.InverterData OFF;
GO

Scrum tool - iceScrum (Agile product development) used for test driven development.

Sand box for collecting user stories.

here in image below you see the  user stories defined after meeting with team. Product owner can view the page online and provide comments over priority of a user story and can ask team to shift a user story to later sprint or add a user story to current sprint. Keeping the product owner in loop from the first day. this helps to keep transparency and structure in the planned tasks and priorities.

 

the image below shows how some acceptance test cases are written of each story to ensure that what understood related to the user story is correct. Team can review the test cases and developers can even use it as a checklist before asking testes to test the user story. Moreover the product owner can check if the team understood what he wanted in the user story and all people are on same understanding level. Any feedback can be provided and further this can be used to revise a user story or add a reminder or exceptions to be specific on to what is expected and what is agreement with product owner and what is delivered.

 

tabular form of sandbox.

product backlog,

tabular form  of  product backlog

sprint3 log view

Sprint Plan.

tabular form sprint plan

burn down in hours

Burndown in stories.