From: Andrea A. <and...@al...> - 2006-08-26 08:24:58
|
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. Reading the mail, it also seems the "where" part of the filter should have been a bbox filter. Now, on gt2 trunk I do see this in SQLEncoderOracle: (btw, what version of Geoserver are you using?) try { short filterType = geomFilter.getFilterType(); if ((filterType == AbstractFilter.GEOMETRY_DWITHIN) || (filterType == AbstractFilter.GEOMETRY_BEYOND)){ doSdoDistance((GeometryDistanceFilter)geomFilter); //} else if (filterType == AbstractFilter.GEOMETRY_INTERSECTS //|| filterType == AbstractFilter.GEOMETRY_BBOX) { //doNotDisjointFilter(geomFilter); } else if (SDO_RELATE_MASK_MAP.get(new Short(geomFilter.getFilterType())) != null) { doSdoRelate(geomFilter); } else { LOGGER.warning("Unknown filter type: " + geomFilter.getFilterType()); } } catch (IOException e) { LOGGER.warning("IO Error exporting geometry filter"); } you see? the bbox encoding has been commented out for who knows what reason. That's why it does break! Opening a bug against this problem on JIRA. Sorry for the inconvenience... in the current state the Oracle data store is definitely unusable since the most basic and widely used filter is broken... Chris, once the bug is fixed is it possible to re-issue just the Oracle data store? Cheers Andrea |