Hi Frank, glad you get it working and thanks for sharing!
so, to recap, it seems like you were making a query with a single spatial (bbox) filter but you weren't asking for the geometry attribute to be returned, hence this lead to the shape att not being requested and ArcSDE not using the spatial filter and giving inaccurate results? Or did I get it wrong? Also, if it's not asking for too much, could you please add a jira issue <http://jira.codehaus.org/browse/GEOT> for the data-arcsde module, assigned to me, explaining the issue and the resolution? It seems to me, if my understanding was correct, that whenever a spatial filter is used we should ask for the geometry attribute even if its not going to be used? best regards Gabriel FrankMcLean wrote: > Hi Gabriel, > > Well, after much back and forth with ESRI support, who cannot reproduce my > issue, even with my code, I found a workaround:- > > Make sure the SHAPE column is in the query list, whether you're going to use > it or not. > > The 'problem' was that my query does not care one bit about the shape of a > feature, just one of its attributes, meaning that I did not include the > SHAPE column in my query list. According to ESRI, this is perfectly fine > and the code I sent them produces the correct number of features in their > setup. In my environment, however, I only get the one feature returned. If > I ensure that all queries include the SHAPE column, whether or not this is > just fluff to subsequent code, the query runs fine - the right number of > features, delivered lightning fast. > > So I'm happy and my ulcer is shrinking. I should say that when I applied > this fix to my code, it became obvious that my previous 'fix' > (SE_ATTRIBUTE_FIRST) was producing some odd behaviour in other places, which > is another reason this practise should be discouraged (when used to > workaround oddness). > > I'm still talking to ESRI about a possible fix to the SDK, so I'll let you > know. > > Thanks, > > Frank > ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
