Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Jody Garnett
Here: https://www.sqlite.org/useovernet.html -- Jody Garnett On Thu, Apr 18, 2024 at 8:49 PM Armando Forlani wrote: > Hi Jody, > > I’m not sure I understand this. I regularly use these files (usually gpkg) > with QGIS doing read/write. All these files are on network file system (in > a shared

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Armando Forlani
Hi Jody, I’m not sure I understand this. I regularly use these files (usually gpkg) with QGIS doing read/write. All these files are on network file system (in a shared folder somewhere on the network) and have no problems at all. Even views I created within sqlite/gpkg files work fine. What I’m

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Jody Garnett
This is a limitation of the SQLite database, remember the driver is a full database, which places performance and reliability requirements on the file system that a network file system cannot meet. -- Jody Garnett On Thu, Apr 18, 2024 at 1:45 PM Armando Forlani wrote: > Hi, > > > > I’m

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Hannes Steinel via Geoserver-users
Hi,   in our environment, it is also not possible that GeoServer can browse different network drives. But copying the UNC path into the url box helps, for example: file://\\server\folder\data.gpkg We are not using the standalone version of GeoServer, but if i remember correctly, we had to grant

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Armando Forlani
Hi Andrea, None of that works, including the read_only option. I guess my question would be: is this a functionality shortcoming or is it my system that’s at fault somehow? Is GeoServer suppose to see shared/network folders/drives? Am I wasting my time with something it is not designed to work

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Andrea Aime
And oh, for the second error, the path can be accessed, but SQLITE states it cannot open the file. Maybe it's due to write permissions? Try checking the "read only" flag. Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://bit.ly/gs-services-us for more

Re: [Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Andrea Aime
HI Armando, the errors seem telling, "J: does not exist". If it's really there, then I would assume GeoServer is really not seeing it. See for example: https://superuser.com/questions/1758898/service-is-not-able-to-access-a-network-drive-mapping-despite-running-under-the Regards, Andrea Aime

Re: [Geoserver-users] MapBox style created with REST API

2024-04-18 Thread Andrea Aime
Hi Alexandre, while I don't have experience using MBStyle with the REST API, it seems odd, I would expect it only if raw was not present and set to true. Can you share both the request you're using, and the full stack trace (down to the last caused by please). Regards, Andrea Aime == GeoServer

[Geoserver-users] invisible mapped/share drives in Store creation

2024-04-18 Thread Armando Forlani
Hi, I’m creating a new Store using a GeoPackage file as data source (database). It works fine with a gpkg file saved locally i.e. anywhere on the C: drive. I’m unable to make it work with files stored on a share drive, either the full path or a logical drive letter. file://J:/folder/data.gpkg

Re: [Geoserver-users] [EXTERN!]: Re: Wrong time values for Oracle DATE columns

2024-04-18 Thread Calliess Daniel Ing .
Hi Ian, what exactly are you meaning with 'make the column a timestamp'? Because in GeoServer I already tried to change the data type to 'Timestamp' and that doesn't change anything. And in the Oracle database the DATE type also stores time values. From the documentation: "The fields that

Re: [Geoserver-users] Wrong time values for Oracle DATE columns

2024-04-18 Thread Ian Turton
That's the expected behaviour - if you need to preserve the time of the date make the column a timestamp (preferably with timezone) rather than a data which only stores the year, month and day. Ian On Thu, 18 Apr 2024 at 10:56, Calliess Daniel Ing. < daniel.calli...@stadt-salzburg.at> wrote: >

[Geoserver-users] Wrong time values for Oracle DATE columns

2024-04-18 Thread Calliess Daniel Ing .
Hi, I just discovered that GeoServer is rounding Oracle DATE attribute values down to zero or twelve hours when I'm publishing data from a 'Oracle NG (OCI)' data store. Examples: 1.1.2024 17:34:12 becomes 1.1.2024 12:00:00 or 1.1.2024 03:17:05 becomes 1.1.2024 00:00:00 This happens only when