more than one oraclespatial connection

[Merlijn Simonse]

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