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> ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
