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.

ArcSDE 10.3

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.

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 (to include the ArcSDE native libraries in Weave).
The current stable release of Weave contains libraries for ArcSDE version 9.3.1, so only support ArcSDE 9.3.1 and earlier for direct connect. However, the libraries for ArcSDE 10 are available and can be provided on request for sites attempting direct connect to ArcSDE 10.

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
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. 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.
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

<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>