Page History

To add multiple databases of the same type, specify a different location (for example, schema, SID, service name, or path) when creating a new database. This prevents the existing database from being overwritten. 

• HyperSQL: Enter a new file path.
• MySQL: Enter a new schema.
• Oracle: Enter a new SID or service name.

To port a database to a different database type, select the target database type, then specify the desired location for the new database.

To create a new database account from this interface, enter the desired username and password, enable Create a new user, then confirm the password. For new accounts on Oracle, you can also specify a data tablespace and temp tablespace or you can leave those fields empty to use the defaults (<USER>_DATA> and <USER_TEMP>).

Current Configuration

You can view the current database configuration in this section. 

Database Table Limits

Messages received by CTP's underlying Virtualize server are logged in the database. The event message, payload, hit statistics, and time information are stored. You can change limit the number of event messages and , entries about each hit to the server, and days of hit summary in this section..

Note that Virtualize hit statistics row is set to 100,000 by default. This affects the number of individual rows of statistics data at the bottom of the Service Virtualization Hit Statistics report. Increasing this limit beyond 1,000,000 is not recommended since performance decreases as the table size increases.

The Virtualize hit summary days limit prevents the database from growing out of control. The number of days of summary data also effects performance, but to a lesser degree than the number of Virtualize hit statistics rows.

Image Added Image Removed

Database Settings

See System Requirements for details about supported database versions and requirements.

HyperSQL Settings

CTP ships with an embedded HyperSQL database. To use it, choose File path as the connection mode.

• Connection mode: Choose whether to connect using File path or JDBC URL. The connection configuration field that appears depends on your selection.
  • File path: Specify the where the database files should be saved. The files should be saved on the Apache Tomcat host.  Prepend a forward slash ‘/’ to make the path absolute in the file system. 
  • JDBC URL:  Specify the JDBC URL used to connect to your database. Example JDBC URL:
    jdbc:hsqldb:file:/hsqldb/em;ifexists=true
• Username: Specify a user that will be able to access to the database. Default is the em user. If the Create a new user option is enabled, a new user with the name specified in this field will be added to the database.
• Password: Specify the password for the user that will be able to access the database. Default is the password for the em user. If the Create a new user option is enabled, a new user with the password specified in this field will be added to the database. 

MySQL and MariaDB Settings

• Connection mode: Choose whether to connect using Host and port or JDBC URL. The connection configuration fields that appear depends on your selection.
  • Host and port:
    • Host: Specify the host where the MySQL server is installed.
    • Port: Specify the port on the host through which the MySQL database is running.
    • Schema: Specify the name of the schema (database) that should contain the data. Default is em.
  • JDBC URL:
    • JDBC URL: Specify the JDBC URL used to connect to your database. Example JDBC URLs:
      jdbc:mariadb://hostname:3306?useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=NO_BACKSLASH_ESCAPES
jdbc:mysql://hostname:3306?useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=NO_BACKSLASH_ESCAPES&useSSL=false&allowPublicKeyRetrieval=true
• Username: Specify a user that will be able to access to the database. Default is the em user. If the Create a new user option is enabled, a new user with the name specified in this field will be added to the database.
• Password: Specify the password for the user that will be able to access the database. Default is the password for the em user. If the Create a new user option is enabled, a new user with the password specified in this field will be added to the database.

Oracle Settings

• Connection mode: Choose whether to connect using Host and port or JDBC URL. The connection configuration fields that appear depends on your selection.
  • Host and port:
    • Host: Specify the host where the Oracle server is installed.
    • Port: Specify the port on the host through which the Oracle database is running.
    • Use service name: Enable this option if you want to connect to the Oracle database using the service name. Specify the service name in the field provided. Enabling this option disables the SID field.
    • SID: Specify the SID of the Oracle database if you want to connect using the SID. Enabling the User service name option disables the SID field.
  • JDBC URL:
    • JDBC URL: Specify the JDBC URL used to connect to your database. Example JDBC URLs:
      jdbc:oracle:thin:@//hostname:1521/service_name
jdbc:oracle:thin:@//hostname:1521:sid
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name)))
• Username: Specify the name of the schema (database) that should contain the data. Default is em.
• Password: Specify the password for the user that will be able to access the database. Default is the password for the em user. If the Create a new user option is enabled, a new user with the password specified in this field will be added to the database.

Also see Installing and Running CTP.