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/db

where

  • <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

  • 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.

Related reference