Re: [Geoserver-users] Antwort: Re: Antwort: Re: Antwort: Re: wfsGetFeature-Problem

[Andrea A. <and...@al...>]

Andrea Aime ha scritto:
> Brent Owens ha scritto:
>> I'm tagging Chris into this conversation since he knows the most about 
>> Oracle, and this appears to be a problem with your Oracle.
>>
>> Chris: Basically when he uses a WFS request against his shapefile 
>> feature types, it works, but when he does the same request against his 
>> Oracle feature type he gets the error.
> 
> Well here the problem is that the sql encoder does something wrong:
> 
> SELECT "PK_PTRAFFIC",
>  >>>>> "PUBTRAF_ID", "COUNTRY_ID", "CAT_ID", "NETWORK_ID", "DIR_ID",
>  >>>>> "FLOOR_ID", "CONST_ID", "FOREIGN_ID", "FOREIGNKEY", "MODDATE_A",
>  >>>>> "MODOPER_A", "MODDATE_G", "MODOPER_G", "CREATEDATE", "CREATEOPER",
>  >>>>> "GEOM" FROM "PUBLICTRAFFIC" WHERE
> 
> misses the where clause.

Oh hum, maybe I've been a little too quick in judging the nature of the error,
but anyways this happens because the sql encoder sees a filter it does support,
and then decides not to encode it for some reason.

Cheers
Andrea