Re: [Geoserver-users] WFS 2.0 Spatial Join

[Justin D. <jde...@op...>]

Hi Juergen,

What type of backend datasource are you using? If you could provide a full
stack trace that would be helpful. Thanks.

-Justin

On Wed, Jun 6, 2012 at 4:18 AM, Jürgen Weichand <
jue...@bv...> wrote:

> 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
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>



-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.