Data Source Pooling Configuration

The pooling-datasource-factory.properties file (located under \server\modules\spatial) may be used to configure the pooling of connections used by JDBC-based data sources (such as Oracle and SQL Server) to optimize performance.

In most cases, we recommend enabling the validator class. This allows objects to be validated before being borrowed from the pool. If the validation fails, the connection will be dropped from the pool and an attempt will be made to borrow another. A validation query is also available for special cases, such as when using a custom data provider. If both the validation query and the validator class are enabled, the validator class will be used.

Enabling validation may have a slight negative performance impact; however, the test query maintains the integrity of all the connections in the connection pool in cases where communication between Spectrum Spatial and an external database is not reliable. Set a validation interval to mitigate the performance impact of validation. If a connection is due for validation but has been validated previously within this interval, it will not be validated again.