[MapServer-users] Cluster with Oracle Spatial data

[Rahkonen Jukka]

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
_______________________________________________