Page Comparison

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

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.

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 lifo

string boolean

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