Spatial Engine ArcSDE

A spatial engine provides access to a service that can perform spatial operations, one of the available spatial engines is for ArcSDE.

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.
Currently on ArcSDE version 9.3.1 and earlier are supported by Weave.

The following links may help.

Namespace

urn:com.cohga.server.spatial.geotools#1.0

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

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. This is always 0 now.
maxIdle	number	no	-1	The maximum number of idle connections in the pool. This is always -1 (no limit) now.
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). This value is 'block' when timeOut > 0, or 'fail' when timeOut <= 0, and 'grow' is no longer supported.
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. This is no longer supported/required.
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

<geotools:spatialengine id="arcsde">
        <dbtype>arcsde</dbtype>
        <server>sdedev</server>
        <port>5151</port>
        <user>gis</user>
        <password>b0rdumm</password>
        <pool>
                <minConnections>2</minConnections>
                <maxConnections>16</maxConnections>
                <timeout>1000</timeout>
                <testOnBorrow>true</testOnBorrow>
                <testOnReturn>true</testOnReturn>
                <testWhileIdle>false</testWhileIdle>
                <minEvictableIdleTimeMillis>180000</minEvictableIdleTimeMillis>
        </pool>
        <database.version>PUBLIC</database.version>
        <datastore.allowNonSpatialTables>true</datastore.allowNonSpatialTables>
</geotools:spatialengine>