database.url
This property specifies the JDBC connection string for accessing theSpotfire® Statistics Services job database.
| Property Name | Default Value | Property Description |
|---|---|---|
database.url | Can be blank for a standalone only. Upon first server start, the value is populated with the path to the embedded database. See Details for cluster default. | Contains a JDBC connection string for accessing the Spotfire Statistics Services job queue database. The string you enter depends on the value you set in the
database.type property. |
Details
If you use the default H2 as the database type in a cluster, the installation prepopulates with the following pattern to build the JDBC connection string for your environment:
jdbc:h2:tcp://<manager_node>:<dbport>/<spserver.cluster.share>/h2/dbwhere
- <manager_node> is the host name of the primary manager node running the database instance (that is, the manager node to run the database).
- <dbport> is the port number to use (by default, 9092 but you can specify any open port)
Note: The port you specify is the actual port used by the server, so be sure it is available.
- <spserver.cluster.share> is the location of the
SPSERVER_SHARE for the specified manager node.
- On Microsoft Windows®, for H2, this share requires 4 preceding backslashes, as follows:
\\\\hostname/path/to/share/h2/db
- On UNIX/Linux, for H2, this share appears as follows:
/path/to/share
- On Microsoft Windows®, for H2, this share requires 4 preceding backslashes, as follows:
- The subdirectory h2 is created by the installer.
- db is used to create the first part of the filenames of the database files.
Examples
- H2 database in a Windows cluster:
database.url=jdbc:h2:tcp://myserver:9999/\\\\hostname/path/to/share/h2/db - H2 in a UNIX/Linux cluster, set up as nfs share:
database.url=jdbc:h2:tcp://path/to/share/h2/db - Oracle database pattern:
database.url=jdbc:oracle:thin:@//<db_servername>:<db_serverport>:<SID> - MSSQL databse pattern:
database.url=jdbc:sqlserver://<db_servername>:<db_serverport>;databaseName=<database_name> - MYSQL database pattern:
database.url=jdbc:mysql://<db_servername>:<db_serverport>/<database_name>
For more information on JDBC connection strings, refer to the documentation for your database server.