This topic explains how to modify database settings.
About this task
Only an IBM® Rational® Test Control Panel administrator
can set up and modify IBM Rational Test Virtualization Server project
results databases.
To modify Rational Test Virtualization
Server project
results database settings:
- Log into Rational Test Control Panel.
- Click the Administration navigation
link.
Alternatively, click the Administration icon
on the Home page.
The Administration page
is displayed.
- Click the Domains and environments tab.
The Domains and environments tab
is displayed.
- In the list of domains on the left side
of the Domains and environments tab, click
the domain that you want to modify.
- Click Details (if
necessary) to display the Details page.
- On the Details page,
select the Override results database connection details check
box.
The
fields under the Description field become available for editing.
- 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 |
Microsoft SQL Server |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
MySQL |
com.mysql.jdbc.Driver Note: If
you want to use MySQL with Rational Test Control Panel,
you will need to install a MySQL driver.
|
Oracle |
oracle.jdbc.driver.OracleDriver (thin) |
- 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 |
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>> |
- 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.
- In the Password field, enter the
new password that is to be used for connecting to the results database
that is to be used.
- Click Save.
The new domain’s 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 mitigate this,
you can use different domains for each environment, or you can 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 Rational Test Control Panel.
However, this change will affect only stubs that are started after
the change has been made.