Timing HTTP Redirects in LoadRunner

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><h1 class="postname" style="background-color: white; font-weight: normal; margin: 0px; padding-top: 20px; text-align: justify;"><span style="color: #737984; font-family: Lucida Grande, Verdana, Arial, sans-serif;"><span style="font-size: 14px; line-height: 18.71875px;">-</span></span></h1><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">One of the most commonly misscripted elements in performance testing is web authentication. I’m not talking about integrated authentication like SPNEGO, I’m talking about a simple HTTP POST with authentication details followed by the sites authenticated home page. The problem is that the user experiences a two step process.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="User Login" class="aligncenter size-large wp-image-690" height="336" src="http://www.headwired.com/wp-content/uploads/2010/09/UserLogin-580x336.png" style="display: block; margin: 0px auto 20px; max-width: 100%; padding: 10px 0px;" title="User Login" width="580" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In reality the process is actually 3 steps, with the middle step is transparent to the user. <br /><a name="more"></a>Because it is transparent, tools like LoadRunner will attempt to represent the end-user experience and record only two steps. In most cases, this is the desired end-result. The following diagram shows the three steps that occur.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Web Authentication" class="aligncenter size-large wp-image-689" height="483" src="http://www.headwired.com/wp-content/uploads/2010/09/WebAuthentication-580x483.png" style="display: block; margin: 0px auto 20px; max-width: 100%; padding: 10px 0px;" title="Web Authentication" width="580" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The issue with recording Logon like this, is that it does not allow you to separate the authentication time from the loading time of the subsequent page. Its a simple process to separate the timing of the authentication and the subsequent page load, and the following code snippet shows you how to do it in LoadRunner.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">Action<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> lr_start_transaction<span style="color: #009900;">(</span><span style="color: red;">"Open_Logon_Page"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Validate Logon Page</span><br /> web_reg_find<span style="color: #009900;">(</span><span style="color: red;">"Text=Lost your password?"</span><span style="color: #339933;">,</span> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Open Logon Page</span><br /> web_url<span style="color: #009900;">(</span><span style="color: red;">"logon_page"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"URL=http://www.headwired.com/login.php"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"TargetFrame="</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"RecContentType=text/html"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Mode=HTML"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span> <br /> <br /> lr_end_transaction<span style="color: #009900;">(</span><span style="color: red;">"Open_Logon_Page"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Disable HTTP Redirects to time Authentication</span><br /> web_set_option<span style="color: #009900;">(</span><span style="color: red;">"MaxRedirectionDepth"</span><span style="color: #339933;">,</span> <span style="color: red;">"0"</span><span style="color: #339933;">,</span> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr_start_transaction<span style="color: #009900;">(</span><span style="color: red;">"Logon"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr_start_sub_transaction<span style="color: #009900;">(</span><span style="color: red;">"Authenticate"</span><span style="color: #339933;">,</span> <span style="color: red;">"Logon"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Find Authenticated URL</span><br /> web_reg_save_param<span style="color: #009900;">(</span><span style="color: red;">"redirect_url"</span><span style="color: #339933;">,</span> <span style="color: red;">"LB/ic=Location: "</span><span style="color: #339933;">,</span> <span style="color: red;">"RB=<span style="color: #000099; font-weight: bold;">\r</span><span style="color: #000099; font-weight: bold;">\n</span>"</span><span style="color: #339933;">,</span> <span style="color: red;">"Search=Headers"</span><span style="color: #339933;">,</span> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Submit Authentication</span><br /> web_submit_data<span style="color: #009900;">(</span><span style="color: red;">"web_submit_data"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Action=http://www.headwired.com/login.php"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Method=POST"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"TargetFrame="</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Referer="</span><span style="color: #339933;">,</span><br /> ITEMDATA<span style="color: #339933;">,</span><br /> <span style="color: red;">"Name=log"</span><span style="color: #339933;">,</span> <span style="color: red;">"Value={USERNAME}"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Name=pwd"</span><span style="color: #339933;">,</span> <span style="color: red;">"Value={PASSWORD}"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Name=redirect_to"</span><span style="color: #339933;">,</span> <span style="color: red;">"Value=http://www.headwired.com/dashboard/"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Name=testcookie"</span><span style="color: #339933;">,</span> <span style="color: red;">"Value=1"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Name=wp-submit"</span><span style="color: #339933;">,</span> <span style="color: red;">"Value=Log In"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr_end_sub_transaction<span style="color: #009900;">(</span><span style="color: red;">"Authenticate"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Enable HTTP Redirects to time Authentication</span><br /> web_set_option<span style="color: #009900;">(</span><span style="color: red;">"MaxRedirectionDepth"</span><span style="color: #339933;">,</span> <span style="color: red;">"10"</span><span style="color: #339933;">,</span> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr_start_sub_transaction<span style="color: #009900;">(</span><span style="color: red;">"Authenticated_Page"</span><span style="color: #339933;">,</span> <span style="color: red;">"Logon"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Verify Authenticated Page</span><br /> web_reg_find<span style="color: #009900;">(</span><span style="color: red;">"Text=Dashboard"</span><span style="color: #339933;">,</span> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> web_url<span style="color: #009900;">(</span><span style="color: red;">"authenticated_page"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"URL={redirect_url}"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"TargetFrame="</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"RecContentType=text/html"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Mode=HTML"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span> <br /> <br /> lr_end_sub_transaction<span style="color: #009900;">(</span><span style="color: red;">"Authenticated_Page"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr_end_transaction<span style="color: #009900;">(</span><span style="color: red;">"Logon"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #b1b100;">return</span> <span style="color: #0000dd;">0</span><span style="color: #339933;">;</span> <br /><span style="color: #009900;">}</span></pre></div></div></div></div>

Timing HTTP Redirects in LoadRunner

- One of the most commonly misscripted elements in performance testing is web authentication. I’m not talking about integrated authenticatio...

Read more »

Using Logparser with Perfmon logs

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Logparser is an extremely useful tool for processing perfmon counters. It provides the ability to query text-based data such as log files, XML files and CSV files. This post will show you how to take a perfmon produced CSV file, and perform basic analysis on the results using logparser.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><span id="more-209"></span></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Let’s start with our extremely small example CSV file (rawdata.csv):</div><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><thead><tr><th style="background-color: #b8c3d3; background-position: initial initial; background-repeat: initial initial; border: 1px solid rgb(166, 180, 198); color: #4c555c; padding: 2px; text-align: center; vertical-align: bottom;" valign="top" width="40%"><strong>Time</strong></th><th style="background-color: #b8c3d3; background-position: initial initial; background-repeat: initial initial; border: 1px solid rgb(166, 180, 198); color: #4c555c; padding: 2px; text-align: center; vertical-align: bottom;" valign="top" width="30%"><strong>\\SERVER\Process(System)\% Processor Time</strong></th><th style="background-color: #b8c3d3; background-position: initial initial; background-repeat: initial initial; border: 1px solid rgb(166, 180, 198); color: #4c555c; padding: 2px; text-align: center; vertical-align: bottom;" valign="top" width="30%"><strong>\\SERVER\Process(Idle)\% Processor Time</strong></th></tr></thead><tbody><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:19:54.101</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.104231</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">374.8148</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:20:09.092</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.208462</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">386.5929</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:20:24.083</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.312693</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">376.1698</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:20:39.074</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.312693</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">366.5806</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:20:54.064</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.729617</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">368.6652</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:21:09.055</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.729617</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">371.3752</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:21:24.046</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.416924</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">366.7891</td></tr><tr><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">02/08/2010 13:21:39.037</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">0.521155</td><td style="border: 1px solid rgb(166, 180, 198); padding: 2px; text-align: center; vertical-align: bottom;" valign="top">349.9036</td></tr></tbody></table><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><br /><a name="more"></a>Using Logparser, we can perform SQL queries on our dataset. Unfortunately, when processing a large number of collections, logparser likes to return the following error message.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="html" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">Error: Log row too long</pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This is where relog comes in. Relog allows you to resample a log file, and then create a new log file that is based on specified counters, a time period, or a sampling interval. The following relog command will process our example CSV file and produce a new file with only the “\\SERVER\Process(System)\% Processor Time” and time columns.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">relog rawdata.<span style="color: #202020;">csv</span> <span style="color: #339933;">-</span>f CSV <span style="color: #339933;">-</span>c <span style="color: red;">"<span style="color: #000099; font-weight: bold;">\\</span>\SERVER\Process(System)\% Processor Time"</span> <span style="color: #339933;">-</span>o relogged.<span style="color: #202020;">csv</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Now we have a file that can be processed by logparser, its time to query our dataset to extract the min, max, avg and std dev. Unfortunately, the standard deviation function is not included in LogParser by default. Fortunately, a friendly <a href="http://forums.iis.net/t/1145868.aspx" style="color: #3aa6d8; text-decoration: initial;" target="_blank">forum post</a> provided some insight into a solution, and with some slight modifications, it can be used for resource utilisation stats from perfmon.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The following query will extract the minimum, maximum, average and standard deviation from the re-logged counter file. Note that COUNTER should be replaced by the perfmon collection that you are interested in, i.e. “\\Server\Process(System)\% Processor Time”</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="sql" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #993333; font-weight: bold;">SELECT</span><br /><span style="color: #993333; font-weight: bold;">MIN</span><span style="color: #66cc66;">(</span>TO_REAL<span style="color: #66cc66;">(</span><span style="color: #66cc66;">[</span> COUNTER <span style="color: #66cc66;">]</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">AS</span> Minimum<span style="color: #66cc66;">,</span><br /><span style="color: #993333; font-weight: bold;">MAX</span><span style="color: #66cc66;">(</span>TO_REAL<span style="color: #66cc66;">(</span><span style="color: #66cc66;">[</span> COUNTER <span style="color: #66cc66;">]</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">AS</span> Maximum<span style="color: #66cc66;">,</span><br />avg<span style="color: #66cc66;">(</span>TO_REAL<span style="color: #66cc66;">(</span><span style="color: #66cc66;">[</span> COUNTER <span style="color: #66cc66;">]</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">AS</span> Average<span style="color: #66cc66;">,</span><br />SQRROOT <span style="color: #66cc66;">(</span> SUB <span style="color: #66cc66;">(</span> DIV <span style="color: #66cc66;">(</span> MUL<span style="color: #66cc66;">(</span><span style="color: #cc66cc;">1.0</span><span style="color: #66cc66;">,</span> <span style="color: #993333; font-weight: bold;">SUM</span><span style="color: #66cc66;">(</span>SQR<span style="color: #66cc66;">(</span>TO_REAL<span style="color: #66cc66;">(</span><span style="color: #66cc66;">[</span> COUNTER <span style="color: #66cc66;">]</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span> <span style="color: #66cc66;">)</span><span style="color: #66cc66;">,</span> <span style="color: #993333; font-weight: bold;">COUNT</span><span style="color: #66cc66;">(</span><span style="color: #66cc66;">*</span><span style="color: #66cc66;">)</span><span style="color: #66cc66;">)</span> <span style="color: #66cc66;">,</span> SQR<span style="color: #66cc66;">(</span>Average<span style="color: #66cc66;">)</span> <span style="color: #66cc66;">)</span> <span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">AS</span> StdDev<br /><span style="color: #993333; font-weight: bold;">INTO</span> output<span style="color: #66cc66;">.</span>xml<br /><span style="color: #993333; font-weight: bold;">FROM</span> relogged<span style="color: #66cc66;">.</span>csv<br /><span style="color: #993333; font-weight: bold;">WHERE</span> TO_REAL<span style="color: #66cc66;">(</span><span style="color: #66cc66;">[</span> COUNTER <span style="color: #66cc66;">]</span><span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">IS</span> <span style="color: #993333; font-weight: bold;">NOT</span> <span style="color: #993333; font-weight: bold;">NULL</span></pre></td></tr></tbody></table></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This can be used with logparser (most likely after using relog to trim the file) using the following command:</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">logparser file<span style="color: #339933;">:</span>query.<span style="color: #202020;">txt</span> <span style="color: #339933;">-</span>o<span style="color: #339933;">:</span>xml <span style="color: #339933;">-</span>i<span style="color: #339933;">:</span>csv</pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Note that the above query must be written to the query.txt file for this to work. The resulting output.xml file will look something like this.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="html" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><!--ATTLIST ROOT DATE_CREATED CDATA #REQUIRED--><br /> <!--ATTLIST ROOT CREATED_BY CDATA #REQUIRED--><br /> <!--ELEMENT Minimum (#PCDATA)--><br /> <!--ELEMENT Maximum (#PCDATA)--><br /> <!--ELEMENT Average (#PCDATA)--><br /> <!--ELEMENT StdDev (#PCDATA)--><br /> <!--ELEMENT ROW (Minimum, Maximum, Average, StdDev)--><br /> <!--ELEMENT ROOT (ROW*)--><br />]><br /><ROOT DATE_CREATED="2010-02-08 07:22:48" CREATED_BY="Microsoft Log Parser V2.2"><br /> <ROW><br /> <Minimum><br /> 0.104231<br /> </Minimum><br /> <Maximum><br /> 0.729617<br /> </Maximum><br /> <Average><br /> 0.416924<br /> </Average><br /> <StdDev><br /> 0.214878<br /> </StdDev><br /> </ROW><br /></ROOT></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Of course, all of this could be performed in an excel spreadsheet. However the real power of logparser is when it’s used in batch processing of perfmon results. After all, who wants to open excel and look at every resource counter when you can automate the statistical analysis of your permon collections?</div></div></div>

Using Logparser with Perfmon logs

Logparser is an extremely useful tool for processing perfmon counters. It provides the ability to query text-based data such as log files, X...

Read more »

Getting to know your tools: Firebug

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div class="excerpt" style="background-color: #fbfbfb; border: 1px solid rgb(217, 217, 217); color: #999999; font-family: Verdana, Arial, sans-serif; font-size: 1.1em; font-style: italic; margin: 20px 0px 20px -35px; padding: 10px 10px 10px 60px; text-align: left;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><br />This simple tutorial aims to show you how Firebug can not only give you a better understanding of the application under test, it can also help you write better scripts.</div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Firebug" class="aligncenter size-full wp-image-1037" height="160" src="http://www.headwired.com/wp-content/uploads/2010/07/firebug.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="firebug" width="580" />I have always enjoyed introducing people to tools that I find really helpful, and one such tool is <a href="http://www.headwired.com/tag/firebug/" style="color: #3aa6d8; text-decoration: initial;" target="_blank">Firebug</a>. While this Firefox plug-in has many great features, the one that interests me the most is the <a href="http://getfirebug.com/network" style="color: #3aa6d8; text-decoration: initial;" target="_blank">Net Panel</a>. This tutorial is targeted towards a performance tester. This simple scenario aims show you how Firebug can not only give you a better understanding of the application under test, it can also help you write better scripts.<br /><span id="more-499"></span><br /><br /><a name="more"></a>Let’s start by requesting the Google homepage. With the Net Panel in Firebug, we can see the resources that are being downloaded to create the page, their URL, size and time taken to download.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="google-firebug" height="389" src="http://www.headwired.com/wp-content/uploads/2010/06/google-firebug-580x389.png" style="max-width: 100%; padding: 10px 0px;" title="google-firebug" width="580" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In the example image above, we can see our GET request for the URL, which returns our HTML. We then get 2 images, 2 JavaScript files and a call to generate a 204 request.  A closer look at the GET request shows our HTTP headers for both the request and response.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="google-request-headers" height="389" src="http://www.headwired.com/wp-content/uploads/2010/06/google-request-headers-580x389.png" style="max-width: 100%; padding: 10px 0px;" title="google-request-headers" width="580" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This is all well and good, and this type of information can be found in any Firebug tutorial. What I want to discuss is that as Performance testers, we should be looking at how the application behaves in terms of impact on the server.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Let’s say your business has asked you to determine the performance of your search page, and say your company is a small web search provider called Google. What will they want to know?</div><ol style="margin: 0px; padding: 0px 0px 0px 35px;"><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">How long to launch the search page</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">How long to search for a term</li></ol><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">They have also implemented a fancy new feature that displays suggested search terms. They will probably want to know what kind of impact this will have.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">So we open VuGen, record a scenario with three transactions.</div><ol style="margin: 0px; padding: 0px 0px 0px 35px;"><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">Open Search Page</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">Enter Search Term</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">Submit Search Query</li></ol><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">If you simply record and playback you will notice that the Enter Search Term transaction you have recorded is empty. So how can a tool like Firebug help?</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Open up Firebug and see what happens if we type in a letter into the search field?</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">We now have a new request. This request is a GET request for the search page on clients1.google.com.au. This is to retrieve the suggested search items displayed in the drop down. This request is repeated for each letter that is typed.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em; text-align: center;"><img alt="google one letter search" class="aligncenter size-large wp-image-574" height="389" src="http://www.headwired.com/wp-content/uploads/2010/06/google-oneletter-580x389.png" style="display: block; margin: 0px auto 20px; max-width: 100%; padding: 10px 0px;" title="google-oneletter" width="580" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Our performance tools may not pick up this type of client side invoked behaviour very well. In fact, LoadRunner 9.1 groups these requests along with the initial page request, like a JavaScript or image. Here is the code if you just record this scenario in VuGen.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br />9<br />10<br />11<br />12<br />13<br />14<br />15<br />16<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="c" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">web_url<span style="color: #009900;">(</span><span style="color: red;">"www.google.com.au"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"URL=http://www.google.com.au/"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"RecContentType=text/html"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Referer="</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Mode=HTML"</span><span style="color: #339933;">,</span><br /> EXTRARES<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=/images/dl_btn_mid.gif"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=/intl/en_com/images/logo_plain2.png"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=/extern_js/f/CgJlbhICYXUrMEU4ASwrMFo4ASwrMA44ESwrMBc4BywrMCc4BCwrMDw4AywrMFE4AiwrMAo4bUAdLCswFjgcLCswGTghLCswJTjKiAEsKzBAOBIsKzBOOAUsKzAYOAUsKzAmOAssgAIN/NruCKo30NSw.js"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=http://clients1.google.com.au/complete/search?hl=en&amp;client=hp&amp;expIds=17259,18168,23756,24472,24878,25013,25115,25233,25299,25335,25363,25368&amp;q=t&amp;cp=1"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=http://clients1.google.com.au/complete/search?hl=en&amp;client=hp&amp;expIds=17259,18168,23756,24472,24878,25013,25115,25233,25299,25335,25363,25368&amp;q=tes&amp;cp=3"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=http://clients1.google.com.au/complete/search?hl=en&amp;client=hp&amp;expIds=17259,18168,23756,24472,24878,25013,25115,25233,25299,25335,25363,25368&amp;q=te&amp;cp=2"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> <span style="color: red;">"Url=http://clients1.google.com.au/complete/search?hl=en&amp;client=hp&amp;expIds=17259,18168,23756,24472,24878,25013,25115,25233,25299,25335,25363,25368&amp;q=test&amp;cp=4"</span><span style="color: #339933;">,</span> ENDITEM<span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></td></tr></tbody></table></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">So what has VuGen done wrong? (Other than record the requests in the wrong order).</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Namely, it has not allowed us to separate these calls and record their response times. Worse still, if we were were comparing our open search page transaction with a version that did not contain this feature, we would be incorrectly reporting an increase in response times for this page.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Using Firebug, we have seen that the calls to<em>http://clients1.google.com.au/complete/search</em> are triggered with each letter typed into the search field.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Our code for the suggested search should therefore look something like this</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br />9<br />10<br />11<br />12<br />13<br />14<br />15<br />16<br />17<br />18<br />19<br />20<br />21<br />22<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="c" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">suggestedSearch<span style="color: #009900;">(</span><span style="color: #993333;">char</span> <span style="color: #339933;">*</span>searchTerm<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #993333;">int</span> i<span style="color: #339933;">;</span><br /> <span style="color: #993333;">char</span> progressiveSearch<span style="color: #009900;">[</span><span style="color: #0000dd;">1024</span><span style="color: #009900;">]</span> <span style="color: #339933;">=</span> <span style="color: #009900;">{</span><span style="color: #0000dd;">0</span><span style="color: #009900;">}</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #b1b100;">for</span><span style="color: #009900;">(</span>i<span style="color: #339933;">=</span><span style="color: #0000dd;">0</span><span style="color: #339933;">;</span> i<span style="color: #339933;"><</span>strlen<span style="color: #009900;">(</span>searchTerm<span style="color: #009900;">)</span><span style="color: #339933;">;</span> i<span style="color: #339933;">++</span><span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> progressiveSearch<span style="color: #009900;">[</span>i<span style="color: #009900;">]</span> <span style="color: #339933;">=</span> searchTerm<span style="color: #009900;">[</span>i<span style="color: #009900;">]</span><span style="color: #339933;">;</span><br /> lr_save_string<span style="color: #009900;">(</span>progressiveSearch<span style="color: #339933;">,</span><span style="color: red;">"mySearchTerm"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr_start_transaction<span style="color: #009900;">(</span><span style="color: red;">"Suggested_Search"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> web_url<span style="color: #009900;">(</span><span style="color: red;">"www.google.com.au"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"URL=http://clients1.google.com.au/complete/search?hl=en&client=hp&expIds=17259,18168,23756,24472,24878,25233,25510,25529,25584,25608&q={mySearchTerm}&cp=1"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"RecContentType=text/html"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Referer="</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Mode=HTML"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span> <br /> <br /> lr_end_transaction<span style="color: #009900;">(</span><span style="color: red;">"Suggested_Search"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: #b1b100;">return</span> <span style="color: #0000dd;">0</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span></pre></td></tr></tbody></table></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">While this is a very simple scenario, I think it provides a great example of how a tool like this can be a great addition to your arsenal. While the easy installation of this Firefox plug-in makes it very accessible, unfortunately for those in a locked-down corporate environment the <a href="http://getfirebug.com/firebuglite#Install" style="color: #3aa6d8; text-decoration: initial;" target="_blank">lite version</a> doesn’t include the Net Panel as its “too dependent in browser internals”. If you are looking for an alternative, <a href="http://www.httpwatch.com/" style="color: #3aa6d8; text-decoration: initial;" target="_blank">HttpWatch Basic Edition</a> is a free tool that does play well with Internet Explorer.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">There are also some other functions of the Firebug Net panel that are useful, one is the ability to quickly disable the browser cache allowing you to easily see which components of a web site would be cached and which would not.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This is where this tutorial should end, however, I can’t in good faith finish this example without some clarification. If you look closer at the way Google deals with typing in search terms quickly, not every letter typed will create a request. The word “test” typed quickly would create 2 requests, one for “te” and one for “test” and not the 4 in this example.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">As with all automated testing, the devil is in the details. It’s vital to understand the application under test. To look through the statistics provided, how many suggested searches are one letter at a time, how many are typed quickly, how many are pasted into the search window and only make one request.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Hopefully this gives you some insight into how to use a tool like Firebug to become a better performance tester.</div></div></div>

Getting to know your tools: Firebug

This simple tutorial aims to show you how Firebug can not only give you a better understanding of the application under test, it can also he...

Read more »

Performance Testing SOAP with LoadRunner – Basics

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><br /><img alt="Simple Object Access Protocol (SOAP)" class="aligncenter size-full wp-image-1035" height="250" src="http://www.headwired.com/wp-content/uploads/2011/08/soap.jpg" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="soap" width="580" />Web services are more commonly becoming the targets of Performance tests. This post aims to provide an introduction to testing SOAP with LoadRunner without using the Web Services VUser type. Why not use the Web Services Vuser? Errors like this</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">System.<span style="color: #202020;">Reflection</span>.<span style="color: #202020;">TargetInvocationException</span><span style="color: #339933;">:</span> Exception has been thrown by the target of an invocation. <span style="color: #339933;">---&</span>gt<span style="color: #339933;">;</span> System.<span style="color: #202020;">Xml</span>.<span style="color: #202020;">XmlException</span><span style="color: #339933;">:</span> <span style="color: red;">'xsi'</span> is an undeclared namespace.</pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><br /><a name="more"></a>Using the custom web request (as suggested by <a href="http://www.wilsonmar.com/1lrscript.htm#WebSvcs" style="color: #3aa6d8; text-decoration: initial;">Wilson Mar</a>, <a href="http://www.myloadtest.com/web-service-testing-with-standard-web-vuser/" style="color: #3aa6d8; text-decoration: initial;">Stuart Moncrieff</a>and many others) bypasses the XML validation steps of LoadRunner, which is a good thing. This is possible because SOAP is just XML over HTTP, so lets take a look.<br /><span id="more-10"></span></div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Understanding SOAP</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">A typical SOAP message is made up of header and body encapsulated in a SOAP envelope. The SOAP header contains application-specific information (like authentication, payment, etc) about the SOAP message. The header is optional, yet if present, must be the first child element of the Envelope. The SOAP body element contains the actual message.<br /><a href="http://en.wikipedia.org/wiki/File:SOAP.svg" style="color: #3aa6d8; text-decoration: initial;"><img alt="SOAP Envelope" class="aligncenter size-full wp-image-834" height="213" src="http://www.headwired.com/wp-content/uploads/2011/04/200px-SOAP.svg_.png" style="border: none; display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="SOAP Envelope" width="200" /></a>As SOAP uses HTTP as an application protocol, it utilises a request / response model. A SOAP request is sent to the endpoint via a HTTP POST and the returned SOAP message uses the same response codes for HTTP (200 OK, etc). This request is to get the stock price for the ticker symbol HWB (Headwired Bank), with the response returning a price of $460.75 as the last traded price.</div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">SOAP Request</h3><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">POST /StockQuote HTTP/1.1<br />Host: headwired.com<br />Content-Type: text/xml; charset="utf-8"<br />Content-Length: 1452<br /> <br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"><soapenv:Envelope</span> <span style="color: #000066;">xmlns:soapenv</span>=<span style="color: red;">"http://schemas.xmlsoap.org/soap/envelope/"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><soapenv:Body></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><m:GetLastTradePrice</span> <span style="color: #000066;">xmlns:m</span>=<span style="color: red;">"headwired.com"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><m:tickerSymbol></span></span>HWB<span style="color: #009900;"><span style="color: black; font-weight: bold;"></m:tickerSymbol></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></m:GetLastTradePrice></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></soapenv:Body></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></soapenv:Envelope></span></span></pre></div></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">SOAP Response</h3><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">HTTP/1.1 200 OK<br />Content-Type: text/xml; charset="utf-8"<br />Content-Length: 1298<br /> <br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"><soapenv:Envelope</span> <span style="color: #000066;">xmlns:soapenv</span>=<span style="color: red;">"http://schemas.xmlsoap.org/soap/envelope/"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><soapenv:Body></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><m:GetLastTradePriceResponse</span> <span style="color: #000066;">xmlns:m</span>=<span style="color: red;">"Some-URI"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><m:price></span></span>460.75<span style="color: #009900;"><span style="color: black; font-weight: bold;"></m:price></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></m:GetLastTradePriceResponse></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></soapenv:Body></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></soapenv:Envelope></span></span></pre></div></div><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">SOAP as a Web Service</h2><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">As a Web Service, the structure of all supported SOAP requests and responses are provided in a WSDL (Web Service Definitions Language). A WSDL provides the following information:</div><ul style="margin-left: 0px; padding: 0px 0px 0px 20px;"><li style="margin: 7px 0px 8px 10px;">The interactions service provided</li><li style="margin: 7px 0px 8px 10px;">The arguments and results are involved in the interactions</li><li style="margin: 7px 0px 8px 10px;">The network addresses are used to locate the service</li><li style="margin: 7px 0px 8px 10px;">The communication protocol that should be used</li><li style="margin: 7px 0px 8px 10px;">The data formats that messages are represented in</li></ul><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In our example SOAP web have a structure for our request in the SOAP body. We have a <em>GetLastTradePrice</em> tag, with a child tickerSymbol . How can we determine that this is what we need to submit by looking at the WSDL? The following WSDL definition declares what elements should be in GetLastTradePrice input request.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #009900;"><span style="color: black; font-weight: bold;"><message</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePriceInput"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><part</span> <span style="color: #000066;">name</span>=<span style="color: red;">"body"</span> <span style="color: #000066;">element</span>=<span style="color: red;">"xsd1:TradePriceRequest"</span><span style="color: black; font-weight: bold;">/></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></message></span></span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This specifies that our input should contain the “ TradePriceRequest” element which is also defined in the WSDL. The definition is for one element “tickerSymbol” that must be a string value.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"TradePriceRequest"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"tickerSymbol"</span> <span style="color: #000066;">type</span>=<span style="color: red;">"string"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></complexType></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></element></span></span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The WSDL will also specify the response that we should expect from this request.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #009900;"><span style="color: black; font-weight: bold;"><message</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePriceOutput"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><part</span> <span style="color: #000066;">name</span>=<span style="color: red;">"body"</span> <span style="color: #000066;">element</span>=<span style="color: red;">"xsd1:TradePrice"</span><span style="color: black; font-weight: bold;">/></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></message></span></span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This specifies that our input should contain the “TradePrice” element which is also defined in the WSDL. The definition is for one element “price” that will contain a float value.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"TradePrice"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"price"</span> <span style="color: #000066;">type</span>=<span style="color: red;">"float"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></complexType></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></element></span></span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The WSDL below is a rough example of the stock service that would be used by the example SOAP.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="xml" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #009900;"><span style="color: black; font-weight: bold;"><?xml</span> <span style="color: #000066;">version</span>=<span style="color: red;">"1.0"</span><span style="color: black; font-weight: bold;">?></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"><definitions</span> <span style="color: #000066;">name</span>=<span style="color: red;">"Stock"</span> <span style="color: #000066;">targetNamespace</span>=<span style="color: red;">"http://headwired.com/stock.wsdl"</span></span><br /><span style="color: #009900;"> <span style="color: #000066;">xmlns:tns</span>=<span style="color: red;">"http://headwired.com/stock.wsdl"</span></span><br /><span style="color: #009900;"> <span style="color: #000066;">xmlns:xsd1</span>=<span style="color: red;">"http://headwired.com/stock.xsd"</span></span><br /><span style="color: #009900;"> <span style="color: #000066;">xmlns:soap</span>=<span style="color: red;">"http://schemas.xmlsoap.org/wsdl/soap/"</span></span><br /><span style="color: #009900;"> <span style="color: #000066;">xmlns</span>=<span style="color: red;">"http://schemas.xmlsoap.org/wsdl/"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><types></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><schema</span> <span style="color: #000066;">targetNamespace</span>=<span style="color: red;">"http://headwired.com/stock.xsd"</span></span><br /><span style="color: #009900;"> <span style="color: #000066;">xmlns</span>=<span style="color: red;">"http://www.w3.org/2000/10/XMLSchema"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"TradePriceRequest"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><all></span><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"tickerSymbol"</span> <span style="color: #000066;">type</span>=<span style="color: red;">"string"</span><span style="color: black; font-weight: bold;">/></span><span style="color: black; font-weight: bold;"></all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></element></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"TradePrice"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><all></span><span style="color: black; font-weight: bold;"><element</span> <span style="color: #000066;">name</span>=<span style="color: red;">"price"</span> <span style="color: #000066;">type</span>=<span style="color: red;">"float"</span><span style="color: black; font-weight: bold;">/></span><span style="color: black; font-weight: bold;"></all></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></complexType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></element></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></schema></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></types></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><message</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePriceInput"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><part</span> <span style="color: #000066;">name</span>=<span style="color: red;">"body"</span> <span style="color: #000066;">element</span>=<span style="color: red;">"xsd1:TradePriceRequest"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></message></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><message</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePriceOutput"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><part</span> <span style="color: #000066;">name</span>=<span style="color: red;">"body"</span> <span style="color: #000066;">element</span>=<span style="color: red;">"xsd1:TradePrice"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></message></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><portType</span> <span style="color: #000066;">name</span>=<span style="color: red;">"StockPortType"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><operation</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePrice"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><input</span> <span style="color: #000066;">message</span>=<span style="color: red;">"tns:GetLastTradePriceInput"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><output</span> <span style="color: #000066;">message</span>=<span style="color: red;">"tns:GetLastTradePriceOutput"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></operation></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></portType></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><binding</span> <span style="color: #000066;">name</span>=<span style="color: red;">"StockSoapBinding"</span> <span style="color: #000066;">type</span>=<span style="color: red;">"tns:StockPortType"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><soap:binding</span> <span style="color: #000066;">style</span>=<span style="color: red;">"document"</span> <span style="color: #000066;">transport</span>=<span style="color: red;">"http://schemas.xmlsoap.org/soap/http"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><operation</span> <span style="color: #000066;">name</span>=<span style="color: red;">"GetLastTradePrice"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><soap:operation</span> <span style="color: #000066;">soapAction</span>=<span style="color: red;">"http://headwired.com/GetLastTradePrice"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><input></span><span style="color: black; font-weight: bold;"><soap:body</span> <span style="color: #000066;">use</span>=<span style="color: red;">"literal"</span><span style="color: black; font-weight: bold;">/></span><span style="color: black; font-weight: bold;"></input></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><output></span><span style="color: black; font-weight: bold;"><soap:body</span> <span style="color: #000066;">use</span>=<span style="color: red;">"literal"</span><span style="color: black; font-weight: bold;">/></span><span style="color: black; font-weight: bold;"></output></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></operation></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></binding></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><service</span> <span style="color: #000066;">name</span>=<span style="color: red;">"StockService"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><documentation></span></span>My first service<span style="color: #009900;"><span style="color: black; font-weight: bold;"></documentation></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><port</span> <span style="color: #000066;">name</span>=<span style="color: red;">"StockPort"</span> <span style="color: #000066;">binding</span>=<span style="color: red;">"tns:StockBinding"</span><span style="color: black; font-weight: bold;">></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"><soap:address</span> <span style="color: #000066;">location</span>=<span style="color: red;">"http://headwired.com/stock"</span><span style="color: black; font-weight: bold;">/></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></port></span></span><br /> <span style="color: #009900;"><span style="color: black; font-weight: bold;"></service></span></span><br /><span style="color: #009900;"><span style="color: black; font-weight: bold;"></definitions></span></span></pre></div></div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">SOAP With LoadRunner Custom Requests</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">SOAP in its most basic form is XML + HTTP. Therefore, we can use the LoadRunner web_custom_request function to manually specify our SOAP message. This method is more verbose than a web_service_call script, yet as it is a web request, there is no XML parsing performed by LoadRunner. This can be very useful if your web_service_call scripts are returning errors.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Scripting a web service is different a web page. Firstly, unless you have a client application, you will not be able to record and replay, instead you will have to recreate the web service calls based on logs, interface specification documents or a WSDL. It is also important to understand how the operations of the web service will be used in production.</div><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">Setup</h2><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This section discusses the steps to setup your LoadRunner script to commence scripting.</div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Script Type</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">A web_custom_request script for SOAP should be created as a “Web (HTTP/HTML)” script. This allows for Internet Protocol Run Time settings to be configured for handling authentication in a more effective way (read: web_set_sockets_option).</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Web HTTP Script in LoadRunner" class="aligncenter size-full wp-image-843" height="106" src="http://www.headwired.com/wp-content/uploads/2011/04/web_http_script.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="web_http_script" width="277" /></div><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">Authentication</h2><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The web service you are using may require HTTP level Authentication in order to access the web service operations. This can be performed using a simple web_set_user command in LoadRunner. To avoid a Authentication Error on your first request, the web_set_sockets_option can be configured along with the “Enable Integrated Authentication” run-time setting to avoid this issue.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Requires "Enable Integrated Authentication" to be set to "yes"</span><br />web_set_sockets_option<span style="color: #009900;">(</span><span style="color: red;">"INITIAL_BASIC_AUTH"</span><span style="color: #339933;">,</span><span style="color: red;">"1"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /><span style="color: #666666; font-style: italic;">// Authenticate</span><br />web_set_user<span style="color: #009900;">(</span><span style="color: red;">"USERNAME"</span><span style="color: #339933;">,</span><span style="color: red;">"PASSWORD"</span><span style="color: #339933;">,</span><span style="color: red;">"www.headwired.com:443"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">To enable integrated authentication, open “Run-time Settings > Internet Protocol > Preferences > Set Advanced Options” and select yes for “Enable Integrated Authentication”. More information about authentication can be found <a href="http://altentee.com/2009/improved-spnego-or-kerberos-support-with-loadrunner/" style="color: #3aa6d8; text-decoration: initial;">here</a>.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Enable Integrated Authentication in LoadRunner" class="aligncenter size-full wp-image-844" height="492" src="http://www.headwired.com/wp-content/uploads/2011/04/enable_integrated_authentication.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="enable_integrated_authentication" width="470" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">There may also be the requirement to login using multiple authentication pairs throughout the test. This is possible through the use of the web_cleanup_cookies function. This function will remove all cookies related to the VUser, including NTLM authentication cookies.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Clear previous logins</span><br />web_cleanup_cookies<span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Scripting</h1><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">Making the Request</h2><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In order to use the web_custom_request function for SOAP, we must specify that we will be submitting text/xml. The web_add_header function is used to specify this.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Set Headers to plain text / xml</span><br />web_add_header<span style="color: #009900;">(</span><span style="color: red;">"Content-Type"</span><span style="color: #339933;">,</span> <span style="color: red;">"text/xml; charset=utf8"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The web_custom_request is pretty straightforward. You specify your URL, Method and Body of the request. The SOAP message, including XML specification and Envelope is placed in the Body section of the request.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">web_custom_request<span style="color: #009900;">(</span><span style="color: red;">"Transaction_Name"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"URL=https://www.headwired.com/StockQuote"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"Method=POST"</span><span style="color: #339933;">,</span> <span style="color: red;">"TargetFrame="</span><span style="color: #339933;">,</span> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span> <span style="color: red;">"Referer="</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"Body=<?xml version=<span style="color: #000099; font-weight: bold;">\"</span>1.0<span style="color: #000099; font-weight: bold;">\"</span> encoding=<span style="color: #000099; font-weight: bold;">\"</span>ISO-8859-1<span style="color: #000099; font-weight: bold;">\"</span>?>"</span> <br /> <span style="color: #339933;"><</span>SOAP Envelope Here<span style="color: #339933;">></span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">Verifying the Response</h2><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The simplest way to verify the response of a SOAP request is to use the web_reg_find function. This allows the specification of text that must be matched within the response text.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Ensure the response contains correct text</span><br />web_reg_find<span style="color: #009900;">(</span><span style="color: red;">"Text=GetLastTradePriceResponse"</span><span style="color: #339933;">,</span>LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">To extract data from the response and save it as a parameter, you may also use the web_reg_save_param function. In the example below, the entire XML response, including HTTP headers is saved in the “response” variable.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Save entire response as a string</span><br />web_reg_save_param<span style="color: #009900;">(</span><span style="color: red;">"response"</span><span style="color: #339933;">,</span><span style="color: red;">"LB="</span><span style="color: #339933;">,</span><span style="color: red;">"RB="</span><span style="color: #339933;">,</span>LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Debugging Tips</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Perhaps the easiest way to debug a web services script that utilises the web_custom_request function is to enable “Visual test results”. This feature can be enabled via the VuGen General Options, Replay Tab</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Visual Test Results" class="aligncenter size-full wp-image-845" height="258" src="http://www.headwired.com/wp-content/uploads/2011/04/virual_test_results.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="virual_test_results" width="373" /></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The visual test results will display a report after replaying a script and provide you a script tree view, and allow you to view the XML response from the SOAP server.</div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Example Script</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The following is a LoadRunner script that will send our sample SOAP request to the server. It will ensure that the response contains the term “GetLastTradePriceResponse”. As SOAP uses HTTP, any HTTP level errors (401, 500) will also automatically be failed by LoadRunner.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br />9<br />10<br />11<br />12<br />13<br />14<br />15<br />16<br />17<br />18<br />19<br />20<br />21<br />22<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="c" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Ensure the response contains correct text</span><br />web_reg_find<span style="color: #009900;">(</span><span style="color: red;">"Text=GetLastTradePriceResponse"</span><span style="color: #339933;">,</span>LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /><span style="color: #666666; font-style: italic;">// Set Headers to plain text / xml</span><br />web_add_header<span style="color: #009900;">(</span><span style="color: red;">"Content-Type"</span><span style="color: #339933;">,</span> <span style="color: red;">"text/xml; charset=ISO-8859-1"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span> <br /> <br /><span style="color: #666666; font-style: italic;">// Submit SOAP Request</span><br />lr_start_transaction<span style="color: #009900;">(</span><span style="color: red;">"SOAP_GetLastTradePrice"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br />web_custom_request<span style="color: #009900;">(</span><span style="color: red;">"SOAP_GetLastTradePrice"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"URL=http://www.headwired.com/stock"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"Method=POST"</span><span style="color: #339933;">,</span> <span style="color: red;">"TargetFrame="</span><span style="color: #339933;">,</span> <span style="color: red;">"Resource=0"</span><span style="color: #339933;">,</span> <span style="color: red;">"Referer="</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"Body=<?xml version=<span style="color: #000099; font-weight: bold;">\"</span>1.0<span style="color: #000099; font-weight: bold;">\"</span> encoding=<span style="color: #000099; font-weight: bold;">\"</span>ISO-8859-1<span style="color: #000099; font-weight: bold;">\"</span>?>"</span> <br /><span style="color: red;">"<soapenv:Envelope xmlns:soapenv=<span style="color: #000099; font-weight: bold;">\"</span>http://schemas.xmlsoap.org/soap/envelope/<span style="color: #000099; font-weight: bold;">\"</span>>"</span><br /> <span style="color: red;">"<soapenv:Body>"</span><br /> <span style="color: red;">"<m:GetLastTradePrice xmlns:m=<span style="color: #000099; font-weight: bold;">\"</span>Some-URI<span style="color: #000099; font-weight: bold;">\"</span>>"</span><br /> <span style="color: red;">"<m:tickerSymbol>HWB</m:tickerSymbol>"</span><br /> <span style="color: red;">"</m:GetLastTradePrice>"</span><br /> <span style="color: red;">"</soapenv:Body>"</span><br /><span style="color: red;">"</soapenv:Envelope>"</span><br /> <span style="color: red;">"Snapshot=t1.inf"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span> <br />lr_end_transaction<span style="color: #009900;">(</span><span style="color: red;">"SOAP_GetLastTradePrice"</span><span style="color: #339933;">,</span> LR_AUTO<span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></td></tr></tbody></table></div><div class="references" style="padding-bottom: 5px;"><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 10px;">Links and References</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><a href="http://www.w3schools.com/soap/" style="background-image: url(http://www.headwired.com/wp-content/themes/headwired/images/icon_url_small.png); background-repeat: no-repeat no-repeat; color: #3aa6d8; display: block; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 0.9em; height: 16px; margin-left: 30px; padding-left: 20px; text-decoration: initial;">W3Schools SOAP Tutorial</a><br /><a href="http://www.w3.org/TR/wsdl" style="background-image: url(http://www.headwired.com/wp-content/themes/headwired/images/icon_url_small.png); background-repeat: no-repeat no-repeat; color: #3aa6d8; display: block; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 0.9em; height: 16px; margin-left: 30px; padding-left: 20px; text-decoration: initial;">WSDL Authentication</a><br /><a href="http://90kts.com/blog/2009/improved-spnego-or-kerberos-support-with-loadrunner/" style="background-image: url(http://www.headwired.com/wp-content/themes/headwired/images/icon_url_small.png); background-repeat: no-repeat no-repeat; color: #3aa6d8; display: block; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 0.9em; height: 16px; margin-left: 30px; padding-left: 20px; text-decoration: initial;">Authentication</a></div></div></div></div>

Performance Testing SOAP with LoadRunner – Basics

Web services are more commonly becoming the targets of Performance tests. This post aims to provide an introduction to testing SOAP with Loa...

Read more »

Using mldap_modify & mldap_delete functions in LoadRunner

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Deleted" class="aligncenter size-full wp-image-1032" height="202" src="http://www.headwired.com/wp-content/uploads/2011/09/deleted.png" style="display: block; font-size: 1.2em; line-height: 1.3em; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="deleted" width="580" /><br />I have written before about using the LDAP protocol using LoadRunner. This time, I had a requirement to reset the passwords for all my test users before an execution. Luckily for me, there was already some shell scripts setup that utilised ldapmodify, so it was just a matter of converting them over to LoadRunner scripts.<br /><span id="more-988"></span><br />After binding to the LDAP server, the first command was to delete the users password history to get around the password policy. The batch file called the ldapmodify function like below<br /><a name="more"></a></div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">ldapmodify <span style="color: #339933;">-</span>h ldap.<span style="color: #202020;">headwired</span>.<span style="color: #202020;">com</span> <span style="color: #339933;">-</span>p <span style="color: #0000dd;">389</span> <span style="color: #339933;">-</span>D <span style="color: red;">'cn=Directory Manager'</span> <span style="color: #339933;">-</span>w PASSWORD <span style="color: #339933;"><<</span>EOF<br /> <br />dn<span style="color: #339933;">:</span> uid<span style="color: #339933;">=</span>$USERNAME<span style="color: #339933;">,</span>ou<span style="color: #339933;">=</span>people<span style="color: #339933;">,</span>dc<span style="color: #339933;">=</span>headwired<span style="color: #339933;">,</span>dc<span style="color: #339933;">=</span>com<br />changetype<span style="color: #339933;">:</span> modify<br />delete<span style="color: #339933;">:</span> passwordHistory<br /> <br />EOF</pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">As the action is actually a delete, this translates to the mldap_delete function in LoadRunner.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Clear Password History</span><br />mldap_delete<span style="color: #009900;">(</span><span style="color: red;">"LDAP Delete"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"DN=uid={USERNAME},ou=people,dc=headwired,dc=com "</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"AttrName=passwordHistory"</span><span style="color: #339933;">,</span> <br /> LAST <span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The next step was reseting the actual password, and here is the script again. Note that as the script must authenticate every time it calls ldapmodify.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;">ldapmodify <span style="color: #339933;">-</span>h ldap.<span style="color: #202020;">headwired</span>.<span style="color: #202020;">com</span> <span style="color: #339933;">-</span>p <span style="color: #0000dd;">389</span> <span style="color: #339933;">-</span>D <span style="color: red;">'cn=Directory Manager'</span> <span style="color: #339933;">-</span>w PASSWORD <span style="color: #339933;"><<</span>EOF<br /> <br />dn<span style="color: #339933;">:</span> uid<span style="color: #339933;">=</span>$USERNAME<span style="color: #339933;">,</span>ou<span style="color: #339933;">=</span>people<span style="color: #339933;">,</span>dc<span style="color: #339933;">=</span>headwired<span style="color: #339933;">,</span>dc<span style="color: #339933;">=</span>com<br />changetype<span style="color: #339933;">:</span> modify<br />replace<span style="color: #339933;">:</span> userpassword<br />userpassword<span style="color: #339933;">:</span> $PASSWORD<br /> <br />EOF</pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This time, we will use the mldap_modify function to change the userpassword value</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="c" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Update Password</span><br />mldap_modify<span style="color: #009900;">(</span><span style="color: red;">"LDAP Modify"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"DN=uid={USERNAME},ou=people,dc=headwired,dc=com"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"AttrName=userpassword"</span><span style="color: #339933;">,</span> <span style="color: #666666; font-style: italic;">// Name of attribute </span><br /> <span style="color: red;">"AttrValue={PASSWORD}"</span><span style="color: #339933;">,</span> <span style="color: #666666; font-style: italic;">// New Value </span><br /> LAST <span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">While the task to be performed here is very trivial, it’s a simple demonstration of the mldap_modify and mldap_delete functions. The full script is below.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br />9<br />10<br />11<br />12<br />13<br />14<br />15<br />16<br />17<br />18<br />19<br />20<br />21<br />22<br />23<br />24<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="c" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">Action<span style="color: #009900;">(</span><span style="color: #009900;">)</span><br /><span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// LDAP Bind</span><br /> mldap_logon<span style="color: #009900;">(</span><span style="color: red;">"TRANSACTION_NAME"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"URL=ldap://cn=Directory Manager:PASSWORD@ldap.headwired.com:389/ "</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Version=3"</span><span style="color: #339933;">,</span><br /> <span style="color: red;">"Mode=Async"</span><span style="color: #339933;">,</span><br /> LAST<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Clear Password History</span><br /> mldap_delete<span style="color: #009900;">(</span><span style="color: red;">"LDAP Delete"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"DN=uid={USERNAME},ou=people,dc=headwired,dc=com "</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"AttrName=passwordHistory"</span><span style="color: #339933;">,</span> <br /> LAST <span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Update Password</span><br /> mldap_modify<span style="color: #009900;">(</span><span style="color: red;">"LDAP Modify"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"DN=uid={USERNAME},ou=people,dc=headwired,dc=com"</span><span style="color: #339933;">,</span> <br /> <span style="color: red;">"AttrName=userpassword"</span><span style="color: #339933;">,</span> <span style="color: #666666; font-style: italic;">// Name of attribute </span><br /> <span style="color: red;">"AttrValue={PASSWORD}"</span><span style="color: #339933;">,</span> <span style="color: #666666; font-style: italic;">// New Value </span><br /> LAST <span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #b1b100;">return</span> <span style="color: #0000dd;">0</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span></pre></td></tr></tbody></table></div></div></div>

Using mldap_modify & mldap_delete functions in LoadRunner

I have written before about using the LDAP protocol using LoadRunner. This time, I had a requirement to reset the passwords for all my test ...

Read more »

Performance Testing Oracle via JDBC with LoadRunner – Basics

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><div class="entry" style="background-color: white; color: #737984; font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 12px; line-height: 1.4em; text-align: justify;"><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This post discusses a method for testing Oracle via a JDBC connection, to simulate application interaction with the database. It is designed as an introduction to get you started, where you take it from there is up to you.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><span id="more-35"></span></div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Understanding JDBC</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases—SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The JDBC Thin Driver used in this method is a JDBC Type 4 driver that uses Java to connect directly to Oracle via the TNS protocol. This driver is written completely in Java and is hence platform independent and provides the best performance of all JDBC driver types.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><a href="http://en.wikipedia.org/wiki/JDBC_driver#Type_4_Driver_-_Native-Protocol_Driver" style="color: #3aa6d8; text-decoration: initial;"><img alt="JDBC - Type 4 Driver - Native-Protocol Driver" class="aligncenter size-full wp-image-300" height="414" src="http://www.headwired.com/wp-content/uploads/2010/02/File_Native_Protocol_driver.png" style="border: none; display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="File_Native_Protocol_driver" width="343" /></a></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;"><a name="more"></a>Connection String Examples</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The following URL connects user joel with password sydney to a database with service orcl (Important: see more on services) through port 1521 of host myhost, using the Thin driver.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">jdbc:oracle:thin:joel/sydney@//headwired.com:1521/orcl</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">This URL connects to the same database using the the OCI driver and the SID inst1 without specifying the username or password.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">jdbc:oracle:oci:@headwired.com:1521:inst1</div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">LoadRunner Oracle via JDBC (Java VUser)</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">As JDBC is widely used and documented in the Java world, we can use the Java Vuser to use the Java JDBC examples directly in our Vuser script.</div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Requirements</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In order to script an Oracle JDBC connection you require</div><ol style="margin: 0px; padding: 0px 0px 0px 35px;"><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">JDBC Connection String</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">JDK</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">Oracle JDBC Drivers</li></ol><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">JDK Path</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">As a Java VUser, the JDK location must be set. This is required to be the same for all load generators as this is a run-time setting for the script rather than the generator itself. In the example (See Figure 1) the JDK path is set to “C:\JDK\”. Note that this JDK directory must contain a “bin” directory that contains the <em>javac.exe</em>.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em; text-align: center;"><img alt="Runtime Settings - JDK" class="aligncenter size-full wp-image-414" height="255" src="http://www.headwired.com/wp-content/uploads/2010/05/Runtime_Settings-JDK.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="Runtime_Settings-JDK" width="382" /></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Script Type</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The script type used for Java is the “Java Record Replay” or whatever you have a license for.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="LR Record Replay" class="aligncenter size-full wp-image-421" height="93" src="http://www.headwired.com/wp-content/uploads/2010/05/LR_Record_Replay.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="LR_Record_Replay" width="204" /></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Database Drivers</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">To establish a connection to the database, we are obviously using JDBC. In this example we will be using the “Thin” drivers as they are considered to be smaller and faster than the OCI drivers, and doesn’t require a pre-installed version of the JDBC drivers. This is particularly important for managing the Oracle JDBC drivers across multiple machines. With the Thin driver, we can include the Oracle thing JDBC driver JAR files directly in our script to make them portable and not have to worry about installing them on each and every load generator.</div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;"><img alt="Oracle Drivers Included" class="aligncenter size-full wp-image-415" height="127" src="http://www.headwired.com/wp-content/uploads/2010/05/Oracle_Drivers_Included.png" style="display: block; margin-left: auto; margin-right: auto; max-width: 100%; padding: 10px 0px;" title="Oracle_Drivers_Included" width="116" /></div><h2 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.3em; font-weight: normal; margin: 20px 0px 0px;">Scripting</h2><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Java vs. C</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The JDBC connection script uses a Java VUser as opposed to the regular C script. As much as it would be simpler to stick with C for familiarity, as JDBC is a Java API, it made sense. There are a few small changes with Java script when compared to a C script</div><ol style="margin: 0px; padding: 0px 0px 0px 35px;"><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">vuser_init and vuser_end are contained in the action script</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">Every function is different than in C (lr_start_transaction(); becomes lr.start_transaction();)</li><li style="list-style: decimal outside; margin: 7px 0px 8px 10px; padding: 0px;">You now have to worry about JDK and Class path run-time settings</li></ol><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">It is important to consider these elements, especially point 3. The JDK run-time setting must specify the JDK location path. This path will have to be the same on ALL load generation machines.</div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Connecting to the Database</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">There are two steps in a Java to connect to an Oracle database via a JDBC connection. The first step is to dynamically load the Oracle JDBC driver class.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Load Oracle JDBC Driver</span><br /><span style="color: black; font-weight: bold;">Class</span>.<span style="color: #006633;">forName</span><span style="color: #009900;">(</span><span style="color: blue;">"oracle.jdbc.driver.OracleDriver"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The second step is to make the connection to the database using a JDBC connection string, username and password. The following example is connecting to the <em>headwired.com</em> host on port <em>1521</em> and the database SID of<em>HWD</em>.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Specify the JDBC Connection String</span><br /><span style="color: #003399;">String</span> url <span style="color: #339933;">=</span> <span style="color: blue;">"jdbc:oracle:thin:@headwired.com:1521:HWD"</span><span style="color: #339933;">;</span><br /> <br /><span style="color: #666666; font-style: italic;">// Connect to URL using USERNAME and PASSWORD</span><br />connection <span style="color: #339933;">=</span> <span style="color: #003399;">DriverManager</span>.<span style="color: #006633;">getConnection</span><span style="color: #009900;">(</span>url,<span style="color: blue;">"HEADWIRED"</span>,lr.<span style="color: #006633;">decrypt</span><span style="color: #009900;">(</span><span style="color: blue;">"4b102b"</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Of course being Java, we have to do all the work and specify what we would like to happen if any of the steps fail. The following is an example of an init function that is designed to connect to the database and gracefully abort the Vuser if the database connection cannot be made.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">// Create global connection variable</span><br /><span style="color: black; font-weight: bold;">private</span> <span style="color: #003399;">Connection</span> connection<span style="color: #339933;">;</span><br /> <br /><span style="color: #666666; font-style: italic;">// VUser Init</span><br /><span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> init<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: black; font-weight: bold;">throws</span> <span style="color: #003399;">ClassNotFoundException</span>, <span style="color: #003399;">SQLException</span> <span style="color: #009900;">{</span><br /> <br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Load Oracle JDBC Driver</span><br /> <span style="color: black; font-weight: bold;">Class</span>.<span style="color: #006633;">forName</span><span style="color: #009900;">(</span><span style="color: blue;">"oracle.jdbc.driver.OracleDriver"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">Exception</span> ex<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// If driver load is unsuccessful</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Database Driver not found"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">abort</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Specify the JDBC Connection String (jdbc:oracle:thin:@HOST:PORT:SID)</span><br /> <span style="color: #003399;">String</span> url <span style="color: #339933;">=</span> <span style="color: blue;">"jdbc:oracle:thin:@headwired.com:1521:HWD"</span><span style="color: #339933;">;</span><br /> <span style="color: #666666; font-style: italic;">// Connect to URL using USERNAME and PASSWORD</span><br /> connection <span style="color: #339933;">=</span> <span style="color: #003399;">DriverManager</span>.<span style="color: #006633;">getConnection</span><span style="color: #009900;">(</span>url,<span style="color: blue;">"HEADWIRED"</span>,lr.<span style="color: #006633;">decrypt</span><span style="color: #009900;">(</span><span style="color: blue;">"4b102b"</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"JDBC Connection Successful"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">SQLException</span> e<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// If Connection Failed</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Database Connection Failed, Please check your connection string"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">abort</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span> <span style="color: #666666; font-style: italic;">//end of init</span></pre></div></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Database Query Function</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In an effort to make scripts as easy to read and understand as possible, I have written a database query function that will return a pass or fail for the currently open transaction. This function performs a Database Query with the parsed in query. The Java code to execute a query against out JDBC connection is as follows.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #003399;">String</span> SQL_QUERY <span style="color: #339933;">=</span> “SELECT <span style="color: #339933;">*</span> FROM TABLE”<span style="color: #339933;">;</span><br /><span style="color: #003399;">Statement</span> stmt <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /><span style="color: #003399;">ResultSet</span> rset <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <br />connection.<span style="color: #006633;">setAutoCommit</span><span style="color: #009900;">(</span><span style="color: #000066; font-weight: bold;">false</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br />stmt <span style="color: #339933;">=</span> connection.<span style="color: #006633;">createStatement</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br />rset <span style="color: #339933;">=</span> stmt.<span style="color: #006633;">executeQuery</span><span style="color: #009900;">(</span>SQL_QUERY<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br />rset.<span style="color: #006633;">close</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">The results of the query can be printed using the following code. Note that logging / printing of results should be avoided in a performance test script as takes additional time and processing power to log something that we should not need to look at. This is provided for debugging purposes only.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: black; font-weight: bold;">while</span> <span style="color: #009900;">(</span>rset.<span style="color: #006633;">next</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span>rset.<span style="color: #006633;">getString</span><span style="color: #009900;">(</span><span style="color: #cc66cc;">1</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span></pre></div></div><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Being Java of course we have to provide a very verbose bit of code to get our errors handled. The following is the entire database_query function.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> database_query<span style="color: #009900;">(</span><span style="color: #003399;">String</span> SQL_QUERY<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #003399;">Statement</span> stmt <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <span style="color: #003399;">ResultSet</span> rset <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> connection.<span style="color: #006633;">setAutoCommit</span><span style="color: #009900;">(</span><span style="color: #000066; font-weight: bold;">false</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> stmt <span style="color: #339933;">=</span> connection.<span style="color: #006633;">createStatement</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> rset <span style="color: #339933;">=</span> stmt.<span style="color: #006633;">executeQuery</span><span style="color: #009900;">(</span>SQL_QUERY<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #666666; font-style: italic;">// The transaction can be set to a Passed Status</span><br /> lr.<span style="color: #006633;">set_transaction_status</span><span style="color: #009900;">(</span>lr.<span style="color: #006633;">PASS</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Print the results (For Debugging Only)</span><br /> <span style="color: #666666; font-style: italic;">/*<br /> while (rset.next()) {<br /> lr.log_message(rset.getString(1));<br /> }<br /> lr.log_message("SQL Query Executed Successfully");<br /> */</span><br /> rset.<span style="color: #006633;">close</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">SQLException</span> e<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// SQL Query has failed</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Caught Exception: "</span> <span style="color: #339933;">+</span> e.<span style="color: #006633;">getMessage</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #666666; font-style: italic;">// The transaction must be set to a Failed Status</span><br /> lr.<span style="color: #006633;">set_transaction_status</span><span style="color: #009900;">(</span>lr.<span style="color: #006633;">FAIL</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">1</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span></pre></div></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Scripting a Scenario</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Through the use of functions such as database_query, our actual script can be kept very clean. An example that performs three SQL queries on the database with a 5 second think time is below. Note that the example shows SELECT statements, however any SQL command could be used.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><div class="code" style="padding: 2px 4px; vertical-align: top;"><pre class="java" style="clear: none; float: none; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> action<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: black; font-weight: bold;">throws</span> <span style="color: #003399;">ClassNotFoundException</span>, <span style="color: #003399;">SQLException</span> <span style="color: #009900;">{</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 1</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_1"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"select BANNER from VERSION"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_1"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr.<span style="color: #006633;">think_time</span><span style="color: #009900;">(</span><span style="color: #cc66cc;">5</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 2</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_2"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"SELECT * from POST_DETAILS"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_2"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr.<span style="color: #006633;">think_time</span><span style="color: #009900;">(</span><span style="color: #cc66cc;">5</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 3</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_3"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"select * from users"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_3"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> lr.<span style="color: #006633;">think_time</span><span style="color: #009900;">(</span><span style="color: #cc66cc;">5</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /><span style="color: #009900;">}</span> <span style="color: #666666; font-style: italic;">//end of action</span></pre></div></div><h3 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.2em; font-weight: normal; margin: 20px 0px 0px; padding: 0px;">Verifying the Response</h3><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">In database performance testing, it is not commonplace to verify the SQL results other than to ensure that the query has been successfully executed by the server. The Java <em>executeQuery</em> function utilised by the <em>database_query</em>function will return an exception if the query is not successfully executed. The db_query function will return the first 10 records from a result set. To get the full SQL results parsed across the network, you will need to process them with the “getString” function of the resultset. In the case where keyword type checks would want to be performed on the SQL results, the same code to print the response could be used to check the results one by one with some form of validation.</div><h1 style="color: #3aa6d8; font-family: 'Century Gothic', 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 1.4em; font-weight: normal; margin: 0px; padding-top: 20px;">Example Script</h1><div style="clear: both; font-size: 1.2em; line-height: 1.3em;">Here is the full example script for you to try. Please feel free to submit corrections or improvements.</div><div class="wp_syntax" style="background-color: #f9f9f9; border: 1px solid silver; color: #110000; margin: 0px 0px 1.5em; overflow-x: auto; overflow-y: hidden; width: 560px;"><table style="border-collapse: collapse; border: 1px solid rgb(166, 180, 198); color: #7f8ea5; vertical-align: bottom;"><tbody><tr><td class="line_numbers" style="background-color: #ddeeff; border: 1px solid rgb(166, 180, 198); color: grey; overflow: visible; padding: 2px 4px; text-align: right; vertical-align: top;"><pre style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;">1<br />2<br />3<br />4<br />5<br />6<br />7<br />8<br />9<br />10<br />11<br />12<br />13<br />14<br />15<br />16<br />17<br />18<br />19<br />20<br />21<br />22<br />23<br />24<br />25<br />26<br />27<br />28<br />29<br />30<br />31<br />32<br />33<br />34<br />35<br />36<br />37<br />38<br />39<br />40<br />41<br />42<br />43<br />44<br />45<br />46<br />47<br />48<br />49<br />50<br />51<br />52<br />53<br />54<br />55<br />56<br />57<br />58<br />59<br />60<br />61<br />62<br />63<br />64<br />65<br />66<br />67<br />68<br />69<br />70<br />71<br />72<br />73<br />74<br />75<br />76<br />77<br />78<br />79<br />80<br />81<br />82<br />83<br />84<br />85<br />86<br />87<br />88<br />89<br />90<br />91<br />92<br />93<br />94<br /></pre></td><td class="code" style="border: 1px solid rgb(166, 180, 198); padding: 2px 4px; text-align: center; vertical-align: top;"><pre class="java" style="clear: none; float: none; font-size: 12px; line-height: 1.333; overflow: visible; text-align: left; width: auto;"><span style="color: #666666; font-style: italic;">/*<br /> * LoadRunner Java script.<br /> * Description: Oracle Database Testing via JDBC<br /> */</span><br /> <br /><span style="color: black; font-weight: bold;">import</span> <span style="color: #006699;">lrapi.lr</span><span style="color: #339933;">;</span><br /><span style="color: black; font-weight: bold;">import</span> <span style="color: #006699;">java.sql.Connection</span><span style="color: #339933;">;</span><br /><span style="color: black; font-weight: bold;">import</span> <span style="color: #006699;">java.sql.DriverManager</span><span style="color: #339933;">;</span><br /><span style="color: black; font-weight: bold;">import</span> <span style="color: #006699;">java.sql.SQLException</span><span style="color: #339933;">;</span><br /><span style="color: black; font-weight: bold;">import</span> <span style="color: #006699;">java.sql.*</span><span style="color: #339933;">;</span><br /> <br /><span style="color: black; font-weight: bold;">public</span> <span style="color: black; font-weight: bold;">class</span> Actions<br /><span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Create global connection variable</span><br /> <span style="color: black; font-weight: bold;">private</span> <span style="color: #003399;">Connection</span> connection<span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// VUser Init</span><br /> <span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> init<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: black; font-weight: bold;">throws</span> <span style="color: #003399;">ClassNotFoundException</span>, <span style="color: #003399;">SQLException</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Initialize DB connection</span><br /> <span style="color: #666666; font-style: italic;">//connection = null;</span><br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Load Oracle JDBC Driver</span><br /> <span style="color: black; font-weight: bold;">Class</span>.<span style="color: #006633;">forName</span><span style="color: #009900;">(</span><span style="color: blue;">"oracle.jdbc.driver.OracleDriver"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">Exception</span> ex<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// If driver load is unsuccessful</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Database Driver not found"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">abort</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// Specify the JDBC Connection String (jdbc:oracle:thin:@HOST:PORT:SID)</span><br /> <span style="color: #003399;">String</span> url <span style="color: #339933;">=</span> <span style="color: blue;">"jdbc:oracle:thin:@headwired:1521:SID"</span><span style="color: #339933;">;</span><br /> <span style="color: #666666; font-style: italic;">// Connect to URL using USERNAME and PASSWORD</span><br /> connection <span style="color: #339933;">=</span> <span style="color: #003399;">DriverManager</span>.<span style="color: #006633;">getConnection</span><span style="color: #009900;">(</span>url,<span style="color: blue;">"USER_NAME"</span>,lr.<span style="color: #006633;">decrypt</span><span style="color: #009900;">(</span><span style="color: blue;">"myencryptedpasswordgoeshere"</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"JDBC Connection Successful"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">SQLException</span> e<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// If Connection Failed</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Database Connection Failed, Please check your connection string"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">abort</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: #666666; font-style: italic;">//end of init</span><br /> <br /> <span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> action<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: black; font-weight: bold;">throws</span> <span style="color: #003399;">ClassNotFoundException</span>, <span style="color: #003399;">SQLException</span> <span style="color: #009900;">{</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 1</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_1"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"select BANNER from TABLE_1"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_1"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 2</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_2"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"SELECT * from TABLE_2"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_2"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Database Query Example 3</span><br /> lr.<span style="color: #006633;">start_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_3"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> database_query<span style="color: #009900;">(</span><span style="color: blue;">"select * from TABLE_3"</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">end_transaction</span><span style="color: #009900;">(</span><span style="color: blue;">"Database_Query_3"</span>, lr.<span style="color: #006633;">AUTO</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: #666666; font-style: italic;">//end of action</span><br /> <br /> <span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> end<span style="color: #009900;">(</span><span style="color: #009900;">)</span> <span style="color: black; font-weight: bold;">throws</span> <span style="color: #003399;">Throwable</span> <span style="color: #009900;">{</span><br /> connection <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: #666666; font-style: italic;">//end of end</span><br /> <br /> <span style="color: #666666; font-style: italic;">// Function: database_query</span><br /> <span style="color: #666666; font-style: italic;">// Argument: SQL Query String</span><br /> <span style="color: #666666; font-style: italic;">// Performs an SQL Query String, and returns pass or fail for the current transaction</span><br /> <span style="color: #666666; font-style: italic;">//</span><br /> <span style="color: black; font-weight: bold;">public</span> <span style="color: #000066; font-weight: bold;">int</span> database_query<span style="color: #009900;">(</span><span style="color: #003399;">String</span> SQL_QUERY<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #003399;">Statement</span> stmt <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <span style="color: #003399;">ResultSet</span> rset <span style="color: #339933;">=</span> <span style="color: #000066; font-weight: bold;">null</span><span style="color: #339933;">;</span><br /> <br /> <span style="color: black; font-weight: bold;">try</span> <span style="color: #009900;">{</span><br /> connection.<span style="color: #006633;">setAutoCommit</span><span style="color: #009900;">(</span><span style="color: #000066; font-weight: bold;">false</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> stmt <span style="color: #339933;">=</span> connection.<span style="color: #006633;">createStatement</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> rset <span style="color: #339933;">=</span> stmt.<span style="color: #006633;">executeQuery</span><span style="color: #009900;">(</span>SQL_QUERY<span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">set_transaction_status</span><span style="color: #009900;">(</span>lr.<span style="color: #006633;">PASS</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #666666; font-style: italic;">// while (rset.next()) { // Print the results of the query</span><br /> <span style="color: #666666; font-style: italic;">// lr.log_message(rset.getString(1)); // Note: This should be used for debugging only,</span><br /> <span style="color: #666666; font-style: italic;">// } // as it slows down execution time</span><br /> <span style="color: #666666; font-style: italic;">//lr.log_message("SQL Query Executed Successfully");</span><br /> rset.<span style="color: #006633;">close</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span> <span style="color: black; font-weight: bold;">catch</span> <span style="color: #009900;">(</span><span style="color: #003399;">SQLException</span> e<span style="color: #009900;">)</span> <span style="color: #009900;">{</span><br /> <span style="color: #666666; font-style: italic;">// SQL Query has failed</span><br /> lr.<span style="color: #006633;">log_message</span><span style="color: #009900;">(</span><span style="color: blue;">"Caught Exception: "</span> <span style="color: #339933;">+</span> e.<span style="color: #006633;">getMessage</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> lr.<span style="color: #006633;">set_transaction_status</span><span style="color: #009900;">(</span>lr.<span style="color: #006633;">FAIL</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">1</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /> <span style="color: black; font-weight: bold;">return</span> <span style="color: #cc66cc;">0</span><span style="color: #339933;">;</span><br /> <span style="color: #009900;">}</span><br /><span style="color: #009900;">}</span></pre></td></tr></tbody></table></div></div></div>

Performance Testing Oracle via JDBC with LoadRunner – Basics

This post discusses a method for testing Oracle via a JDBC connection, to simulate application interaction with the database. It is designed...

Read more »