...
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\]unmigrated-wiki-markupWiki Markup - \[:UserManual/BuildDbTest:Building a Database Test Plan\]unmigrated-wiki-markup
- \[:../JdbcLoginDefaults:JDBC Database Login Defaults\]unmigrated-wiki-markup\[:../JdbcConnectionDefaults:
- JDBC Database Connection Pool Defaults\]unmigrated-wiki-markup
- \[:../JdbcQueryDefaults:JDBC SQL Query Defaults\]