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.

alias

The database alias to use.

allowGrowing

If true, the pool is allowed to grow when all initially created connections have been issued to applications and another one is needed. If false, unfulfillable connection requests are rejected.

autogenKeysPrepareSupport

true sets the information that the driver is able to get the columns for automatically generated IDs configured by name.

blobEncoding

Character set to be used when converting text to binary data when setting BLOB parameters.

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.

catalogName

Defines the name of the catalogue to be used as the default catalogue if statements do not contain any specific information. If this is not specified, the alias name is used.

checkConnection

If true, 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.

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.

idleTime

Specifies the time in milliseconds that a connection must be unused in the pool before its validity is checked by the DatabaseService. Important note: Please note that there is a global idleTime for the service itself and a local one for the respective alias. An alias is not checked until its local time has expired and the global one.

isolationLevel

Isolation level to be used. Details can be found in your JDBC documentation.

-1: Driver default.
0: TRANSACTION_NONE
1: TRANSACTION_READ_UNCOMMITTED
2: TRANSACTION_READ_COMMITTED
4: TRANSACTION_REPEATABLE_READ
8: TRANSACTION_SERIALIZABLE
Every other number: Other.

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.

maxSize

Maximum number (not negative) of connections held in the pool. -1 sets the maxSize to twice the minSize, but at least to 1. All connections exceeding this number are disconnected as soon as they are no longer used. 0 thus effectively deactivates the pool function of the service.

maxStatementLength

Maximum length of a statement including parameters. Is used by the JDOService to decide whether 'stripping' should be used when saving data. 0 deactivates this check.

minSize

Number (not negative) of initial connections to be established at startup. If the currently set maxSize is smaller than the newly set minimum value, the maximum value is automatically adjusted. Therefore, maxSize should only be executed after minSize has been set in order to avoid unwanted side effects.

nullKeyword

Text (not empty) to be used in parameter values as a representation of NULL.

password

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

readOnly

With true, the driver is informed that the database is to be accessed in read-only mode and allows the use of shadow databases instead of the main system in cluster operation.

rollback

true means that the database to be connected supports transaction-based work. Specifying false means that no attempt is made to start a transaction, which would result in an error message for 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.

selectNullKeyWord

Text (not empty) to be used in results as a representation of NULL.

simulateAccess

true prevents the execution of data-changing statements such as UPDATE or DELETE.

skipTrimResultValues

In MSSQL and Informix databases, the result values of SQL calls are trimmed of leading and trailing spaces. If you do not want this, you can insert this parameter here and set it to "true". Important note: However, you should not use this setting in the alias for the repository database ("hub"), 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.

slowLogMilliSeconds

Execution time in milliseconds from which statements are to be logged.

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.

strictSchema

With true, database metadata is filtered for entries that belong to the set catalogue.

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.

synchronousStartupInit

With false, the pool is initialised with a time delay and not as part of the start process.

user

The username to use for authenticating with the database.

HSQLCheckPointDefragHandler

A special execution of the DBReorgHandler that executes the statement checkpoint defrag against the database behind the respective alias.

DBReorgHandler

Allows setting SQL statements to be executed during rollover.