[Geoserver-devel] [JIRA] (GEOS-9266) Geopackage raster table with dots in the name cannot be added

“Failed to Retrieve User 557058:0a4da8ef-2b69-4bc7-96db-59a6b046f967” created an issue

GeoServer / BugGEOS-9266

Geopackage raster table with dots in the name cannot be added

Issue Type:

BugBug

Affects Versions:

2.15.1

Assignee:

Unassigned

Components:

geopackage

Created:

24/Jun/19 5:56 PM

Environment:

macOS Mojave, OpenJDK 8

Priority:

MediumMedium

Reporter:

“Failed to Retrieve User 557058:0a4da8ef-2b69-4bc7-96db-59a6b046f967”

If a Geopackage raster table name contains dots, it cannot be added as layer and will throw errors:

{{Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:///Users/stefan/sources/bigtiff/gpkg/relief.with.dots.gpkg and hints Hints: REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] System defaults: STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com FORCE_AXIS_ORDER_HONORING = http GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl COMPARISON_TOLERANCE = 1.0E-8
}}

Error log:

{{24 Jun 17:46:59 DEBUG [org.geotools.geopkg] - SELECT a.*, c.organization_coordsys_id, c.definition FROM gpkg_contents a, gpkg_spatial_ref_sys c WHERE a.srs_id = c.srs_id AND a.data_type = ?
24 Jun 17:46:59 WARN [org.geotools.geopkg.mosaic] - org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near “.”: syntax error)
java.io.IOException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near “.”: syntax error) at org.geotools.geopkg.GeoPackage.tiles(GeoPackage.java:1107)}}

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS


This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100105-sha1:87838dc)

Atlassian logo