jmeter-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pmoua...@apache.org
Subject svn commit: r1210001 - in /jmeter/trunk/xdocs: images/screenshots/jdbc-post-processor.png images/screenshots/jdbc-pre-processor.png usermanual/JDBC-Pre-Post-Processor.jmx usermanual/component_reference.xml
Date Sat, 03 Dec 2011 20:53:33 GMT
Author: pmouawad
Date: Sat Dec  3 20:53:32 2011
New Revision: 1210001

URL: http://svn.apache.org/viewvc?rev=1210001&view=rev
Log:
Bug 52128 - Add JDBC pre- and post-processor

Added:
    jmeter/trunk/xdocs/images/screenshots/jdbc-post-processor.png   (with props)
    jmeter/trunk/xdocs/images/screenshots/jdbc-pre-processor.png   (with props)
    jmeter/trunk/xdocs/usermanual/JDBC-Pre-Post-Processor.jmx
Modified:
    jmeter/trunk/xdocs/usermanual/component_reference.xml

Added: jmeter/trunk/xdocs/images/screenshots/jdbc-post-processor.png
URL: http://svn.apache.org/viewvc/jmeter/trunk/xdocs/images/screenshots/jdbc-post-processor.png?rev=1210001&view=auto
==============================================================================
Binary file - no diff available.

Propchange: jmeter/trunk/xdocs/images/screenshots/jdbc-post-processor.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: jmeter/trunk/xdocs/images/screenshots/jdbc-pre-processor.png
URL: http://svn.apache.org/viewvc/jmeter/trunk/xdocs/images/screenshots/jdbc-pre-processor.png?rev=1210001&view=auto
==============================================================================
Binary file - no diff available.

Propchange: jmeter/trunk/xdocs/images/screenshots/jdbc-pre-processor.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: jmeter/trunk/xdocs/usermanual/JDBC-Pre-Post-Processor.jmx
URL: http://svn.apache.org/viewvc/jmeter/trunk/xdocs/usermanual/JDBC-Pre-Post-Processor.jmx?rev=1210001&view=auto
==============================================================================
--- jmeter/trunk/xdocs/usermanual/JDBC-Pre-Post-Processor.jmx (added)
+++ jmeter/trunk/xdocs/usermanual/JDBC-Pre-Post-Processor.jmx Sat Dec  3 20:53:32 2011
@@ -0,0 +1,445 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<jmeterTestPlan version="1.2" properties="2.1">
+  <hashTree>
+    <TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Concurrent Valuation
Test Plan" enabled="true">
+      <stringProp name="TestPlan.comments">Execute a series of concurrent valuations</stringProp>
+      <boolProp name="TestPlan.functional_mode">false</boolProp>
+      <boolProp name="TestPlan.serialize_threadgroups">true</boolProp>
+      <elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel"
testclass="Arguments" testname="User Defined Variables" enabled="true">
+        <collectionProp name="Arguments.arguments">
+          <elementProp name="CalculateFees" elementType="Argument">
+            <stringProp name="Argument.name">CalculateFees</stringProp>
+            <stringProp name="Argument.value">1</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="CalculatePerformanceDetails" elementType="Argument">
+            <stringProp name="Argument.name">CalculatePerformanceDetails</stringProp>
+            <stringProp name="Argument.value">1</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="DriverURL" elementType="Argument">
+            <stringProp name="Argument.name">DriverURL</stringProp>
+            <stringProp name="Argument.value">jdbc:jtds:sqlserver:</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="DatabasePort" elementType="Argument">
+            <stringProp name="Argument.name">DatabasePort</stringProp>
+            <stringProp name="Argument.value">1433</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="UseMiddleTierValuationEngine" elementType="Argument">
+            <stringProp name="Argument.name">UseMiddleTierValuationEngine</stringProp>
+            <stringProp name="Argument.value">0</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="MiddleTierRequestTimeout" elementType="Argument">
+            <stringProp name="Argument.name">MiddleTierRequestTimeout</stringProp>
+            <stringProp name="Argument.value">500000</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="PricePropagationMode" elementType="Argument">
+            <stringProp name="Argument.name">PricePropagationMode</stringProp>
+            <stringProp name="Argument.value">2</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+        </collectionProp>
+      </elementProp>
+      <stringProp name="TestPlan.user_define_classpath"></stringProp>
+    </TestPlan>
+    <hashTree>
+      <Arguments guiclass="ArgumentsPanel" testclass="Arguments" testname="MI PCO config"
enabled="true">
+        <collectionProp name="Arguments.arguments">
+          <elementProp name="PCOQuality" elementType="Argument">
+            <stringProp name="Argument.name">PCOQuality</stringProp>
+            <stringProp name="Argument.value">5</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="ValueDate" elementType="Argument">
+            <stringProp name="Argument.name">ValueDate</stringProp>
+            <stringProp name="Argument.value">2011-07-21</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="ReportingDate" elementType="Argument">
+            <stringProp name="Argument.name">ReportingDate</stringProp>
+            <stringProp name="Argument.value">2011-07-21 12:30:08.337</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+        </collectionProp>
+      </Arguments>
+      <hashTree/>
+      <Arguments guiclass="ArgumentsPanel" testclass="Arguments" testname="MI 440 SSD
GAIA Config" enabled="true">
+        <collectionProp name="Arguments.arguments">
+          <elementProp name="Database" elementType="Argument">
+            <stringProp name="Argument.name">Database</stringProp>
+            <stringProp name="Argument.value">HSPAD_MI_440_SSD</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="DatabaseHost" elementType="Argument">
+            <stringProp name="Argument.name">DatabaseHost</stringProp>
+            <stringProp name="Argument.value">GAIA</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="DatabaseUser" elementType="Argument">
+            <stringProp name="Argument.name">DatabaseUser</stringProp>
+            <stringProp name="Argument.value">sa</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="DatabasePassword" elementType="Argument">
+            <stringProp name="Argument.name">DatabasePassword</stringProp>
+            <stringProp name="Argument.value">sa2008</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+        </collectionProp>
+      </Arguments>
+      <hashTree/>
+      <Arguments guiclass="ArgumentsPanel" testclass="Arguments" testname="MI PCO Pfo
List" enabled="true">
+        <collectionProp name="Arguments.arguments">
+          <elementProp name="Pfo_1" elementType="Argument">
+            <stringProp name="Argument.name">Pfo_1</stringProp>
+            <stringProp name="Argument.value">1548</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="Pfo_2" elementType="Argument">
+            <stringProp name="Argument.name">Pfo_2</stringProp>
+            <stringProp name="Argument.value">1611</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+          <elementProp name="Pfo_3" elementType="Argument">
+            <stringProp name="Argument.name">Pfo_3</stringProp>
+            <stringProp name="Argument.value">1613</stringProp>
+            <stringProp name="Argument.metadata">=</stringProp>
+          </elementProp>
+        </collectionProp>
+        <stringProp name="TestPlan.comments">CutOff Nr 11249,  2011-07-2 / 2011-07-21
12:30:08.337 / DailyNAV Estimate / Within Price Cut-Off</stringProp>
+      </Arguments>
+      <hashTree/>
+      <JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="JDBC
Connection Configuration" enabled="true">
+        <boolProp name="autocommit">false</boolProp>
+        <stringProp name="checkQuery"></stringProp>
+        <stringProp name="connectionAge">5000</stringProp>
+        <stringProp name="dataSource"></stringProp>
+        <stringProp name="dbUrl">${DriverURL}//${DatabaseHost}:${DatabasePort}/${Database}</stringProp>
+        <stringProp name="driver">net.sourceforge.jtds.jdbc.Driver</stringProp>
+        <boolProp name="keepAlive">true</boolProp>
+        <stringProp name="password">${DatabasePassword}</stringProp>
+        <stringProp name="poolMax">25</stringProp>
+        <stringProp name="timeout">10000</stringProp>
+        <stringProp name="trimInterval">60000</stringProp>
+        <stringProp name="username">${DatabaseUser}</stringProp>
+        <stringProp name="transactionIsolation">4096</stringProp>
+        <stringProp name="TestPlan.comments">Connect to local HSPAD_Demo_CO and set
its isolation mode to SNAPSHOT (4096) and disable auto commit.</stringProp>
+      </JDBCDataSource>
+      <hashTree/>
+      <ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="3 Users"
enabled="true">
+        <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
+        <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel"
testclass="LoopController" testname="Loop Controller" enabled="true">
+          <boolProp name="LoopController.continue_forever">false</boolProp>
+          <stringProp name="LoopController.loops">3</stringProp>
+        </elementProp>
+        <stringProp name="ThreadGroup.num_threads">3</stringProp>
+        <stringProp name="ThreadGroup.ramp_time">0</stringProp>
+        <longProp name="ThreadGroup.start_time">1316530469000</longProp>
+        <longProp name="ThreadGroup.end_time">1316530469000</longProp>
+        <boolProp name="ThreadGroup.scheduler">false</boolProp>
+        <stringProp name="ThreadGroup.duration"></stringProp>
+        <stringProp name="ThreadGroup.delay"></stringProp>
+      </ThreadGroup>
+      <hashTree>
+        <ModuleController guiclass="ModuleControllerGui" testclass="ModuleController"
testname="PCO Valuation" enabled="true">
+          <collectionProp name="ModuleController.node_path">
+            <stringProp name="-1227702913">WorkBench</stringProp>
+            <stringProp name="1465685679">Concurrent Valuation Test Plan</stringProp>
+            <stringProp name="1372988285">PCO Valuation</stringProp>
+          </collectionProp>
+        </ModuleController>
+        <hashTree/>
+      </hashTree>
+      <SetupThreadGroup guiclass="SetupThreadGroupGui" testclass="SetupThreadGroup" testname="setUp
Thread Group" enabled="true">
+        <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
+        <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel"
testclass="LoopController" testname="Loop Controller" enabled="true">
+          <boolProp name="LoopController.continue_forever">false</boolProp>
+          <stringProp name="LoopController.loops">1</stringProp>
+        </elementProp>
+        <stringProp name="ThreadGroup.num_threads">1</stringProp>
+        <stringProp name="ThreadGroup.ramp_time">1</stringProp>
+        <longProp name="ThreadGroup.start_time">1320821253000</longProp>
+        <longProp name="ThreadGroup.end_time">1320821253000</longProp>
+        <boolProp name="ThreadGroup.scheduler">false</boolProp>
+        <stringProp name="ThreadGroup.duration"></stringProp>
+        <stringProp name="ThreadGroup.delay"></stringProp>
+      </SetupThreadGroup>
+      <hashTree>
+        <TestAction guiclass="TestActionGui" testclass="TestAction" testname="Setup Middle
Tier usage" enabled="true">
+          <intProp name="ActionProcessor.action">1</intProp>
+          <intProp name="ActionProcessor.target">0</intProp>
+          <stringProp name="ActionProcessor.duration"></stringProp>
+        </TestAction>
+        <hashTree>
+          <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Set
UseMiddleTierValuationEngine and Timeout" enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="query">UPDATE T_SettingGlobal SET UseMiddleTierValuationEngine=?,
MiddleTierRequestTimeout=?</stringProp>
+            <stringProp name="queryArguments">${UseMiddleTierValuationEngine}, ${MiddleTierRequestTimeout}</stringProp>
+            <stringProp name="queryArgumentsTypes">BIT, INTEGER</stringProp>
+            <stringProp name="queryType">Prepared Update Statement</stringProp>
+            <stringProp name="resultVariable"></stringProp>
+            <stringProp name="variableNames"></stringProp>
+          </JDBCPreProcessor>
+          <hashTree/>
+          <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Commit"
enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="queryType">Commit</stringProp>
+            <stringProp name="query"></stringProp>
+            <stringProp name="queryArguments"></stringProp>
+            <stringProp name="queryArgumentsTypes"></stringProp>
+            <stringProp name="variableNames"></stringProp>
+            <stringProp name="resultVariable"></stringProp>
+          </JDBCPreProcessor>
+          <hashTree/>
+        </hashTree>
+        <TestAction guiclass="TestActionGui" testclass="TestAction" testname="Clear caches"
enabled="true">
+          <intProp name="ActionProcessor.action">1</intProp>
+          <intProp name="ActionProcessor.target">0</intProp>
+          <stringProp name="ActionProcessor.duration">0</stringProp>
+        </TestAction>
+        <hashTree>
+          <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Clear
Buffers" enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="queryType">Update Statement</stringProp>
+            <stringProp name="query">DBCC DROPCLEANBUFFERS</stringProp>
+            <stringProp name="queryArguments"></stringProp>
+            <stringProp name="queryArgumentsTypes"></stringProp>
+            <stringProp name="variableNames"></stringProp>
+            <stringProp name="resultVariable"></stringProp>
+          </JDBCPreProcessor>
+          <hashTree/>
+          <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Clear
Proc Cache" enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="queryType">Update Statement</stringProp>
+            <stringProp name="query">DBCC FREEPROCCACHE</stringProp>
+            <stringProp name="queryArguments"></stringProp>
+            <stringProp name="queryArgumentsTypes"></stringProp>
+            <stringProp name="variableNames"></stringProp>
+            <stringProp name="resultVariable"></stringProp>
+          </JDBCPreProcessor>
+          <hashTree/>
+        </hashTree>
+      </hashTree>
+      <TestFragmentController guiclass="TestFragmentControllerGui" testclass="TestFragmentController"
testname="PCO Valuation" enabled="true"/>
+      <hashTree>
+        <TransactionController guiclass="TransactionControllerGui" testclass="TransactionController"
testname="Calculate PCO Transaction" enabled="true">
+          <boolProp name="TransactionController.parent">true</boolProp>
+        </TransactionController>
+        <hashTree>
+          <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="Begin
Tran" enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="queryType">Update Statement</stringProp>
+            <stringProp name="query">BEGIN TRAN COMMIT TRAN</stringProp>
+            <stringProp name="queryArguments"></stringProp>
+            <stringProp name="queryArgumentsTypes"></stringProp>
+            <stringProp name="variableNames"></stringProp>
+            <stringProp name="resultVariable"></stringProp>
+            <boolProp name="collectDiagnostics">false</boolProp>
+          </JDBCSampler>
+          <hashTree/>
+          <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="Calculate
Price cut off" enabled="true">
+            <stringProp name="dataSource"></stringProp>
+            <stringProp name="queryType">Callable Statement</stringProp>
+            <stringProp name="query">PfoVal_Recalculate ?, ?, 1</stringProp>
+            <stringProp name="queryArguments">${Pfo_1}, ${PfoValInstance}</stringProp>
+            <stringProp name="queryArgumentsTypes">INTEGER, INTEGER</stringProp>
+            <stringProp name="variableNames"></stringProp>
+            <stringProp name="resultVariable"></stringProp>
+            <boolProp name="collectDiagnostics">true</boolProp>
+          </JDBCSampler>
+          <hashTree>
+            <BSFPreProcessor guiclass="TestBeanGUI" testclass="BSFPreProcessor" testname="Prepare
Portfolio List for Price Cut-Off" enabled="true">
+              <stringProp name="scriptLanguage">groovy</stringProp>
+              <stringProp name="parameters"></stringProp>
+              <stringProp name="filename"></stringProp>
+              <stringProp name="script">import groovy.sql.Sql
+import org.apache.jmeter.protocol.jdbc.config.DataSourceElement
+try {
+	// build Pfo List
+	println(&quot;Building Portfolio List&quot;)
+	def pfoList = &quot;&lt;PfoList&gt;&quot;
+	def pfoNr = 1
+	def pfo = vars.get(&quot;Pfo_&quot; + pfoNr)
+	while(pfo != null) {
+		println(&quot;Pfo: $pfo&quot;);
+		pfoList = pfoList + &quot;&lt;Pfo ID=&apos;$pfo&apos; EmptyValuation=&apos;true&apos;
PropagatePrice=&apos;true&apos;/&gt;&quot;
+		pfoNr++
+		pfo = vars.get(&quot;Pfo_&quot; + pfoNr)
+	}
+	pfoList = pfoList + &quot;&lt;/PfoList&gt;&quot;
+	vars.put(&quot;PfoListXML&quot;, pfoList)
+} catch (Exception e) {
+  	println(e.toString());
+}</stringProp>
+            </BSFPreProcessor>
+            <hashTree/>
+            <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Create
Price Cut-Off" enabled="true">
+              <stringProp name="dataSource"></stringProp>
+              <stringProp name="query">CreatePriceCutOff ?, ?, ?, ?, ?, ?, ?, ?</stringProp>
+              <stringProp name="queryArguments">${__threadNum},${ValueDate},${PCOQuality},${ReportingDate},]NULL[,${PCO},${PfoListXML},${PricePropagationMode}</stringProp>
+              <stringProp name="queryArgumentsTypes">VARCHAR, DATE, INTEGER,TIMESTAMP,INTEGER,OUT
INTEGER,CLOB,INTEGER</stringProp>
+              <stringProp name="queryType">Callable Statement</stringProp>
+              <stringProp name="resultVariable"></stringProp>
+              <stringProp name="variableNames"></stringProp>
+            </JDBCPreProcessor>
+            <hashTree/>
+            <JDBCPreProcessor guiclass="TestBeanGUI" testclass="JDBCPreProcessor" testname="Get
Portfolio Valuation Instance from Price Cut-Off" enabled="true">
+              <stringProp name="dataSource"></stringProp>
+              <stringProp name="queryType">Prepared Select Statement</stringProp>
+              <stringProp name="query">select Nr from PfoValInstance where Pfo=? AND
PriceCutOff=?</stringProp>
+              <stringProp name="queryArguments">${Pfo_1},${PCO}</stringProp>
+              <stringProp name="queryArgumentsTypes">INTEGER,INTEGER</stringProp>
+              <stringProp name="variableNames">PfoValInstance</stringProp>
+              <stringProp name="resultVariable"></stringProp>
+            </JDBCPreProcessor>
+            <hashTree/>
+            <JDBCPostProcessor guiclass="TestBeanGUI" testclass="JDBCPostProcessor" testname="JDBC
PostProcessor" enabled="true">
+              <stringProp name="dataSource"></stringProp>
+              <stringProp name="query">DeletePriceCutOff ?</stringProp>
+              <stringProp name="queryArguments">${PCO}</stringProp>
+              <stringProp name="queryArgumentsTypes">INTEGER</stringProp>
+              <stringProp name="queryType">Callable Statement</stringProp>
+              <stringProp name="resultVariable"></stringProp>
+              <stringProp name="variableNames"></stringProp>
+            </JDBCPostProcessor>
+            <hashTree/>
+          </hashTree>
+          <IfController guiclass="IfControllerPanel" testclass="IfController" testname="If
Controller" enabled="true">
+            <stringProp name="IfController.condition">${JMeterThread.last_sample_ok}</stringProp>
+            <boolProp name="IfController.evaluateAll">false</boolProp>
+          </IfController>
+          <hashTree>
+            <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="Commit"
enabled="true">
+              <stringProp name="dataSource"></stringProp>
+              <stringProp name="queryType">Commit</stringProp>
+              <stringProp name="query"></stringProp>
+              <stringProp name="queryArguments"></stringProp>
+              <stringProp name="queryArgumentsTypes"></stringProp>
+              <stringProp name="variableNames"></stringProp>
+              <stringProp name="resultVariable"></stringProp>
+              <stringProp name="TestPlan.comments">Commit the transaction of the valuation</stringProp>
+              <boolProp name="collectDiagnostics">false</boolProp>
+            </JDBCSampler>
+            <hashTree/>
+          </hashTree>
+          <IfController guiclass="IfControllerPanel" testclass="IfController" testname="If
Controller" enabled="true">
+            <stringProp name="IfController.condition">${JMeterThread.last_sample_ok}==false</stringProp>
+            <boolProp name="IfController.evaluateAll">false</boolProp>
+          </IfController>
+          <hashTree>
+            <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="Rollback"
enabled="true">
+              <stringProp name="dataSource"></stringProp>
+              <stringProp name="queryType">Rollback</stringProp>
+              <stringProp name="query"></stringProp>
+              <stringProp name="queryArguments"></stringProp>
+              <stringProp name="queryArgumentsTypes"></stringProp>
+              <stringProp name="variableNames"></stringProp>
+              <stringProp name="resultVariable"></stringProp>
+              <boolProp name="collectDiagnostics">false</boolProp>
+            </JDBCSampler>
+            <hashTree/>
+          </hashTree>
+        </hashTree>
+      </hashTree>
+      <ResultCollector guiclass="SummaryReport" testclass="ResultCollector" testname="Summary
Report" enabled="true">
+        <boolProp name="ResultCollector.error_logging">false</boolProp>
+        <objProp>
+          <name>saveConfig</name>
+          <value class="SampleSaveConfiguration">
+            <time>true</time>
+            <latency>false</latency>
+            <timestamp>true</timestamp>
+            <success>false</success>
+            <label>true</label>
+            <code>false</code>
+            <message>false</message>
+            <threadName>true</threadName>
+            <dataType>false</dataType>
+            <encoding>false</encoding>
+            <assertions>false</assertions>
+            <subresults>false</subresults>
+            <responseData>false</responseData>
+            <samplerData>false</samplerData>
+            <xml>true</xml>
+            <fieldNames>false</fieldNames>
+            <responseHeaders>false</responseHeaders>
+            <requestHeaders>false</requestHeaders>
+            <responseDataOnError>false</responseDataOnError>
+            <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
+            <assertionsResultsToSave>0</assertionsResultsToSave>
+          </value>
+        </objProp>
+        <stringProp name="filename"></stringProp>
+      </ResultCollector>
+      <hashTree/>
+      <ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector"
testname="View Results Tree" enabled="true">
+        <boolProp name="ResultCollector.error_logging">false</boolProp>
+        <objProp>
+          <name>saveConfig</name>
+          <value class="SampleSaveConfiguration">
+            <time>true</time>
+            <latency>true</latency>
+            <timestamp>true</timestamp>
+            <success>true</success>
+            <label>true</label>
+            <code>true</code>
+            <message>true</message>
+            <threadName>true</threadName>
+            <dataType>true</dataType>
+            <encoding>false</encoding>
+            <assertions>true</assertions>
+            <subresults>true</subresults>
+            <responseData>false</responseData>
+            <samplerData>false</samplerData>
+            <xml>true</xml>
+            <fieldNames>false</fieldNames>
+            <responseHeaders>false</responseHeaders>
+            <requestHeaders>false</requestHeaders>
+            <responseDataOnError>false</responseDataOnError>
+            <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
+            <assertionsResultsToSave>0</assertionsResultsToSave>
+            <bytes>true</bytes>
+          </value>
+        </objProp>
+        <stringProp name="filename"></stringProp>
+      </ResultCollector>
+      <hashTree/>
+      <ResultCollector guiclass="TableVisualizer" testclass="ResultCollector" testname="View
Results in Table" enabled="true">
+        <boolProp name="ResultCollector.error_logging">false</boolProp>
+        <objProp>
+          <name>saveConfig</name>
+          <value class="SampleSaveConfiguration">
+            <time>true</time>
+            <latency>true</latency>
+            <timestamp>true</timestamp>
+            <success>true</success>
+            <label>true</label>
+            <code>true</code>
+            <message>true</message>
+            <threadName>true</threadName>
+            <dataType>true</dataType>
+            <encoding>false</encoding>
+            <assertions>true</assertions>
+            <subresults>true</subresults>
+            <responseData>false</responseData>
+            <samplerData>false</samplerData>
+            <xml>true</xml>
+            <fieldNames>false</fieldNames>
+            <responseHeaders>false</responseHeaders>
+            <requestHeaders>false</requestHeaders>
+            <responseDataOnError>false</responseDataOnError>
+            <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
+            <assertionsResultsToSave>0</assertionsResultsToSave>
+            <bytes>true</bytes>
+          </value>
+        </objProp>
+        <stringProp name="filename"></stringProp>
+      </ResultCollector>
+      <hashTree/>
+    </hashTree>
+  </hashTree>
+</jmeterTestPlan>

Modified: jmeter/trunk/xdocs/usermanual/component_reference.xml
URL: http://svn.apache.org/viewvc/jmeter/trunk/xdocs/usermanual/component_reference.xml?rev=1210001&r1=1210000&r2=1210001&view=diff
==============================================================================
--- jmeter/trunk/xdocs/usermanual/component_reference.xml (original)
+++ jmeter/trunk/xdocs/usermanual/component_reference.xml Sat Dec  3 20:53:32 2011
@@ -4455,9 +4455,21 @@ For details, see <complink name="BSF Pre
 <description>
 <p>
 The JDBC PreProcessor enables you to run some SQL statement just before a sample runs.
-This can be useful if your JDBC Sample changes some data and you want to reset state to what
it was before the JDBC sample run.
+This can be useful if your JDBC Sample requires some data to be in DataBase and you cannot
compute this in a setup Thread group.
+</p>
+<p>
+See the following Test plan:
 </p>
+<links>
+        <link href="JDBC-Pre-Post-Processor.jmx">Test Plan using JDBC Pre/Post Processor</link>
+</links>
+<p>
+In the linked test plan,"Create Price Cut-Off" JDBC PreProcessor calls a stored procedure
to create a Price Cut-Off in Database,
+this one will be used by "Calculate Price cut off".
+
+<figure width="1346" height="636" image="jdbc-pre-processor.png">Create Price Cut-Off
Preprocessor</figure>
 
+</p>
 </description>
 </component>
 
@@ -4791,13 +4803,17 @@ For details, see the <complink name="BSF
 <description>
 <p>
 The JDBC PostProcessor enables you to run some SQL statement just after a sample has run.
-This can be useful if your JDBC Sample requires some data to be in DataBase and you cannot
compute this in a setup Thread group.
+This can be useful if your JDBC Sample changes some data and you want to reset state to what
it was before the JDBC sample run.
 </p>
 </description>
 </component>
-
-<a href="#">^</a>
-
+<links>
+        <link href="JDBC-Pre-Post-Processor.jmx">Test Plan using JDBC Pre/Post Processor</link>
+</links>
+<p>
+In the linked test plan,"JDBC PostProcessor" JDBC PostProcessor calls a stored procedure
to delete the Price Cut-Off that was created by PreProcessor from Database.
+<figure width="1343" height="631" image="jdbc-post-processor.png">JDBC PostProcessor</figure>
+</p>
 </section>
 
 <section name="&sect-num;.9 Miscellaneous Features" anchor="Miscellaneous_Features">



Mime
View raw message