Ok, i managed to get it working. Well the exception is still there but if this is the case i try to calculate the Envelope brute-force by going through all the features in the layer... This can be slow for layers with many features but for now this solution is good enough for me. (until i find a better one)
Blaz wrote: > > Ok, just one question. Since you have ArcSDE, can you replicate this bug? > > > > > Jody Garnett-2 wrote: >> >> Hi Blaz: >> >> While there is a module maintainer for ArcSDE volunteer time on this >> module is generally limited by access to an ArcSDE server to test >> against. Personally I only get to work on it when a customer is paying >> me - so I have an ArcSDE server to run the tests against. >> >> The good news is I have started some ArcSDE work with GeoServer and >> thus actually have an instance to hit; if you create a patch I would >> be in position to verify your fix and apply the patch. >> >> Jody >> >> On Thu, Mar 19, 2009 at 1:23 AM, Blaz <[email protected]> wrote: >>> >>> Hey all. I'm going crazy over this problem: >>> >>> http://jira.codehaus.org/browse/GEOT-2314 jira >>> >>> (I'm using Geoserver 1.7.3) >>> >>> I create a new ArcSde DataStore, then i try creating a new FeatureType. >>> But >>> when i press the Generate button i get this error described in jira >>> ([SDE >>> error -51][Error desc=DATABASE LEVEL ERROR OCCURRED.]...) >>> >>> After some debugging this is what i found out: >>> >>> in function: public Envelope calculateQueryExtent() in ArcSdeQuery class >>> >>> there's a line: extent = extentQuery.calculateLayerExtent(sdeQueryInfo); >>> and >>> this is where the exception jumps out. >>> >>> I also checked what happens on the database when this function gets >>> called. >>> A normal SQL gets created and sent: >>> >>> >>> SELECT 1 geom, >>> layer_tmp.objectid, >>> layer_tmp.geom.points, >>> layer_tmp.geom.numpts, >>> layer_tmp.geom.entity, >>> layer_tmp.geom.minx, >>> layer_tmp.geom.miny, >>> layer_tmp.geom.maxx, >>> layer_tmp.geom.maxy, >>> layer_tmp.ROWID >>> FROM schema.layer_tmp layer_tmp >>> WHERE st_envintersects (layer_tmp.geom, :1, :2, :3, :4) = 1 >>> >>> >>> If i execute this in toad all works fine. >>> >>> Is anyone working on this bug? >>> Or has anyone found a solution for this bug? >>> -- >>> View this message in context: >>> http://n2.nabble.com/ArcSde-problem-tp2497443p2497443.html >>> Sent from the geotools-devel mailing list archive at Nabble.com. >>> >>> >>> ------------------------------------------------------------------------------ >>> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are >>> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and >>> easily build your RIAs with Flex Builder, the Eclipse(TM)based >>> development >>> software that enables intelligent coding and step-through debugging. >>> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com >>> _______________________________________________ >>> Geotools-devel mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/geotools-devel >>> >> >> ------------------------------------------------------------------------------ >> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are >> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and >> easily build your RIAs with Flex Builder, the Eclipse(TM)based >> development >> software that enables intelligent coding and step-through debugging. >> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com >> _______________________________________________ >> Geotools-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> >> > > -- View this message in context: http://n2.nabble.com/ArcSde-problem-tp2497443p2503268.html Sent from the geotools-devel mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
