modify-db-config
Modifies the common database connection configuration.
modify-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}
[-e <true|false> | --clear-connection-properties=<true|false>]
Overview
Use this command to modify 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 | none | The maximum time (in seconds) to wait for a connection to become available. |
|
Optional | none | The maximum time (in seconds) that a connection can stay idle in the connection pool before being closed and discarded. |
|
Optional | none | The minimum number of connections to keep in the connection pool. |
|
Optional | none | The maximum number of connections to keep in the connection pool. |
|
Optional | none | 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 that is added to the existing list of connection properties. Several properties can be specified. (Can be specified multiple times with different keys.) |
|
Optional | false | Clears the existing list of connection properties. |
Examples
Setting the maximum number of connections in the pool:
config modify-db-config --max-connections=100
Setting the pooling scheme:
config modify-db-config --pooling-scheme=WAIT
Setting the size of the statement pool of the DataDirect driver:
config modify-db-config -CMaxPooledStatements=20
Parent topic: Command-line reference