more than one oraclespatial connection

[Merlijn Simonse]

Hi Bart,

Thanks for your reply.

I’ve already tried this DATA statement, but it doesn’t make any
difference. As soon as two layers are drawn in the requested scale the map
doesn’t get rendered anymore.

Both layers connect to the same database and the same table, can that be a
problem?

Kind regards,
Merlijn

>
> Hi Merlijn,
>
> I just tested in my setup and everything works fine when I
> have 2 layers connecting to Oracle with a different filter.
>
> Maybe you should change your DATA statement to something similar like:
>
> DATA "LOCATIE FROM (SELECT * FROM GEMEENTEN) USING UNIQUE ID
> SRID 90112"
>
> If you filter a dataset on an item, you need to include that
> column in your select.
>
> Best regards,
> Bart
>
> > Hi All,
> >
> > Yesterday I have installed the new Mapserver 4.4.1 windows
> binary with
> > oracle support. To test its performance I’ve first changed
> my slowest
> > layer to connect directly to OracleSpatial in stead of through OGR.
> > This is a very huge improvement. The map draws about 3 to 4
> times as
> > fast, WOW!. Enthusiastic as I was I also changed the other
> layers to
> > connect to OracleSpatial directly, but here my problem started. As
> > soon as more than one layer connects to OracleSpatial directly, the
> > map doesn’t finish rendering. On my server a gif-image
> (size is 0Kb)
> > is made. MapServ.exe keeps running (0 CPU) and the image is never
> > finished.
> >
> > These are my connection parameters:
> > LAYER
> >   CONNECTIONTYPE oraclespatial
> >   CONNECTION "user/pass at db”
> >   DATA "GEOM FROM LOCATIE USING UNIQUE LOCATIE_ID SRID 90112"
> >   FILTER "LOCATIESOORT_ID = 0"
> >
> >   ...
> >
> > END
> >
> > LAYER
> >   CONNECTIONTYPE oraclespatial
> >   CONNECTION "user/pass at db”
> >   DATA "GEOM FROM LOCATIE USING UNIQUE LOCATIE_ID SRID 90112"
> >   FILTER "LOCATIESOORT_ID = 1"
> >
> >   ...
> >
> > END
> >
> >
> > Does anyone have an idea if this is a bug or if I am forgetting
> > something in my mapfile?
> >
> > Thanks for any comments.
> >
> > Merlijn Simonse