Author: sebb
Date: Wed Jan 28 21:52:16 2009
New Revision: 738637
URL: http://svn.apache.org/viewvc?rev=738637&view=rev
Log:
Explain JDBC errors better
Modified:
jakarta/jmeter/trunk/xdocs/usermanual/component_reference.xml
Modified: jakarta/jmeter/trunk/xdocs/usermanual/component_reference.xml
URL:
http://svn.apache.org/viewvc/jakarta/jmeter/trunk/xdocs/usermanual/component_reference.xml?rev=738637&r1=738636&r2=738637&view=diff
==============================================================================
--- jakarta/jmeter/trunk/xdocs/usermanual/component_reference.xml (original)
+++ jakarta/jmeter/trunk/xdocs/usermanual/component_reference.xml Wed Jan 28
21:52:16 2009
@@ -2792,11 +2792,20 @@
The Database URL and JDBC Driver class are defined by the provider of the JDBC
implementation.</p>
<p>Some possible settings are shown below. Please check the exact details in
the JDBC driver documentation.</p>
+<p>
+If JMeter reports <b>No suitable driver</b>, then this could mean either:
+<ul>
+<li>The driver class was not found. In this case, there will be a log message
such as <tt>DataSourceElement: Could not load driver: {classname}
java.lang.ClassNotFoundException: {classname}</tt></li>
+<li>The driver class was found, but the class does not support the connection
string. This could be because of a syntax error in the connection string, or
because the the wrong classname was used.</li>
+</ul>
+If the database server is not running or is not accessible, then JMeter will
report a <b>java.net.ConnectException</b>.
+</p>
<table>
<tr><th>Database</th><th>Driver class</th><th>Database URL</th></tr>
<tr><td>MySQL</td><td>com.mysql.jdbc.Driver</td><td>jdbc:mysql://host[:port]/dbname</td></tr>
<tr><td>PostgreSQL</td><td>org.postgresql.Driver</td><td>jdbc:postgresql:{dbname}</td></tr>
-<tr><td>Oracle</td><td>oracle.jdbc.driver.OracleDriver</td><td>jdbc:oracle:thin:user/pass@//host:port/service</td></tr>
+<tr><td>Oracle</td><td>oracle.jdbc.driver.OracleDriver</td><td>jdbc:oracle:thin:@//host:port/service
+OR<br/>jdbc:oracle:thin:@(description=(address=(host={mc-name})(protocol=tcp)(port={port-no}))(connect_data=(sid={sid})))</td></tr>
<tr><td>Ingres
(2006)</td><td>ingres.jdbc.IngresDriver</td><td>jdbc:ingres://host:port/db[;attr=value]</td></tr>
<tr><td>SQL Server (MS JDBC
driver)</td><td>com.microsoft.sqlserver.jdbc.SQLServerDriver</td><td>jdbc:sqlserver://host:port;DatabaseName=dbname</td></tr>
<tr><td>Apache
Derby</td><td>org.apache.derby.jdbc.ClientDriver</td><td>jdbc:derby://server[:port]/databaseName[;URLAttributes=value[;...]]</td></tr>
@@ -3029,15 +3038,26 @@
</description>
<properties>
- <property name="Name" required="">Descriptive name for this element
that is shown in the tree.</property>
+ <property name="Name" required="No">Descriptive name for this element
that is shown in the tree.</property>
+ <property name="Which samples to test" required="Yes">
+ This is for use with samplers that can generate sub-samples,
+ e.g. HTTP Sampler with embedded resources, Mail Reader or samples
generated by the Transaction Controller.
+ <ul>
+ <li>Main sample only - assertion only applies to the main sample</li>
+ <li>Sub-samples only - assertion only applies to the sub-samples</li>
+ <li>Main sample and sub-samples - assertion applies to both.</li>
+ </ul>
+ </property>
<property name="Response Field to Test" required="Yes">Instructs
JMeter which field of the Response to test.
<ul>
<li>Text Response - the response text from the server, i.e. the body,
excluing any HTTP headers.</li>
<li>URL sampled</li>
<li>Response Code - e.g. 200</li>
<li>Response Message - e.g. OK</li>
- <li>Response Headers (JMeter version 2.3RC3 and earlier included the
headers with the Text)</li>
+ <li>Response Headers, including Set-Cookie headers (if any)</li>
</ul>
+ </property>
+ <property name="Ignore status" required="Yes">Instructs JMeter to set
the status to success initially.
<p>
The overall success of the sample is determined by combining
the result of the
assertion with the existing Response status.
@@ -3049,7 +3069,7 @@
The "Ignore status" checkbox can be used to set the status
successful before performing further checks.
Note that this will have the effect of clearing any previous
assertion failures,
so make sure that this is only set on the first assertion.
- </property>
+ </property>
<property name="Pattern Matching Rules" required="Yes">Indicates how
the text being tested
is checked against the pattern.
<ul>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
