Thanks Ben Yes, I have configured the secondary namespace. The problem occurs with " &outputFormat=gml3", not with " &outputFormat=gml32" I will follow up the GEOS-8250 issue. Hopefully it will be solved in a future release
Bart -----Original Message----- From: Ben Caradoc-Davies [mailto:b...@transient.nz] Sent: maandag 30 oktober 2017 21:02 To: Verbeeck Bart <bart.verbe...@kb.vlaanderen.be>; geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] inspire-appscheme-wms-sqlserver 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