[Geoserver-users] getfeature problem

Balazs_Bamer · April 22, 2009, 8:24pm

Hi All,

I use Geoserver 1.7.2 with Oracle Spatial datasource (not the NG version)
For the request

http://att-it.homelinux.net:22880/geoserver/wfs?service=WFS&request=getFeature&version=1.0.0&typename=szentendre:szentendre_ugyint&filter=<ogc%3AFilter+xmlns%3Aogc%3D'http%3A%2F%2Fogc.org'+xmlns%3Agml%3D'http%3A%2F%2Fwww.opengis.net%2Fgml'><ogc%3APropertyIsEqualTo><ogc%3APropertyName>HRSZ<%2Fogc%3APropertyName><ogc%3ALiteral>1<%2Fogc%3ALiteral><%2Fogc%3APropertyIsEqualTo><%2Fogc%3AFilter>

(human readable filter part:
<ogc:Filter xmlns:ogc='http://ogc.org'
xmlns:gml='http://www.opengis.net/gml’><ogc:PropertyIsEqualTo><ogc:PropertyName>HRSZ</ogc:PropertyName><ogc:Literal>45</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter>
)

the response is empty, altough there should be one hit. GeoServer log contains

2009-04-22 22:01:59,457 DEBUG [geoserver.requests] - Query is net.opengis.wfs.im
pl.QueryTypeImpl@anonymised.com (group: , propertyName: , function: null,
filter: [ HRSZ = 45 ], sortBy: , featureVersion: null, handle: null,
srsName: null, typeName:
[{http://att-it.homelinux.net/szentendre\}szentendre_ugyint])
To gt2: Query:
   feature type: szentendre_ugyint
   filter: [ HRSZ = 45 ]
   [properties: ALL ]
2009-04-22 22:01:59,457 INFO [geoserver.wfs] -
Request: getFeature
        handle = null
        service = WFS
        version = 1.0.0
        baseUrl = http://att-it.homelinux.net:22880/geoserver/
        providedVersion = 1.0.0
        query = [net.opengis.wfs.impl.QueryTypeImpl@anonymised.com (group:
null, propertyName: null, function: null, filter: [ HRSZ = 45 ],
sortBy: null, featureVersion: null, handle: null, srsName: null,
typeName: [{http://att-it.homelinux.net/szentendre\}szentendre_ugyint])]
        maxFeatures = null
        outputFormat = GML2
        resultType = results
        traverseXlinkDepth = null
        traverseXlinkExpiry = null
        formatOptions = {}
2009-04-22 22:01:59,461 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle: Geom
etric Column is: GEOM
2009-04-22 22:01:59,461 DEBUG [filter.SQLEncoderOracle] -
SQLEncoderOracle: Geometric Column is: GEOM
2009-04-22 22:01:59,462 DEBUG [data.jdbc] - calling sql builder with
filter [ HRSZ = 45 ]
2009-04-22 22:01:59,462 TRACE [geotools.core] - ENTRY 14
2009-04-22 22:01:59,462 DEBUG [geotools.filter] - exporting SQL ComparisonFilter
2009-04-22 22:01:59,462 DEBUG [geotools.filter] - Filter type id is 14
2009-04-22 22:01:59,462 DEBUG [geotools.filter] - Filter type text is =
2009-04-22 22:01:59,462 DEBUG [geotools.filter] - exporting LiteralExpression
2009-04-22 22:01:59,462 DEBUG [geotools.filter] - exporting LiteralExpression
2009-04-22 22:01:59,462 DEBUG [data.jdbc] - sql is SELECT "ID",
"OBJFELS", "HRSZ", "FEKVES", "TERULET", "CIM_ID", "GEOM", "SZOMSZED"
FROM "FLX_UGYINT" WHERE 'HRSZ' = '45'

which reveals the problem, condition is always false. (column name
HRSZ shouldn't be in '' ) Where can be the problem?

thank you in advance, best regards: Balázs Bámer

ps: my info.xml file is
<featureType datastore = "szentendre_oracle" >
  <name>FLX_UGYINT</name>
  <alias>szentendre_ugyint</alias>
  
  <SRS>27200</SRS>
  <SRSHandling>0</SRSHandling>
  <title>FLX_UGYINT_Type</title>
  <abstract>Generated from szentendre_oracle</abstract>
  <wmspath>/</wmspath>
  <numDecimals value = "0" />
  <keywords>szentendre_oracle FLX_UGYINT</keywords>
  <latLonBoundingBox dynamic = "false" maxx = "139.24690274758518"
maxy = "-73.08902338427674" minx = "138.61705686477688" miny =
"-73.5234618989437" />
  <nativeBBox dynamic = "false" maxx="658275" maxy="266405"
minx="639558" miny="248542"/>
  
  <styles default = "polygon" />
  <cacheinfo enabled = "true" maxage = "3600" />
  <searchable enabled = "true" />
  <regionateAttribute value = "fekves" />
  <regionateStrategy value = "native-sorting" />
  <regionateFeatureLimit value = "15" />
  <maxFeatures>0</maxFeatures>
</featureType>

schema.xml is
<xs:complexType name = "szentendre_ugyint_Type" >
  <xs:complexContent >
    <xs:extension base = "gml:AbstractFeatureType" >
      <xs:sequence >
        <xs:element nillable = "false" name = "ID" maxOccurs = "1"
type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "OBJFELS" maxOccurs =
"1" type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "HRSZ" maxOccurs = "1"
type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "FEKVES" maxOccurs = "1"
type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "TERULET" maxOccurs =
"1" type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "CIM_ID" maxOccurs = "1"
type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "GEOM" maxOccurs = "1"
type = "gml:AbstractFeatureType" minOccurs = "1" />
        <xs:element nillable = "false" name = "SZOMSZED" maxOccurs =
"1" type = "gml:AbstractFeatureType" minOccurs = "1" />
      </xs:sequence>
    </xs:extension>
  </xs:complexContent>
</xs:complexType>