[Geoserver-devel] [jira] Created: (GEOS-3531) Non-Geometry Column Named "Location" Causes WFS Exception

Non-Geometry Column Named "Location" Causes WFS Exception
---------------------------------------------------------

                 Key: GEOS-3531
                 URL: http://jira.codehaus.org/browse/GEOS-3531
             Project: GeoServer
          Issue Type: Bug
          Components: PostGIS, WFS
         Environment: OS: Windows 2003
Container: Tomcat 6 redirect to IIS
Java: Version 6 update 14
GeoServer: 1.7.5
            Reporter: Phil Nugent
            Assignee: Andrea Aime
            Priority: Minor

Per Justin: "location" is also a reserved word in gml as well. Every gml feature
type extends from gml:AbstractFeatureType. And that contains a
"location" attribute which is a geometry property afaik. In general when fields in a dataset have the same name as a gml property
they are attempted to morph into that type, in this case a geometry.

Original Issue: I ran into a problem with a WFS getfeature request, though I don't know if this is a bug in GeoServer. Discovered that the problem is with retrieving feature information from PostGIS where the table contains a column with name "location". I found out that "location" is a reserved word in Postgres, but I don't think that is the issue. From the exception, it looks like some component is expecting a field with name "location" to be geomety and is trying to cast from string. I solved the problem temporarily by renaming the column.

Exception:
<ows:Exception exceptionCode="NoApplicableCode">
<ows:ExceptionText> java.lang.RuntimeException: Failed to get property: gid Failed to get property: gid java.lang.String cannot be cast to com.vividsolutions.jts.geom.Geometry</ows:ExceptionText>
</ows:Exception>

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira