How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
- 1 Answers
- 20766 Views
- I also Faced
- E-Mail Answers
Answer / rajat
Follow below mentioned steps in order to execute query
through LR script-
(1) Establish conn with DB
lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "bb",
"lion", "hammer", "", 0, 0, 0);
(2) Enter query
lrd_stmt(Csr1, "select ename from employee where
(sal>=1000)\n", -1, 1, 1, 0);
(3) lrd_bind_col(Csr1, 1, &D21_ENAME, 0);
(4) Execute query
lrd_exec(Csr1, 0, 0, 0, 0);
(5) lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);
(6) lrd_close_cursor(&Csr2, 0);
(7) lrd_close_connection(&Con1, 0, 0);
| Is This Answer Correct ? | 6 Yes | 1 No |
how to write a test cases in loadrunner application .plz give me an example. thank u
How you load a loadrunner agent?
hai friends, it s very urgent ...pls do help me out ...... please to help in working with load runner to find the response time of single user,5 user etc.... i dont have any prior experience but i am in the situation to handle this scenario.....its very urgent ...pls help me
How To Identify Performance Testing Requirements ?
What is loadrunner api function?
You are Performace Engineer and it is bottleneck how will identify it is Database Issue? Any one can justify? send to sss4702@gmail.com
i have 4 systems 1-windows,1-unix,1-linux,1-solaris. 100 vusers to 25 vusers each system. script was created in windows system. then i want to know how can i do this, do i need to install LR in all the systems ? please explain whole the scenario up to...Run step by step---plz give answer only realtime...?
what is think time when u will use it?
what is connection pooling?
In Performance Testing,tell me about usually which are the reports are generated and if any errors are occurs while doing performance testing then,how find exact location errors?
How do you measure current load levels in Load Runner?
what criteria did you use to select web transactions for load testing ?
WinRunner 
