[MapServer-users] Cluster with Oracle Spatial data

[Rahkonen Jukka]

Hi,

It is a long time since I used Oracle Spatial but I could certainly read data with both the OGR and the native oraclespatial connection types. I think I used MS4W on Windows Server by then.

We would need more information than just "With the other connection methods no data is being read."
 Think about what other people would need for reproducing your issue and try give all that information in a systematic way.
- What Mapserver version and what GDAL (for the OGR option) you have, how did you install it?
- A simple but complete mapfile, at least a whole working LAYER block. It does not need to be the one that you use, a simplified version without irrelevant elements is always better for testing.
- Ideally test data that corresponds the LAYER.

I fear it will still be hard to find users who have Oracle available for testing.

-Jukka Rahkonen-


-----Alkuperäinen viesti-----
Lähettäjä: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Yankov, Ivan via MapServer-users
Lähetetty: maanantai 16. lokakuuta 2023 10.11
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hello,

I already tested the other oracle connection methods.
The difference with them is that the layer loads "normally" (when I use the plugin connection only the metadata part loads), but no data is being shown.
So with the plugin connection, the data is being read, but the cluster option causes the layer not to load apart from the metadata.
With the other connection methods no data is being read.

Regards

-----Ursprüngliche Nachricht-----
Von: Rahkonen Jukka <jukka.rahkonen at maanmittauslaitos.fi>
Gesendet: Freitag, 13. Oktober 2023 16:42
An: Yankov, Ivan <YankovI at eba.bund.de>; mapserver-users at lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

Please test if using OGR connectiontype makes any difference.

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Yankov, Ivan via MapServer-users
Lähetetty: perjantai 13. lokakuuta 2023 11.17
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

sure, here is he connection part:

include "../../db_connection/db_os.conf" -> this resolves to:

                CONNECTIONTYPE PLUGIN
                PLUGIN "oci"
                CONNECTION "OS/***@db_name"

Regards

-----Ursprüngliche Nachricht-----
Von: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Im Auftrag von Rahkonen Jukka via MapServer-users
Gesendet: Donnerstag, 12. Oktober 2023 20:27
An: Holger Schiebold <hschiebold at codematix.de>; mapserver-users at lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

Could you please mention always when you speak about Oracle Spatial data also which connection type you are using:
CONNECTIONTYPE oraclespatial or CONNECTIONTYPE OGR

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Holger Schiebold via MapServer-users
Lähetetty: torstai 12. lokakuuta 2023 16.31
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi Ivan,

sounds strange. How many features are in your datasource to be clustered? Do you see any load on your mapserver machine when you make a request?

Maybe that's a special case with your oracle data. Would you show as your mapfile - or the relevant parts?

The cluster option was developed by Tamas Szekeres in 2011 espacially for the service i noticed in my last answer. We were involved in the testing and maintained the service for a few years and had no special problem with oracle data and the cluster option. But it's a long time ago and maybe in newer version there is a problem.  Generally i agree with Jeff - this should work with every datasource.

Regards Holger



Am 12.10.2023 um 09:02 schrieb Yankov, Ivan via MapServer-users:
> Hi Holger,
>
> thanks for your feedback. All my services use the Oracle Spatial database, so there is no problem with the general connection to the database.
> Its just that the cluster option doesn't work for me when I use Oracle as datasource.
>
> The shape-layer that I described was only for test purposes because I wanted to see if I can get the cluster feature working at all.
> There seemed to be no issues with a shape source. The problem occurs only when I use my default datasource, which in my case is Oracle Spatial.
>
> Regards
> Ivan
_______________________________________________
_______________________________________________
MapServer-users mailing list
MapServer-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users