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 |
which browsers versions are supported in loadrunner 8.1?if any patches are required for browsers?
3 Answers Prodigy Technologies, TCS,
When you initialize the vuser what happen?
How do you report a bug when it is found in perfomance testing using Load Runner
where do you save u r scripts in Load Runner?
What is parameterizion?
on what monitoring tools have u worked on?
The response time of an application was 2.5 seconds.After a minor hotfix,the response time increased to 5 seconds.What analysis can you make out. What are all the things u check in the server side in such a scenario?
How does caching affect performance testing results?
What is Performance testing?
There is a scenario like there is one gateway and four application servers.While recording the script for a business function the server address is of gateway. but the gateway route the request to one of these servers.In recording might be request went to server A but it can not be everytime.sometime the request will go to other servers too.How to handle this scenario in preparing the scripts? how to identify tht to which server request went?
Can u Explain me in real time projects any frameworks follows in Loadrunner ? if Yes plz mentiond(Chandana)
which kind of database counters we use to check the performance of the software and where we can check them?