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 really looking for first is the answer on whether GeoServer has such limitation i.e. cannot see shared drives. If no such limitation exists then how do I fix this?
From: Jody Garnett <jody.garn...@gmail.com> Sent: 18 April 2024 18:50 To: Armando Forlani <armando.forl...@tfl.gov.uk> Cc: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] invisible mapped/share drives in Store creation 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 <armando.forl...@tfl.gov.uk<mailto:armando.forl...@tfl.gov.uk>> wrote: 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<file:///J:/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: path to 'J:\folder\data.gpkg': 'J:\' does not exist file:\\J:\folder\data.gpkg<file:///J:/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: path to 'J:\folder\data.gpkg': 'J:\' does not exist file:////DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg<file://DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file) file:\\\\DOMAIN.LOCAL\SHARED\shared_folder\folder\data.gpkg<file://DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file) It is also impossible making use of the ‘Browse…’ link next to the ‘database’ edit box. It won’t list any mapped drives in the drop down list. Only ‘Data directory’, ‘Home directory’, A:\, ‘OS Disk (C:)’, D:\ are shown. Moving data locally is not an option. Running: Windows 10 Enterprise VMware Virtual Platform Eclipse Adoptium: 17.0.10 (OpenJDK 64-Bit Server VM) GeoServer 2.24.2 as a Windows service Any help would be really appreciated. Thanks, Armando This message has been scanned for malware by Forcepoint. www.forcepoint.com<http://www.forcepoint.com/> _______________________________________________ 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 Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net> 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
