Test database connection to a project (for Oracle environments only)

Available in versions: 2021 R2 and later

Description

For Oracle environments only: Tests the connection to the database for a specific project.

URL

Copy code
/Admin/rest/v1/projects/verifyprojectdbconnection

Remarks

None

HTTP Method

POST: Tests a project's connection to the Oracle database server.

Request

Headers:

Content-Type: application/xml

Accept: application/json, application/xml

Cookies:

ADM_LWSSO={AdmLwssoCookie};

Request Body:

An XML describing the project and other optional details.

The fields in the request are:

ElementDescription
SchemaCredentialsDetails

  • ProjectId. The ID of the project for which the Oracle database connection should be tested (it can be retrieved from the Get Projects REST API). The Lab schema is considered as a particular project with ProjectId=1.

  • Password. The password to use to test the connection in plain text. If null, LoadRunner Enterprise tests the connection with the password currently in use by LoadRunner Enterprise. You can provide a Base64 encrypted value for the password if it is prefixed with “{a3f701a2-475d-4fe3-89f3-cc7db85a272c}:” (without the quotes), and then encrypted with the prefix.

Copy code
<SchemaCredentialsDetails> 
    <ProjectId>1038</ProjectId>
    <Password>MyCustomPassword</Password>
</SchemaCredentialsDetails>

Response

Headers:

None

Cookies:

None

HTML Return Code:

One of the HTTP Return Codes.

HTML Body:

Returns data on the database connection.

See Also

Get all Projects
Create a project
Get or update project by project ID
Get projects by Query
Remove Projects
Update database connection to a project (for Oracle environments only)