Hi List
In our organization we try to use geoserver (2.11) to serve harmonized services
using the application scheme extension.
Our data is stored in a SQLSERVER db. The documentation refers to postgres and
oracle databases, not to sqlserver.
The wfs services seem to work, although
* there is the null namespace problem (null:identifier [
xmlns:null=http://www.opengis.net/gml/3.2
codeSpace=http://inspire.ec.europa.eu/ids ])
* the describefeaturetype (2.0.0) result is not as I would expect,
schemaLocation="jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.0/webapps/overdrachtdiensten/WEB-INF/lib/gt-xsd-wfs-17.2.jar!/org/geotools/wfs/v2_0/wfs.xsd
The wms getfeaturetype result is ok, but the getmap request causes an erroneous
sql request (at "FROM") (see below)
The wms getmap result is successful on a shapefile based layer.
Does anyone have experience using the app scheme on a sql server database?
Thanks
Bart
SELECT "RT"."BEKKEN"."OBJECTID","RT"."BEKKEN"."UIDN","RT"."BEKKEN"."SHAPE" as
"SHAPE","RT"."BEKKEN"."OIDN"
FROM "RT"."BEKKEN"
INNER JOIN (
SELECT DISTINCT "OIDN"
FROM "RT"."BEKKEN"
WHERE "SHAPE".Filter(geometry::STGeomFromText('POLYGON
((12127.108205075114 2103.1082012057304, 12127.108205075114 395097.58538683876,
267800.38165359845 395097.58538683876, 267800.38165359845 2103.1082012057304,
12127.108205075114 2103.1082012057304))', 31370)) = 1 )
"temp_alias_used_for_filter"
ON ( "BEKKEN"."OIDN" = "temp_alias_used_for_filter"."OIDN" AND
"UIDN" FROM "RT"."BEKKEN" WHERE
"SHAPE".Filter(geometry::STGeomFromText('POLYGON ((12127.108205075114
2103.1082012057304, 12127.108205075114 395097.58538683876, 267800.38165359845
395097.58538683876, 267800.38165359845 2103.1082012057304, 12127.108205075114
2103.1082012057304))', 31370)) = 1 ) "temp_alias_used_for_filter"
ON ( "BEKKEN"."UIDN" = "temp_alias_used_for_filter"."UIDN" )
ORDER BY "RT"."BEKKEN"."OIDN" ASC, "RT"."BEKKEN"."UIDN" ASC,
"RT"."BEKKEN"."OBJECTID"
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
