GeoTools

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

Ascending order - Click to sort in descending order
Hide
Permalink
Justin Deoliveira added a comment -
Thanks Bjorn!
Show
Justin Deoliveira added a comment - Thanks Bjorn!
Hide
Permalink
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
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: