The "geometryless" spatial engine is intended to add support for database tables that have am 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.
org.geotools.geometryless_2.6.6.20130909.jar
Name | Type | Required | Default | Description |
dbtype | String | yes |
| must Must be 'locationsxy' |
driver | String | yes |
| Java Class name of an installed ConectionPool JDBC driver |
urlprefix | String | yes |
| complete jdbc 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 | no | 'longitude' | name Name of JDBC results column containing easting (x, longitude etc) |
ycolumn | String | no | 'latitude' | name Name of JDBC results column containing northing (y, latitude etc) |
geom_name | String | no | 'the_geom' | the name Name of the geometry attribute generated from the x,y columns |
user | String | yes |
| user name to login as |
passwd | String | yes |
| password used to login . 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. |
schema | String | no | none | database Database schema |
charset | String | no | none | Database character set |
namespace | String | no | none | namespace prefix used |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<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> <user>gis</user> <passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd> </spatial:spatialengine> |