alias

The database alias to use.

catalogName

The name of the catalogue (schema) within the database. If omitted, the alias name is used.

database

The JDBC URL that represents the connection to the database. This URL is database-dependent, e.g. jdbc:mysql://myserver:3306/db.

driver

The class that represents the driver of the JDBC driver. This setting is database-dependent, e.g. org.gjt.mm.mysql.Driver.

user

The username to use for authenticating with the database.

password

The password to use for authentication with the database. Obfuscation is allowed, e.g. OBF:1wtm1xtz1w8v1xtj1wus

lowerCase

The name of the method for converting text to lowercase. Normally, this information is provided by the JDBC driver itself, but there are exceptions where an explicit specification is required.

minSize

The initial size of the connection pool when starting the service.

maxSize

The maximum size of the connection pool. If you want to use the default size, use value -1.

allowGrowing

If true, the pool is allowed to grow when all initially created connections have been issued to applications and another one is needed.

idleTime

Specifies the time in milliseconds that a connection must be unused in the pool before its validity is checked by the DatabaseService.

sqlCommand

The SQL command to verify the validity of a database connection. If no command is specified, the list of available tables is queried. However, this information is cached by some JDBC drivers so that a connection can be considered valid, even though it is no longer.

rollback

Set this option if the database works transaction-based. If you specify false, no attempt is made to start a transaction, which would otherwise result in an error message with some databases. Attention: If you specify of false for a transactional database, the attempt to start a transaction is ignored. Commit and rollback also have no effect, although the database would actually be able to do that.

caching

If set to true, SQL statements used by applications are cached. All statements must be checked by the DatabaseService and adapted if necessary. Therefore, it makes sense to save the result of these checks/changes for future use if your system has sufficient resources. However, if you primarily use dynamic statements, explicit deactivation of this option may make sense to avoid unnecessary memory usage for never-reused SQL statements.

checkConnection

If this item is activated, the validity of a connection is checked before it is issued to an application from the pool. This reduces the performance of the system, but ensures that the application gets a connection that works and has not become invalid since the last check.

supportsStream

Determines whether the linked database supports so-called character streams as parameters for writing to and reading from a database. This information is used, for example, by the JDO service to decide whether an object to be written into the database should be 'stripped' or not.

maxStatementLength

Sets the maximum size of an SQL statement. This setting can be used by applications to decide if a statement can be used with a character stream or not.

addNamedProperty

Allows setting so-called ConnectionProperties. For many JDBC drivers, the way to connect to the database can be controlled by setting key-value pairs. The first argument represents the key, the second represents the value to be set. Example: transaction level and none.
Which value pairs can be set depends on the JDBC driver used. Therefore, please refer to the documentation of the respective driver.

skipTrimResultValues

For MSSQL and Informix databases, the result values of SQL calls are trimmed of preceding and following spaces. If you do not want this, you can insert this value here and set it to true. Important note: However, you should not use this setting in the alias for the Lobster_data (hub) repository database, as this would lead to functional problems (partner management does not find channels, etc.). Rather create a second alias for the same database with this setting.