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:[email protected]]
Sent: dinsdag 31 oktober 2017 7:35
To: Ben Caradoc-Davies <[email protected]>;
[email protected]
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:[email protected]]
Sent: maandag 30 oktober 2017 21:02
To: Verbeeck Bart <[email protected]>;
[email protected]
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
>
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <[email protected]>
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
