Database drivers and database connection URLs

The following details and examples show how the database connection URL is constructed.

Table 1. Supported databases and JDBC drivers
Database	Driver name
Oracle (Oracle JDBC Thin Driver, ojdbc`*`.jar)	oracle.jdbc.OracleDriver
Microsoft SQL Server (Microsoft JDBC Driver, sqljdbc`*`.jar)	com.microsoft.sqlserver.jdbc.SQLServerDriver
PostgreSQL driver postgresql`*`.jar	org.postgresql.Driver

Table 2. Database connection URL components
Component	Description
API	Specifies which API to use. This is always jdbc.
Database Driver	Specifies which database driver to use to connect to the database.
Hostname	Specifies the hostname of the database server.
Port	Specifies the port which the database server listens to; for example 1433.
Database name, SID, or service name	Specifies the name (MSSQL, PostgreSQL), SID (Oracle) or Service Name (Oracle) that defines your Spotfire database.
Options	Specifies further options, separated with semicolons. Only necessary if you want to set something specific for your database server, such as a named Instance in an MSSQL server. See the following examples.

Table 3. Database connection URL examples
Database driver	URL structure	Examples
Oracle (Vendor Driver, ojdbc*.jar)	[API]:[DBDriver]:[DriverType]://[Hostname]:[Port]:SID	jdbc:oracle:thin:@dbsrv.example.com:1521:orcl
Oracle (Vendor Driver, ojdbc*.jar)	[API]:[DBDriver]:[DriverType]://[Hostname]:[Port]/[ServiceName]	jdbc:oracle:thin:@//dbsrv.example.com:1521/pdborcl.example.com
Microsoft SQL Server (Vendor Driver, sqljdbc*.jar)	[API]:[DBDriver]://[Hostname]:[Port];DatabaseName=[DBName]	Basic example `jdbc:sqlserver://dbsrv.example.com:1433;DatabaseName=spotfire_server;selectMethod= cursor` Example: Making sure that the driver always returns prevents infinite waits during adverse conditions `jdbc:sqlserver://dbsrv.example.com:1433;DatabaseName=spotfire_server;lockTimeout= <X, where X is a good value>` Example: Using `responseBuffering=adaptive` Note: Due to a restriction in the vendor Microsoft SQL Server driver, you may need to add the option `responseBuffering=adaptive` to your connection string. This is necessary if you are going to store large analysis files in the library. `jdbc:sqlserver://dbsrv.example.com:1433;databaseName=spotfire_server;selectMethod= cursor;responseBuffering=adaptive` Example: Using Integrated Authentication `jdbc:sqlserver://dbsrv.example.com:1433;DatabaseName=spotfire_server;selectMethod= cursor;integratedSecurity=true;` Databases with self-signed certificates It is recommended that you use an encrypted connection to a database server with a valid, not self-signed, server certificate. For more information see Fixing Microsoft SQL Server JDBC driver-related issues.
PostgreSQL	[API]:[DBDriver]://[Hostname]:[Port]/[DBName]	jdbc:postgresql://dbsrv.example.com:5432/spotfire_server