DUE TO SPAM, SIGN-UP IS DISABLED. Goto Selfserve wiki signup and request an account.
...
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 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\]