Advanced connection pool configuration

Information Services uses the same underlying connection pool implementation as Spotfire Server uses for connecting to its own database. The following special parameters are available to configure some of the aspects of that connection pool.


Special parameter	Corresponding common parameter
`spotfire.pooling.data.source.scheme`	`pooling-scheme`
`spotfire.pooling.data.source.connection.timeout`	`connection-timeout`
`spotfire.pooling.data.source.login.timeout`	`login-timeout`
`spotfire.kerberos.login.context`	`kerberos-login-context`

For more information, see Database connectivity.

All these parameters should be added as JDBC connection properties. However, they are never used as real JDBC connection properties and are never sent to a database server.

Example: Configuring a connection pool for Oracle databases

<jdbc-type-settings>
 <type-name>oracle</type-name>
 <driver>oracle.jdbc.OracleDriver</driver>
 <connection-urlpattern>jdbc:oracle:thin:@&lt;host&gt;:&lt;port1521&gt;:&lt;sid&gt;</
connection-url-pattern>
 <ping-command>SELECT 1 FROM DUAL</ping-command>
 <connection-properties>
 <connection-property>
 <key>spotfire.pooling.data.source.scheme</key>
 <value>WAIT</value>
 </connection-property>
 <connection-property>
<key>spotfire.pooling.data.source.connection.timeout</key>
 <value>1800</value>
 </connection-property>
 <connection-property>
 <key>spotfire.pooling.data.source.login.timeout</key>
 <value>30</value>
 </connection-property>
 </connection-properties>
 ...
</jdbc-type-settings>