You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jmeter-dev@jakarta.apache.org by se...@apache.org on 2007/09/08 12:30:34 UTC
svn commit: r573812 -
/jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml
Author: sebb
Date: Sat Sep 8 03:30:24 2007
New Revision: 573812
URL: http://svn.apache.org/viewvc?rev=573812&view=rev
Log:
Update JDBC sampler documentation
Modified:
jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml
Modified: jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml
URL: http://svn.apache.org/viewvc/jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml?rev=573812&r1=573811&r2=573812&view=diff
==============================================================================
--- jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml (original)
+++ jakarta/jmeter/branches/rel-2-2/xdocs/usermanual/component_reference.xml Sat Sep 8 03:30:24 2007
@@ -261,17 +261,36 @@
<li>Callable Statement</li>
<li>Prepared Select Statement</li>
<li>Prepared Update Statement - use this for Inserts as well</li>
+ <li>Commit</li>
+ <li>Rollback</li>
+ <li>Autocommit(false)</li>
+ <li>Autocommit(true)</li>
<li>Edit - this should be a variable reference that evaluates to one of the above</li>
</ul>
</property>
- <property name="SQL Query" required="Yes">SQL query (for example, "select * from t_customers").</property>
- <property name="Parameter values" required="Yes, if a prepared statement has parameters">
+ <property name="SQL Query" required="Yes">
+ SQL query.
+ Do not enter a trailing semi-colon.
+ There is no need to use { and } to enclose Callable statements.
+ For example:
+ <ul>
+ <li>select * from t_customers where id=23</li>
+ <li>CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null,?, ?, null, null, null)
+ <ul>
+ <li>Parameter values: tablename,filename</li>
+ <li>Parameter types: VARCHAR,VARCHAR</li>
+ </ul>
+ </li>
+ The second example assumes you are using Apache Derby.
+ </ul>
+ </property>
+ <property name="Parameter values" required="Yes, if a prepared or callable statement has parameters">
Comma-separated list of parameter values. Use ]NULL[ to indicate a NULL parameter.
(If required, the null string can be changed by defining the property "jdbcsampler.nullmarker".)
<br></br>
There must be as many values as there are placeholders in the statement.
</property>
- <property name="Parameter types" required="Yes, if a prepared statement has parameters">
+ <property name="Parameter types" required="Yes, if a prepared or callable statement has parameters">
Comma-separated list of SQL parameter types (e.g. INTEGER, DATE, VARCHAR, DOUBLE).
<br></br>
There must be as many values as there are placeholders in the statement.
@@ -279,7 +298,6 @@
</properties>
<links>
- <link href="test_plan.html#assertions">Assertion</link>
<link href="build-db-test-plan.html">Building a Database Test Plan</link>
<complink name="JDBC Connection Configuration"/>
</links>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org