All Products
Search

This Product

    Performance Testing:Basic request information

    Document Center

    Performance Testing:Basic request information

    Last Updated:Nov 08, 2024

    The basic request information of a Java Database Connectivity (JDBC) API includes the database type, test URL, and SQL statements. This topic describes how to configure the basic request information of a JDBC API.

    Procedure

    1. Log on to the PTS console, choose Performance Test > Create Scenario, and then click PTS.

    2. Delete the default HTTP API and add a JDBC API.

    3. Configure the basic request Information of the JDBC API. For more information, see Basic request information.image

      Parameters

      Parameter

      Description

      Example

      API Name

      The name that specifies the service definition of the API. The name can be up to 20 characters in length.

      API-1

      Database Type

      The database type. Valid values: MySQL, PostgreSQL, MariaDB, and SQL Server.

      MySQL

      Database URL

      The information of the database connection, including the host, port, and database name.

      <host>:<port>/<database_name>

      Username

      The username that is used to log on to databases.

      username

      Password

      The password that is used to log on to databases.

      password

      SQL

      The SQL statement that you want to execute. The SQL statement must start with SELECT, UPDATE, INSERT, or DELETE (case-insensitive).

      select * from test_users;

      Timeout Duration

      The maximum amount of time for which PTS waits for a response from the tested server.

      Unit: milliseconds.

      5000

      limit

      The maximum number of rows read from the result set (only for SQL statements that start with the word "SELECT"). A maximum of 1,000,000 rows can be read from the result set.

      1000