...
Name | Type | Required | Default | Description |
minConnections | number | no | 2 | The number of connection to create at startup. |
maxConnections | number | no | 2 6 | The maximum number of objects that can be borrowed from the pool at one. |
timeOut | number | no | 1000 500 | The maximum amount of time to wait, in milliseconds, for an object when the pool is exhausted and whenExhaustedAction is 'block' (otherwise ignored). |
minIdle | number | no | 0 | The minimum number of idle connections in the pool. |
maxIdle | number | no 8 | -1 | The maximum number of idle connections in the pool. |
testOnBorrow | boolean | no | false true | Should the connection be checked for validity when being borrowed from the pool. |
testOnReturn | boolean | no | false | Should the connection be checked for validity when being returned to the pool. |
testWhileIdle | boolean | no | false | Should the connection be checked for validity when just sitting in the pool. |
timeBetweenEvictionRunsMillis | number | no | -1 | Sets the number of milliseconds to sleep between runs of the idle connection evictor. This needs to be set if 'testWhileIdle' has been set to true. |
whenExhaustedAction | 'fail', 'grow' or 'block' | no | block | Sets the action to take when the pool is exhausted (the maximum number of "active" objects has been reached). |
minEvictableIdleTimeMillis | number | no | 1800000 300000 | The minimum number of milliseconds an connection can sit idle in the pool before it is eligible for eviction. |
softMinEvictableIdleTimeMillis | number | no | -1 | The minimum number of milliseconds an connection can sit idle in the pool before it is eligible for eviction with the extra condition that at least "minIdle" amount of connections remain in the pool. |
database.version | string | no | default | Which version to use, the default will be used if not set. |
datastore.allowNonSpatialTables | boolean | no | false | Should non-spatial tables also be exposed. |
Sub-tags
None
Content
None
Examples
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<geotools:spatialengine id="arcsde">
<dbtype>arcsde</dbtype>
<server>sdedev</server>
<port>5151</port>
<user>gis</user>
<password>b0rdumm</password>
<pool>
<minConnections>1<<minConnections>2</minConnections>
<maxConnections>16</maxConnections>
<timeout>10<<timeout>1000</timeout>
<testOnBorrow>true</testOnBorrow>
<testOnReturn>false<<testOnReturn>true</testOnReturn>
<testWhileIdle>false</testWhileIdle>
<timeBetweenEvictionRunsMillis>5000<<minEvictableIdleTimeMillis>180000</timeBetweenEvictionRunsMillis>minEvictableIdleTimeMillis>
</pool>
<whenExhaustedAction>grow</whenExhaustedAction><database.version>PUBLIC</database.version>
</pool><datastore.allowNonSpatialTables>true</datastore.allowNonSpatialTables>
</geotools:spatialengine>
|