...
| Code Block |
|---|
|
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<host>sqlhost</host>
<port>1434</port>
<database>INTERNAL</database>
<user>gis</user>
<passwd>ENCSMAAFGJGAMGESBUK</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>minconnection>
<validateconnections>true</validateconnections>
</spatial:spatialengine> |
...
| Code Block |
|---|
|
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<url>jdbc:sqlserver://sqlhost:1434;DatabaseName=INTERNAL</url>
<user>gis</user>
<passwd>ENCSMAAFGJGAMGESBUK</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>minconnection>
<validateconnections>true</validateconnections>
</spatial:spatialengine> |
| Note |
|---|
Note: Because of a bug in the org.geotools.sqlserver plugin you still need to include the <host> tag when using the URL connection type, even though it will be ignored.
Weave 2.6.9.5 and 2.6.10, which include version 13.4.8.20231123 of the above plugin, resolves that issue. |
Row Identifiers
Weave needs to be able to uniquely identify each row in a particular table, normally it would do this using the primary key of the table, but sometimes a primary key has not been specified so this information must be provided another way.
...
| Code Block |
|---|
|
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<host>sqlhost</host>
<port>1434</port>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>minconnection>
<validateconnections>true</validateconnections>
<primarykeymetadata>
<table schema="dbo" name="park" column="gid" policy="autogenerated"/>
<table schema="dbo" name="property" column="park_id" type="autogenerated"/>
<table schema="dbo" name="road" column="objectid" type="autogenerated"/>
</primarykeymetadata>
</spatial:spatialengine> |
...
| Code Block |
|---|
|
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<host>sqlhost</host>
<port>1434</port>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>minconnection>
<validateconnections>true</validateconnections>
<geometrymetadata>
<table schema="dbo" name="park" type="multipolygon" srid="28355" dimension="2"/>
<table schema="dbo" name="property" type="polygon" srid="28355" dimension="2"/>
<table schema="dbo" name="road" type="linestring" srid="28355" dimension="2"/>
</geometrymetadata>
</spatial:spatialengine> |
...