Spatial Engine MySQL

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

Namespace

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

Tags

spatialengine

Properties

Name

Type

Required

Description

id

string

yes

Unique identifier

dbtype

'mysql'

yes

The name of the driver to use, in this case MySQL

host

string

yes

The hostname or ip address of the MySQL server

port

number

yes

The port number that the MySQL instance is running on

database

string

yes

The database to connected to

user

string

yes

The userid used when connecting to the database

passwd

string

yes

The password used when connecting to the database

minconnections

integer

no

The minimum number of connections to open to the database

maxconnections

integer

no

The maximum number of connections to open to the database

validateconnections

boolean

no

Should database connections be checked on each access to see if they're still valid

namespace

string

no

The namespace prefix

Sub-tags

None

Content

None

Examples

<spatial:spatialengine id="mysql">
	<dbtype>mysql</dbtype>
	<host>mysqlhost</host>
	<port>3306</port>
	<database>spatial</database>
	<user>gis</user>
	<passwd>hak0rz</passwd>
</spatial:spatialengine>