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 | A comma-separated list of the library items (GUIDs) to download. |
|
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
To set the size of the statement pool of the DataDirect driver:
config set-db-config CMaxPooledStatements=20
Parent topic: Command-line reference