Re: [Geoserver-users] inspire-appscheme-wms-sqlserver

Ben Caradoc-Davies Wed, 01 Nov 2017 12:45:07 -0700

Bart,

WMS should be supported. Does WFS work for this layer? I suspect eithera subtle problem in your mapping or a bug in the app-schema joiningimplementation.


Kind regards,
Ben.

On 31/10/17 20:13, Verbeeck Bart wrote:

Hi again

I moved my data to postgresql and I received the same error doing a getmap 
request. So this problem is not sqlserver related.

Is it a wrong idea to do wms requests to an application scheme based layer?


Geoserver sends the following query to my postgis database, and it has an error at         "AND 
"uidn" FROM "public"."bekken"

SELECT "public"."bekken"."ogc_fid",encode(ST_AsEWKB("public"."bekken"."wkb_geometry"),'base64') as 
"wkb_geometry","public"."bekken"."uidn","public"."bekken"."oidn"
FROM "public"."bekken" INNER JOIN ( SELECT DISTINCT "oidn" FROM 
"public"."bekken"
WHERE "wkb_geometry" && ST_GeomFromText('POLYGON ((-80016.3310434809 -54667.64601825603, 
-80016.3310434809 322203.1650796655, 391530.2915944371 322203.1650796655, 391530.2915944371 
-54667.64601825603, -80016.3310434809 -54667.64601825603))', 31370) ) "temp_alias_used_for_filter"
ON ( "bekken"."oidn" = "temp_alias_used_for_filter"."oidn" AND "uidn" FROM 
"public"."bekken"
WHERE "wkb_geometry" && ST_GeomFromText('POLYGON ((-80016.3310434809 -54667.64601825603, 
-80016.3310434809 322203.1650796655, 391530.2915944371 322203.1650796655, 391530.2915944371 
-54667.64601825603, -80016.3310434809 -54667.64601825603))', 31370) ) "temp_alias_used_for_filter"
ON ( "bekken"."uidn" = "temp_alias_used_for_filter"."uidn" )  ORDER BY "public"."bekken"."oidn" ASC, 
"public"."bekken"."uidn" ASC, "public"."bekken"."ogc_fid"

-----Original Message-----
From: Verbeeck Bart [mailto:bart.verbe...@kb.vlaanderen.be]
Sent: dinsdag 31 oktober 2017 7:35
To: Ben Caradoc-Davies <b...@transient.nz>; 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] inspire-appscheme-wms-sqlserver

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


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

Re: [Geoserver-users] inspire-appscheme-wms-sqlserver

Reply via email to