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:

  • No labels