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.rahko...@maanmittauslaitos.fi> Gesendet: Freitag, 13. Oktober 2023 16:42 An: Yankov, Ivan <yank...@eba.bund.de>; mapserver-users@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-boun...@lists.osgeo.org> Puolesta Yankov, Ivan via MapServer-users Lähetetty: perjantai 13. lokakuuta 2023 11.17 Vastaanottaja: mapserver-users@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-boun...@lists.osgeo.org> Im Auftrag von Rahkonen Jukka via MapServer-users Gesendet: Donnerstag, 12. Oktober 2023 20:27 An: Holger Schiebold <hschieb...@codematix.de>; mapserver-users@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-boun...@lists.osgeo.org> Puolesta Holger Schiebold via MapServer-users Lähetetty: torstai 12. lokakuuta 2023 16.31 Vastaanottaja: mapserver-users@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@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users