Bart,

is your application schema GML 3.2.1 or GML 3.1? You must use the output format that matches the version of your application schema.

- If you are requesting GML 3.1.1 (e.g. with WFS 1.1.0 or WFS 2.0.0 with outputformat=gml3) when using a GML 3.1.1 application schema and you see mention of the GML 3.2.1 namespace "http://www.opengis.net/gml/3.2";, something is badly wrong.

- If you are requesting GML 3.1.1 when using a GML 3.2.1 application schema, your request is conceptually malformed. GML 3.1.1 and GML 3.2.1 are different incompatible information models. They even have different base classes for a feature. You cannot request GML 3.1.1 output for a type that is defined in GML 3.2.1.

Kind regards,
Ben.


On 31/10/17 19:34, Verbeeck Bart wrote:
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


--
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

Reply via email to