...
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 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 |
| 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>
<crs>EPSG:28355</crs>
<primarykeymetadata>
<table name="WkALR" column="fid"/>
<table name="WkPRN" column="fid"/>
</primarykeymetadata>
</spatial:spatialengine>
|