Bart,
I have no experience with sqlserver, but in relation to the null GML
namespace, have you configured a secondary namespace for GML 3.2.1?
http://docs.geoserver.org/latest/en/user/data/app-schema/supported-gml-versions.html#secondary-namespace-for-gml-3-2-1-required
The DescribeFeatureType problem is reported here:
[GEOS-8250] WFS 2.0 DescribeFeatureType responses for app-schema types
contain a spurious WFS 2.0 jar import
https://osgeo-org.atlassian.net/browse/GEOS-8250
Kind regards,
Ben.
On 30/10/17 23:22, Verbeeck Bart wrote:
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
--
Ben Caradoc-Davies <b...@transient.nz>
Director
Transient Software Limited <http://transient.nz/>
New Zealand
------------------------------------------------------------------------------
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
