|
From: Jürgen W. <jue...@bv...> - 2012-06-06 11:18:57
|
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> |