...
Name | Type | Required | Default | Description |
dbtype | String | yes |
| must be 'locationsxy' |
driver | String | yes |
| Java Class name of installed ConectionPool JDBC driver |
urlprefix | String | yes |
| complete jdbc URL for the database connection |
xcolumn | String | no | 'longitude' | name of JDBC results column containing easting (x, longitude etc) |
ycolumn | String | no | 'latitude' | name of JDBC results column containing northing (y, latitude etc) |
geom_name | String | no | 'the_geom' | the 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 |
schema | String | no | none | database schema |
charset | String | no | none | 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> <xcolumn>x</xcolumn> <ycolumn>y</ycolumn> <geom_name>shape</geom_name> <user>gis</user> <passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd> </spatial:spatialengine> |