Here: https://www.sqlite.org/useovernet.html
-- Jody Garnett On Thu, Apr 18, 2024 at 8:49 PM Armando Forlani <armando.forl...@tfl.gov.uk> 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 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> 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 > > 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 > > 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 > > 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 > > 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 > > _______________________________________________ > 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 > >
_______________________________________________ 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