LoadRunner with MSSQL
Printed From: One Stop Testing
Category: Testing Tools @ OneStopTesting
Forum Name: LoadRunner @ OneStopTesting
Forum Discription: LoadRunner is a performance and load testing product by HP / Mercury Interactive for examining system behavior and performance, while generating actual load.
URL: http://forum.onestoptesting.com/forum_posts.asp?TID=979
Printed Date: 20Jul2025 at 1:05am
Topic: LoadRunner with MSSQL
Posted By: Saee
Subject: LoadRunner with MSSQL
Date Posted: 26Apr2007 at 12:06am
I worte a client which directly call the MSSQL server's store
procedure(For example, test(@p1)). And I used the Siebel MSSQL prototol
to record the script, then replayed it.I could see the script was
working fine through querying the database. In the Controller I found
the transaction succeed.But there are some errors in both VU and
Controller.
It's something like
"The test(@p1) need @p1 but it's not provided"
I ensure the script working and the table has been updated.
Then I check the script line by line:
lrd_init(&InitInfo, DBTypeVersion);
lrd_open_context(&Ctx1, LRD_DBTYPE_ODBC, 0, 0, 0);
lrd_open_context(&Ctx2, LRD_DBTYPE_ODBC, 0, 0, 0);
lrd_db_option(0, OT_ODBC_CP_OFF, 0, 0);
lrd_alloc_connection(&Con1, LRD_DBTYPE_ODBC, Ctx2, 0 /*Unused*/, 0);
lrd_db_option(Con1, OT_ODBC_LOGIN_TIMEOUT, (void FAR const *)120, 0);
lrd_open_connection(&Con1, LRD_DBTYPE_ODBC, "", lr_decrypt("453f1797e"), "", lr_decrypt
("453f1797ebb8c63fd3c2e4f33648b2ed3190947eae7ec144"
"b470087b9378b4a701f78e1578492837f384d29314a2afc6d52499cef6b7"
"4a66e8ca142ddb45a7d236aacf98536a193c3fa02a003d813ac16fba5724"
"32b4174b4410a471d55869c2c920bc6e22f05b36"), Ctx2, 1, 0);
lrd_alloc_connection(&Con2, LRD_DBTYPE_ODBC, Ctx2, 0 /*Unused*/, 0);
lrd_db_option(Con2, OT_ODBC_LOGIN_TIMEOUT, (void FAR const *)120, 0);
lrd_open_connection(&Con2, LRD_DBTYPE_ODBC, "", lr_decrypt("453f1797e"), "", lr_decrypt
("453f1797ebb8c63fd3c2e4f33648b2ed3190947eae7ec144"
"b470087b937fbabd14e7800a715f3f7ed0a8e495329f8a8fce22c3f29aa3"
"204fbac51223d71283b927c7d8f5477e0f3535d6326823964edc13bb5932"
"50b2765b330cde61d54e69d3cd4e8a2731e15339"), Ctx2, 1, 0);
lrd_open_cursor(&Csr1, Con1, 0);
lrd_db_option(Csr1, OT_ODBC_QUERY_TIMEOUT, (void FAR const *)30, 0);
lrd_stmt(Csr1, "A_Insert_Monitor_Request", -1, 1, 0 /*None*/, 1);
lrd_cancel(0, Csr1, 0 /*Unused*/, 0);
lrd_db_option(Csr1, OT_ODBC_CURSOR_CLOSE, 0, 0);
lrd_db_option(Csr1, OT_ODBC_CURSOR_CLOSE, 0, 0);
lrd_assign(&_1_D1, "4", 0, 0, 0);
lrd_bind_placeholder(Csr1, "1", &_1_D1, LRD_BIND_FOR_INPUT_ONLY, 0);
lrd_stmt(Csr1, "{ call A_Insert_Monitor_Request(?) }", -1, 1, 0 /*None*/, 0);
lrd_result_set(Csr1, 0, 0, 0);
lrd_db_option(Csr1, OT_ODBC_CURSOR_CLOSE, 0, 0);
lrd_cancel(0, Csr1, 0 /*Unused*/, 0);
lrd_close_cursor(&Csr1, 0);
I
found there are two lrd_stmt functions and the second one is doing what
I want the script to do. The first one is the reason why the result
show the error and I don't know what's the mean. Why the function has
been called twice?
Any help will be very appreciated!
|
Replies:
Posted By: lalita
Date Posted: 26Apr2007 at 3:30am
1 To be honest, I don't know what protocol I should choose.So I tried
some according to my understanding of protocol.When I choose "Siebel
MSSQL", The script worked fine and the data in database had been
updated.Am I not right?
2 Could you please tell me the difference between
"A_Insert_Monitor_Request" and "{ call A_Insert_Monitor_Request(?) }".
I checked the help file but I did not understand.In help file, it says
that lrd_stmt "Sets an SQL statement to be processed". Just set?When
excuted? Which command corresponding?
3 I don't know who I can ask for help.
I'm new to performance testing. Sorry for my unclear expression.
|
|