set-db-config
Sets the common database connection configuration.
set-db-config
[-c value | --configuration=value]
[-b value | --bootstrap-config=value]
[-l value | --login-timeout=value]
[-o value | --connection-timeout=value]
[-i value | --min-connections=value]
[-a value | --max-connections=value]
[-p value | --pooling-scheme=value]
[-q value]
{-Ckey=value}
Overview
Use this command to set the common configuration for the connection to the Spotfire Server database. This configuration (which affects all servers) is merged with the configuration in the bootstrap.xml file on each server.
Options
Option | Optional or Required | Default Value | Description |
---|---|---|---|
|
Optional | configuration.xml | The path to the server configuration file. |
|
Optional | none | The path to the bootstrap configuration file. See Bootstrap.xml file for more information about this file. |
|
Optional | 10 | The maximum time (in seconds) to wait for a connection to become available. |
|
Optional | 600 | The maximum time (in seconds) a connection can stay idle in the connection pool before being closed and discarded. |
|
Optional | 5 | The minimum number of connections to keep in the connection pool. |
|
Optional | 40 | The maximum number of connections to keep in the connection pool. |
|
Optional | WAIT |
The connection pooling algorithm to be used. Valid values
are:
|
|
Optional | none | An SQL query that should be run directly after a connection has been created. |
|
Optional | none | A JDBC connection property. Several properties can be specified. |
Examples
To set the maximum number of connections in the pool:
config set-db-config --max-connections=100
To set the pooling scheme:
config set-db-config --pooling-scheme=WAIT