How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
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 |
What is the advantage of running vuser as a process than a thread?
How do you decide the number of load generator machine required to run a test?
What is the difference between performance testing and performance engineering?
While running a scenario in loadrunner controller,the component suddenly hangs and gets closed automatically,the results of the test is no saved and when i open the scenario now,how can i get the results back.?
What are the main Performance issues in JBoss server? And How to do it?
If we want to know the size of each component in system how?
Hi, this is hari. I reciently joined in a small company on testing. there is no team for testing am only the person to do. i know manual testing, i have knowledge on QTP 8.2. I currently working on web based application. but in my company they want Load/Performance testing. plese tell me what i have to do?? i know Load runner but i have no real time exp on that! and In which areas i have to apply QTP??
What is the number of graphs you can monitor using controller at a time? What is the max of them?
suppose in ur company one new project is came for testing applictaion.. duration 1 year.. so,with in one week manual tester role starts and qtp(any) testers role starts..and others role starts,,,,BUT WHEN THE PERFORMANCE TESTER ROLE STARTS... in the midle of the project or ending of the project..and how many months it takes to starts the load runner tester role begins?
pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?
Explain the architecture of ur application ?
What is loadrunner api function?