Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagexml
<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</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.

...