A spatial engine provides access to a service that can perform spatial operations, one of the available spatial engines is for ArcSDE.
| Info | ||
|---|---|---|
| ||
Cohga does not recommend sites update beyond ArcSDE 10.2. ArcSDE 10.3 provides little additional functionality (in fact none that I can find) and ESRI has removed the ability for third party applications (like Weave) to connect to ArcSDE. If you do migrate to ArcSDE 10.3 and wish to continue to use data managed by ArcSDE with Weave you will need to ensure that ArcSDE stores the data using the underlying database native geometry type and have Weave connect to the database directly. |
| Note |
|---|
Supporting Direct Connect is not a trivial matter, it requires a full installation of the ArcSDE client on the Weave server and modifications to the Weave startup . The following links may help. |
...
Tags
spatialengine
Properties
Name | Type | Required | Description |
id | string | yes | Unique identifier |
dbtype | 'arcsde' | yes | The name of the driver to use, in this case ArcSDE |
server | string | yes | The hostname or ip address of the ArcSDE server |
port | string | yes | The port number that the ArcSDE server is running on or the direct connect description |
instance | string | no | The specific database to connect to. Only applicable to certain databases. Value ignored if not applicable |
user | string | yes | The userid used when connecting to ArcSDE |
password | string | yes | The password used when connecting to ArcSDE |
database.version | string | no | Which version to use, the default will be used if not set. |
datastore.allowNonSpatialTables | boolean | no | Should non-spatial tables also be exposed. |
| datastore.allowUnregisteredTables | boolean | no | Should non-registered tables also be exposed. |
Sub-tags
Name | type | cardinality |
pool | urn:com.cohga.server.spatial.geotools#1.0:pool | 0..1 |
Content
None
pool
Properties
Name | Type | Required | Default | Description |
minConnections | number | no | 2 | The number of connection to create at startup. |
maxConnections | number | no |
6 | The maximum number of objects that can be borrowed from the pool at one. | |
timeOut | number | no |
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 |
-1 | The maximum number of idle connections in the pool. | |
testOnBorrow | boolean | no |
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 |
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. |
lifo | boolean | no | true | If true then the last connection returned to the pool will be the next one handed out, if false then the oldest connection returned to the pool will be the next one handed out. |
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> |