HI, There's a patch attached to another jira issue that is also related to this problem. I'm scheduling some time to review and apply the patch tomorrow though, so this will hopefully be fixed asap.
cheers, Gabriel Blaz wrote: > 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 >>> >>> >>> >> > > ------------------------------------------------------------------------------ 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
