GeoTools
  1. GeoTools
  2. GEOT-3611

No support for base dbms caps for SQL Server 2008

    Details

    • Type: New Feature New Feature
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.7.2, 8.0-M1
    • Component/s: jdbc-sqlserver plugin
    • Labels:
      None

      Description

      I'm not sure this is simply a mistake but is seems like the SQL Server 2008 supporting code does not add base dbms caps which means for instance that it can't build LIKE filters (and probably more?) - currently when using GetFeature with a like filter it will ask the db for all data and filter clientside causing performance problems (since no index can be used and full data is returned)

      Supplied patch simply enables base dbms caps and initial tests seems to indicate that it works.

        Activity

        Hide
        Justin Deoliveira added a comment -
        Thanks Bjorn!
        Show
        Justin Deoliveira added a comment - Thanks Bjorn!
        Hide
        Jody Garnett added a comment -
        Resolved issues being marked closed in conjunction with the release of GeoTools 2.7.2.
        Show
        Jody Garnett added a comment - Resolved issues being marked closed in conjunction with the release of GeoTools 2.7.2.

          People

          • Assignee:
            Justin Deoliveira
            Reporter:
            Björn Harrtell
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: