The "geometryless" spatial engine is intended to add support for database tables that have an x and y location.

The driver emulates a spatially enabled table by generating point geometry on the fly based on the values in the x and y columns in the underlying tables.

The driver tries to expose every table in the database that it's pointed to as a spatially enabled table.

Name	Type	Required	Default	Description
dbtype	String	yes		Must be 'locationsxy'
driver	String	yes		Java Class name of an installed JDBC driver
urlprefix	String	yes		Complete JDBC URL for the database connection
user	String	yes		Username to connect to the database
passwd	String	yes		Password to connect to the database
xcolumn	String	yes		Name of JDBC results column containing easting (x, longitude etc)
ycolumn	String	yes		Name of JDBC results column containing northing (y, latitude etc)
geom_name	String	yes		Name of the geometry attribute generated from the x,y columns. This is a virtual column that will be added to each table and will be a Point that is made from the values in xcolumn and ycolumn. The value used here doesn't have any external effects, it just provides the name of the column that will be created. examples are "shape" or "the_geom" or just "geom"
schema	String	no	none	Database schema
charset	String	no	none	Database character set
crs	String	no	none	A default CRS to use for the data contained within the tables

Example

<spatial:spatialengine id="test">
	<dbtype>locationsxy</dbtype>
	<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
	<urlprefix><![CDATA[jdbc:sqlserver://sqlserver2008;instanceName=SQLEXPRESS;databaseName=GIS]]></urlprefix>
	<user>gis</user>
	<passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd>
	<xcolumn>x</xcolumn>
	<ycolumn>y</ycolumn>
	<geom_name>shape</geom_name>
	<crs>EPSG:28355</crs>
	<primarykeymetadata>
		<table name="WkALR" column="fid"/>
		<table name="WkPRN" column="fid"/>
	</primarykeymetadata>
</spatial:spatialengine>

<Edit>

Browser not supported