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>
Info

Note: Because of a bug in the org.geotools.sqlserver version 13.4.7.20231023 plugin you still need to include the <host> tag when using the URL connection type, even though it will be ignored. Version 13.4.8.20231123 of the bundle 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.

...