Hi Devs, Some time ago I created this issue: https://osgeo-org.atlassian.net/browse/GEOS-9392
In it is about Geoserver will never 'type' a column as Datetime when creating a layer from a gpkg. Resulting in not being able to use Geopackages in WMS-t/Dimensions. While sqlite does not have DATE and DATETIME types, gpkg has: http://www.geopackage.org/spec/#r5 According to Jukka (in the comments) Geoserver could try to get that info from a query, to be fired in the geopackage. The resulting 'CREATE TABLE' string then reveals if a column coud be used as DATETIME. I'm able to debug geoserver/geotools now, but am puzzled on where to put this kind of code: - in Geoserver, somewhere in Catalog parts: https://github.com/geoserver/geoserver/tree/master/src/main/src/main/java/org/geoserver/catalog - in Geotools (in geopkg/GeoPackage?) https://github.com/geotools/geotools/blob/master/modules/plugin/geopkg/src/main/java/org/geotools/geopkg/GeoPackage.java Sort of lost in the immense codebase. If anybody could give some hints that would be very much appreciated. Thanks in advance. Regards, Richard Duivenvoorde _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
