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
|