|
From: Justin D. <jde...@op...> - 2012-06-06 16:02:39
|
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. |