[Apache JMeter Wiki] New: UserManual/Reference/JdbcSampler

[ja...@apache.org]

   Date: 2005-03-08T10:31:43
   Editor: MichaelStover
   Wiki: Apache JMeter Wiki
   Page: UserManual/Reference/JdbcSampler
   URL: http://wiki.apache.org/jakarta-jmeter/UserManual/Reference/JdbcSampler

   no comment

New Page:

= JDBC Request =

This sampler lets you send an JDBC Request (an SQL query) to a database.

If you are going to send multiple requests to the same database, consider using one or more of the Defaults Configuration Elements: JDBC Database Login Defaults , JDBC Database Connection Pool Defaults , JDBC SQL Query Defaults . This way, you do not have to enter the same information for each JDBC Request controller.

'''Control Panel'''
 http://jakarta.apache.org/jmeter/images/screenshots/gen-controller/jdbc-request.gif

'''Parameters'''
|| '''Attribute''' || '''Description''' || '''Required''' ||
|| '''Name''' || Descriptive name for this controller that is shown in the tree. || No ||
|| '''JDBC URL''' || URL of the database (for example, "jdbc:weblogic:oracle"). Refer to your database's JDBC documentation for the URL you should use. || Yes ||
|| '''Driver Class''' || The database driver Java class (for example, "weblogic.jdbc.oci.Driver"). Refer to your database's JDBC documentation for the name of the JDBC driver class you should use. || Yes ||
|| '''Username''' || FTP account username. || Usually (database dependent) ||
|| '''Password''' || FTP account password. || Usually (database dependent) ||
|| '''Number of Connections in Pool''' || Number of database connection instances to create and keep active. The maximum value depends on your database. Also, JMeter imposes a maximum of 100 connections. || Yes ||
|| '''Max Usage For Each Connection''' || Maximum number of times JMeter uses a database connection instance before recycling it (destroying and creating a new instance). || Yes ||
|| '''SQL Query String''' || SQL query (for example, "select * from t_customers"). || Yes ||

See Also:
 * [wiki:Self:UserManual/Elements#assertions Assertion]
 * [:UserManual/BuildDbTest:Building a Database Test Plan]
 * [:../JdbcLoginDefaults:JDBC Database Login Defaults]
 * [:../JdbcConnectionDefaults:JDBC Database Connection Pool Defaults]
 * [:../JdbcQueryDefaults:JDBC SQL Query Defaults]

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org