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]