[mapserver-users] MapServer and ArcSDE

[Lime, Steve D (MNIT)]

I'd say the other way around (beer that is)... ;-) Can you open a ticket so this change doesn't get lost? It needs to be pushed into the upcoming 6.4 release.

Steve

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Weisbender, Eric
Sent: Thursday, July 11, 2013 2:50 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] MapServer and ArcSDE

Hello List,

I'm making this post so that others may avoid the pain that I just went through.  We finaly have a working install of MapServer 6.2.1 compiled with GDAL 1.9 on 64 Bit Linux Red Hat 6 Enterprise displaying and querying data from ArcSDE 10.0.  At first the data displayed fine with a patch to the mapsde.c file from Steve Lime, thanks Steve.  The problem we struggled with for weeks was querying SDE.  After a lot of internet searching and sleepless nights I came across the blurb of code below that was the game changer.  We added this to the mods that Steve made to the mapsde.c file and presto.  Anyway if anyone want to know more you can contact me through the list or at my email below.

Steve, I owe you a beer.



void msSDELayerFreeItemInfo(layerObj *layer)

{

#ifdef USE_SDE

    msSDELayerInfo *sde = NULL;

    int i;

    if (!msSDELayerIsOpen(layer)) {

        msSetError( MS_SDEERR,

                    "SDE layer has not been opened.",

                    "msSDELayerFreeItemInfo()");

    }

    sde = layer->layerinfo;

    if (sde != NULL && sde->basedefs) {

        SE_table_free_descriptions(sde->basedefs);

        sde->basedefs = NULL;

    }

    if (sde != NULL && sde->joindefs) {

        SE_table_free_descriptions(sde->joindefs);

        sde->joindefs = NULL;

    }

    if (layer->iteminfo) {

        :


Thanks,

Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisbend at wapa.gov<mailto:weisbend at wapa.gov>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130711/555969f0/attachment.htm>