Modifying database settings

Only an HCL® Quality Server administrator can set up and modify HCL OneTest™ Virtualization project results databases.

Procedure

  1. Log into HCL® Quality Server.
  2. Click the Administration navigation link.

    Alternatively, click the Administration icon on the Home page.

    The Administration page is displayed.

  3. Click the Domains and environments tab.
  4. In the list of domains on the left of the Domains and environments tab, click the domain that you want to modify.
  5. Click Details (if necessary) to display the Details page.
  6. On the Details page, select the Override results database connection details check box.

    The fields under the Description field become available for editing.

  7. In the Driver class field, enter the name of the JDBC driver that is to be used (if overriding the existing results database connection).

    The following table shows example driver class names.

    DBMS Driver Class Example
    IBM® Db2® com.ibm.db2.jcc.DB2Driver
    Microsoft™ SQL Server com.microsoft.sqlserver.jdbc.SQLServerDriver
    MySQL com.mysql.cj.jdbc.Driver
    Note: If you want to use MySQL with HCL® Quality Server, you must install the MySQL Connector/J JDBC driver.
    Oracle oracle.jdbc.driver.OracleDriver (thin)
  8. In the Database URL field, enter the URL of the database that is to be used (if overriding the existing results database connection).

    The following table shows example URL formats.

    DBMS Database URL Format
    IBM® Db2® jdbc:db2://Server Name\Instance Name:Port Number/Database_Name
    Microsoft™ SQL Server jdbc:sqlserver://Server Name\Instance Name:Port Number;Property=Value;Property=Value
    MySQL jdbc:mysql://Server Name\Instance Name:Port Number;Property=Value;Property=Value
    Oracle jdbc:oracle:thin:@//Server Name\Instance Name:Port Number;Property=Value;Property=Value
    For more information on the specification of database URLs when using IP literal addresses, see IP literal address.
  9. In the Username field, enter the new user name that is to be used for connecting to the results database that is to be used.
  10. In the Password field, enter the new password that is to be used for connecting to the results database that is to be used.
  11. Click Save.

    The new domains details are updated. These settings will be used for all stubs run in this domain, regardless of environment.

    Note: Any changes to project results database settings will affect only stubs that are started after the changes have been made.
    Note: Project results databases cannot be defined at environment level. To work around this limitation, you have two options:
    • Use different domains for each environment.
    • Define the project results database before publishing the stubs into each environment and ensure that you do not override the settings for the domain in HCL® Quality Server. However, this change will affect only stubs that are started after the change has been made