[Geoserver-users] WFS 2.0 Spatial Join

[Jürgen W. <jue...@bv...>]

Hello everybody,

i'm trying to do a simple spatial join through WFS 2.0 but it failed 
(SQL Exception)

Any help will be welcomed!

Thanks in advance,
Juergen Weichand


Request:

<?xml version="1.0" encoding="UTF-8"?>
<wfs:GetFeature service="WFS" version="2.0.0"
xmlns="http://www.opengis.net/wfs/2.0"
xmlns:wfs="http://www.opengis.net/wfs/2.0"
xmlns:gml="http://www.opengis.net/gml/3.2"
xmlns:fes="http://www.opengis.net/fes/2.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:bvv="http://www.geodaten.bayern.de"
xsi:schemaLocation="http://www.opengis.net/wfs/2.0 
http://schemas.opengis.net/wfs/2.0/wfs.xsd http://www.opengis.net/gml/3.2
http://schemas.opengis.net/gml/3.2.1/gml.xsd"
outputFormat="application/gml+xml; version=3.2">
<wfs:Query typeNames="bvv:lkr_ex bvv:gmd_ex" aliases="lkr gmd" 
srsName="EPSG:31468" handle="Q01">
<fes:Filter>
<fes:And>
<fes:PropertyIsEqualTo>
<fes:ValueReference>lkr/sch</fes:ValueReference>
<fes:Literal>09184</fes:Literal>
</fes:PropertyIsEqualTo>
<fes:Contains>
<fes:ValueReference>lkr/the_geom</fes:ValueReference>
<fes:ValueReference>gmd/the_geom</fes:ValueReference>
</fes:Contains>
</fes:And>
</fes:Filter>
</wfs:Query>
</wfs:GetFeature>

Response:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="2.0.0"
   xsi:schemaLocation="http://www.opengis.net/ows/1.1 
http://geoserv.weichand.de:8080/geoserver/schemas/ows/1.1.0/owsAll.xsd"
   xmlns:ows="http://www.opengis.net/ows/1.1" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ows:Exception exceptionCode="NoApplicableCode">
<ows:ExceptionText>java.lang.RuntimeException: 
org.geotools.data.DataSourceException: SQL exception occurred while 
reading the geometry.
org.geotools.data.DataSourceException: SQL exception occurred while 
reading the geometry.
SQL exception occurred while reading the geometry.
The column index is out of range: 33, number of columns: 32.
</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>