Hi Ian,
By way of an update, and for anyone else who might see this, the issue boiled
down to a lack of a primary key on the table. As mentioned here, without a
primary key, Geoserver will regard the table as read-only. So you were
absolutely right: as far as Geoserver was concerned, the source was indeed
read-only.
Finally, to allow the index to be updated, the UseExistingSchema property had
to be set to false.
Thanks again,
Andy
On Friday, 4 November 2022 at 18:06:30 GMT, Andrew Chamberlain
<[email protected]> wrote:
Hi Ian,
Thanks for the prompt reply. Yes, the datastore is configured with the same
user with which I populate the index in the database.
In case it matters, I'm still on versions 9.6/2.5 for Postgres/Postgis.
Thanks,
Andy
On Friday, 4 November 2022 at 16:50:42 GMT, Ian Turton <[email protected]>
wrote:
Is your source writable by the user that GeoServer is using? I think that
error usually means it is read only.
Ian
On Fri, 4 Nov 2022, 16:40 Andrew Chamberlain via Geoserver-users,
<[email protected]> wrote:
Hi All,
Has anyone recently seen this when adding a granule to an imagemosaic?
java.lang.ClassCastException: org.geotools.jdbc.JDBCFeatureSource cannot be
cast to org.geotools.data.simple.SimpleFeatureStore
at
org.geotools.gce.imagemosaic.catalog.AbstractGTDataStoreGranuleCatalog.removeGranules(AbstractGTDataStoreGranuleCatalog.java:391)at
org.geotools.gce.imagemosaic.catalog.GTDataStoreGranuleCatalog.removeGranules(GTDataStoreGranuleCatalog.java:37)...
As far as I can tell from here, the JDBCFeatureSource doesn't directly
implement SimpleFeatureStore, so the above is understandable. What's not clear
is how this has come about.
My datastore.properties references an existing PostGIS datastore:
StoreName=postgres
SPI=org.geotools.data.postgis.PostgisNGDataStoreFactory
Any clues or pointers would be very much appreciated.
Thank you in advance,
Andy
Geoserver version: 2.20.4_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
