You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jmeter.apache.org by fs...@apache.org on 2017/09/17 09:36:01 UTC
svn commit: r1808611 - /jmeter/trunk/xdocs/usermanual/component_reference.xml
Author: fschumacher
Date: Sun Sep 17 09:36:01 2017
New Revision: 1808611
URL: http://svn.apache.org/viewvc?rev=1808611&view=rev
Log:
Add markup
Modified:
jmeter/trunk/xdocs/usermanual/component_reference.xml
Modified: jmeter/trunk/xdocs/usermanual/component_reference.xml
URL: http://svn.apache.org/viewvc/jmeter/trunk/xdocs/usermanual/component_reference.xml?rev=1808611&r1=1808610&r2=1808611&view=diff
==============================================================================
--- jmeter/trunk/xdocs/usermanual/component_reference.xml (original)
+++ jmeter/trunk/xdocs/usermanual/component_reference.xml Sun Sep 17 09:36:01 2017
@@ -4030,16 +4030,16 @@ instead. (see figures 12 and 13).</p>
However some may require a different query; for example Oracle something like '<code>SELECT 1 FROM DUAL</code>' could be used.
<p>The list of the validation queries can be configured with <code>jdbc.config.check.query</code> property and are by default:</p>
<dl>
- <dt>hsqldb</dt><dd>select 1 from INFORMATION_SCHEMA.SYSTEM_USERS</dd>
- <dt>Oracle</dt><dd>select 1 from dual</dd>
- <dt>DB2</dt><dd>select 1 from sysibm.sysdummy1</dd>
- <dt>MySQL</dt><dd>select 1</dd>
- <dt>Microsoft SQL Server (MS JDBC driver)</dt><dd>select 1</dd>
- <dt>PostgreSQL</dt><dd>select 1</dd>
- <dt>Ingres</dt><dd>select 1</dd>
- <dt>Derby</dt><dd>values 1</dd>
- <dt>H2</dt><dd>select 1</dd>
- <dt>Firebird</dt><dd>select 1 from rdb$database</dd>
+ <dt>hsqldb</dt><dd><code>select 1 from INFORMATION_SCHEMA.SYSTEM_USERS</code></dd>
+ <dt>Oracle</dt><dd><code>select 1 from dual</code></dd>
+ <dt>DB2</dt><dd><code>select 1 from sysibm.sysdummy1</code></dd>
+ <dt>MySQL</dt><dd><code>select 1</code></dd>
+ <dt>Microsoft SQL Server (MS JDBC driver)</dt><dd><code>select 1</code></dd>
+ <dt>PostgreSQL</dt><dd><code>select 1</code></dd>
+ <dt>Ingres</dt><dd><code>select 1</code></dd>
+ <dt>Derby</dt><dd><code>values 1</code></dd>
+ <dt>H2</dt><dd><code>select 1</code></dd>
+ <dt>Firebird</dt><dd><code>select 1 from rdb$database</code></dd>
</dl>
<note>The list come from <a href="https://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases">stackoverflow entry on different database validation queries</a> and it can be incorrect</note>
<note>Note this validation query is used on pool creation to validate it even if "<code>Test While Idle</code>" suggests query would only be used on idle connections.