Fantastic, i hope this fixes the problem. Please send mail to the list when you're done with patch reviewing/applying.
Gabriel Roldan wrote: > > 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 > > -- View this message in context: http://n2.nabble.com/ArcSde-problem-tp2497443p2505418.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
