Versions Compared

Key

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

...

Info
titleTime filtering with SQL Server

If when filtering data from a SQL Server database you receive errors about the data types time and datetime being incompatible you can resolve this by setting sendTimeAsDatetime to false as a parameter in the connection URL, e.g.

<url>jdbc:sqlserver://sqls2014:1433;databaseName=GIS;sendTimeAsDatetime=false</url>


Info
titleTimestamps with Oracle

The Oracle JDBC driver by default does not correctly follow the JDBC specification when it comes to handling timestamp columns, to force the Oracle JDBC driver to be compliant you should set the system property oracle.jdbc.J2EE13Compliant to true.

Weave will try and work around the problem (and generate a warning pointing to this page) but at the cost of performance overhead.

Generally, only read access is required when connecting to the database, some custom modules may require write access.

Connecting pooling can be enabled for the data source, so that rather than connecting to the database each time it needs to perform an operation the Weave server will instead create a collection of connections and keep them in a pool to be used when required.

...