Databases

In the web UI, go to Administration > System > Databases. In the native UI, select Options > Databases.

Use the Databases panel to configure one or more databases to be used either for VersaLex Transfer Logging or one of the optional Cleo VLNavigator applications. See Transfers and Applications. When you click New Database Connection, the Database Connection Configuration dialog appears. Enter values for the following fields:

Connection Type

Choose ODBC for databases where ODBC (Open DataBase Connectivity) is used. Choose MySQL Connector/J if a MySQL JDBC connection is used. Otherwise, select Other.

Possible values: ODBC, MySQL Connector/J, or Other

Default value: ODBC

Connection String

JDBC connection string for accessing the database.

Examples:

jdbc:odbc:vltdb

jdbc:mysql://myhost:3306/vltdb

Driver String

This string describes the path to the Java class that will be used for accessing the database.

Examples:

sun.jdbc.odbc.JdbcOdbcDriver

com.mysql.jdbc.Driver

Username

Username for accessing the database (if required).

Password

Password for accessing the database (if required).

Single Record Timeout (seconds)

Prevents VersaLex from hanging on single-records transactional (i.e., transfer log and operator trail log) inserts and updates.

Possible values: 0-n where n is a reasonable number.  0 indicates unlimited, but is not recommended as it could cause processing to hang in the event of database problems.

Default value:150

Test Database Connection

Attempts to create a database connection using the entered Connection String, Driver String, Username, and Password and indicates success or failure.

See Database Definitions for information about JDBC drivers and driver/connection string values.