more than one oraclespatial connection

[Bart van den Eijnden]

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

Hi Merlijn,

I don't think this is the problem, in my testcase I have the exact same
situation and it works fine.

What happens if you create two identical layers using a different name,
and first check if one the layer definitions works? Does it crash then as
well?

What's your environment (Windows/Linux) and are you using pre-compiled
binaries or your own binaries?

Best regards,
Bart

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