Oracle (DataDirect Driver)
|
[API]:[DBDriver]:[ServerType]://[Hostname]:[Port];SID=[SID]
|
jdbc:tibcosoftwareinc:oracle://dbsrv.example.com:1521;SID=spotfire_server
|
Oracle (DataDirect Driver)
|
[API]:[DBDriver]:[ServerType]://[Hostname]:[Port];ServiceName=[Service Name]
|
jdbc:tibcosoftwareinc:oracle://dbsrv.example.com:1521;ServiceName= pdborcl.example.com
|
Oracle (Vendor Driver, ojdbc7.jar)
|
[API]:[DBDriver]:[DriverType]://[Hostname]:[Port]:SID
|
jdbc:oracle:thin:@dbsrv.example.com:1521:orcl
|
Oracle (Vendor Driver, ojdbc7.jar)
|
[API]:[DBDriver]:[DriverType]://[Hostname]:[Port]/[ServiceName]
|
jdbc:oracle:thin:@//dbsrv.example.com:1521/pdborcl.example.com
|
Microsoft SQL Server (DataDirect Driver)
|
[API]:[DBDriver]:[ServerType]://[Hostname]:[Port];DatabaseName=[DBName]
|
jdbc:tibcosoftwareinc:sqlserver://dbsrv.example.com:1433;DatabaseName= spotfire_server
Example using Integrated Authentication:
jdbc:tibcosoftwareinc:sqlserver://dbsrv.example.com:1433;DatabaseName= spotfire_server;AuthenticationMethod=ntlm;LoadLibraryPath=c:/tibco/tss/ <version>/tomcat/ lib
Note: Make sure that the LoadLibraryPath has the correct path to the tomcat/lib directory in
Spotfire Server installation directory.
|
Microsoft SQL Server (Vendor Driver, sqljdbc4.jar)
|
[API]:[DBDriver]://[Hostname]:[Port];DatabaseName=[DBName]
|
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>
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.
Example: Using
responseBuffering=adaptive
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;
Note: For Integrated Authentication to work, you must place the file
sqljdbc_auth.dll in a folder in the system path, such as C:\Windows\System32. This file is included with the vendor drivers from Microsoft.
|