Adding Microsoft SQL Server and MySQL drivers

Microsoft SQL Server and MySQL drivers are not supplied with HCL DevOps Test Virtualization Control Panel (Test Virtualization Control Panel). If you want to use SQL Server or MySQL with Test Virtualization Control Panel, you must copy the SQL Server or MySQL drivers to the Test Virtualization Control Panel installation directory.

  1. Copy the drivers to the appropriate library location based on the product version that you are using.
    Note: Test Virtualization Control Panel requires Java17-based drivers. If the SQL server uses a custom certificate, you must include the additional argument trustServerCertificate=true along with the SQL server URL in the Database URL field when you configure the results database. For example, the database URL can be as follows:
    
    jdbc:sqlserver://mssql.db.server.com:1433;ritdb;trustServerCertificate=true
    Where, mssql.db.server.com is the host name of the database server and ritdb is the name of the database.
    • Version 9.1.0 and later: Copy to C:\Program Files\HCL\DevOpsTestControlPanel\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib
    • Version 8.5.1 to 9.1.0: Copy to C:\Program Files\HCL\DevOpsTestControlPanel\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib
    • Version 8.5.0 and earlier: Copy to C:\Program Files\HCL\DevOpsTestControlPanel\webapps\RTCP\WEB-INF\lib
  2. Restart Test Virtualization Control Panel.
.