2
The simple way to do this is to use the gt-jdbc-postgis module to fetch your features from the database:
Map<String, Object> params = new HashMap<>();
params.put("dbtype", "postgis");
params.put("host", "localhost");
params.put("port", 5432);
params.put("schema", "public");
params.put("database", "database");
params....
1
This is a problem with handling EPSG:3857 in GDAL 3.X. You can run transformations with gdal 2.X and geoserver will read this file.
For example, you can use gdal_translate from folder "C:\OSGeo4W64\apps\gdal2\bin" if you use qgis from OSGeo4W.
Detail information on Geoserver`s JIRA:
https://osgeo-org.atlassian.net/browse/GEOS-9475
Only top voted, non community-wiki answers of a minimum length are eligible
