more than one oraclespatial connection

[Bart van den Eijnden]

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
>
>