databaseRepository

<databaseRepository
>
required
<dataSources
<connectionPool
<maximumConnectionCount
>
optional
int

Maximum number of concurrent connections to the database. Environment variables and system properties can be used. Users can override this setting for individual databases in the Management Center.

Default: 5

</maximumConnectionCount>
<maximumWaitTimeInMilliseconds
>
optional
long

Maximum time (in ms) to wait for a free database connection. Environment variables and system properties can be used. Users can override this setting for individual databases in the Management Center.

Default: 30000

</maximumWaitTimeInMilliseconds>
<idleConnectionTimeoutInMilliseconds
>
optional
long

The time in milliseconds that a connection is allowed to be idle before it is closed and removed. A value of 0 means that connections will never be closed again. Environment variables and system properties can be used.

Default: 60000

</idleConnectionTimeoutInMilliseconds>
<minimumIdleConnectionCount
>
optional
int

The minimum number of idle connections in the pool before a new connection is created. When this number is not reached, new connections are created before they are requested, resulting in better performance for subsequent requests. maximumConnectionCount is never exceeded. Environment variables and system properties can be used.

Default: 2

</minimumIdleConnectionCount>
<validationSqlStatements
>
optional

The statement(s) used to validate connections.

<validationSqlStatement
xsd:string
type
optional
=
string

The type of the RDBMS data source (e.g. Oracle, PostgreSQL, H2, MSSQL). If no type is given, then this statement is used for data sources for which no type specific validation statement is configured in here.

>
requiredmax. unbounded
</validationSqlStatement>
</validationSqlStatements>
<validationQueryTimeoutInMilliseconds
>
optional
long

Defines the maximum number of milliseconds the validation of database connections can take. Please note that this setting also takes effect when validationSqlStatement is not provided, since connection pool will validate connection anyway by simply pinging the database server.

Default: 15000

</validationQueryTimeoutInMilliseconds>
>
optional
</connectionPool>
>
optional
</dataSources>
</databaseRepository>