Database fields definition

This table shows the fields definition and default values for database setting and database communication channels.

Field Definition
Name Specify a descriptive name for this database.
DB URL

Specify the URL for the JDBC connection string.

If the database is configured with the default port number and not installed as a named instance, use this URL format:

  • For Microsoft, specify this value: jdbc:sqlserver://[host]:[port number]

If the database is installed as a named instance, use any of these format:

  • For Microsoft, specify this value:

    jdbc:sqlserver://[host]:[port number]\[instance name]

    jdbc:sqlserver://[host]\[instance name]

Note: For more information, consult Building the Connection URL documentation from Microsoft.
DB Name

Specify a database name.
Schema

Specify a schema to use.

Default value is dbo.
User Specify a case sensitive database user name to access the database.
Password Specify a case sensitive database password for the user.
Driver

Specify the JDBC driver class to use.

For Microsoft, this is the default configuration:

com.microsoft.sqlserver.jdbc.SQLServerDriver

Tr. Isolation
Note: Use this field only for database communication channels.

To access this field, select Manage > Communication, then click the Databases tab.

Select an isolation level for this transaction.

  • TRANSACTION_SERIALIZABLE

  • UNKNOWN_TRANSACTION_ISOLATION

  • TRANSACTION_NONE

  • TRANSACTION_READ_COMMITTED

  • TRANSACTION_READ_UNCOMMITTED

  • TRANSACTION_REPEATABLE_READ

  • TRANSACTION_SERIALIZABLE