Data Source Pooling Configuration

The pooling-datasource-factory.properties file (located under SpectrumLocation\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 maximize performance.

For best results, enable validation (testOnBorrow =true). This allows objects to be validated via a static query 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. Enabling validation will have a slight negative performance impact as a query is always run before the real query that is run by Spectrum Spatial; 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.